Check a table

Using cqlsh, the DESCRIBE TABLE command outputs the full details of a table, including all database objects the table contains. Use the output from the DESCRIBE command to recreate the table and all its components.

The output includes all settings for tables and other objects including the default settings. When recreating a table in another environment, verify that the settings are compatible.

Prerequisites

Keyspace created

Verify a table exists

DESCRIBE TABLE cycling.birthday_list;

Results

CREATE TABLE cycling.birthday_list (
    cyclist_name text PRIMARY KEY,
    blist map<text, text>
) WITH additional_write_policy = '99PERCENTILE'
    AND bloom_filter_fp_chance = 0.01
    AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
    AND comment = ''
    AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
    AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
    AND crc_check_chance = 1.0
    AND default_time_to_live = 0
    AND gc_grace_seconds = 864000
    AND max_index_interval = 2048
    AND memtable_flush_period_in_ms = 0
    AND min_index_interval = 128
    AND nodesync = {'enabled': 'true', 'incremental': 'true'}
    AND read_repair = 'BLOCKING'
    AND speculative_retry = '99PERCENTILE';

Check a table

Prerequisites

Verify a table exists

Was this helpful?

Give Feedback