Verifying table properties
In cqlsh, use the DESCRIBE
command to view table properties:
DESCRIBE TABLE employee;
This output shows that the table uses DSE In-Memory:
CREATE TABLE employee ( uid text PRIMARY KEY, fname text, lname text ) WITH bloom_filter_fp_chance = 0.01 AND caching = '{"keys":"NONE", "rows_per_partition":"NONE"}' AND comment = '' AND compaction = {'min_threshold': '4', 'class': 'org.apache.cassandra.db.compaction.MemoryOnlyStrategy', 'max_threshold': '32'} AND compression = {} 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'} AND speculative_retry = '99.0PERCENTILE';