Describe a table
Show the CREATE TABLE statement with all settings
cqlsh -e 'DESCRIBE TABLE <keyspace>.<table>'
More cassandra commands
-
nodetool statusShow the ring: node state, load and host IDs
-
nodetool compactionstatsShow running compactions and the queue length
-
cqlsh -u cassandra -p cassandra -e 'DESCRIBE KEYSPACES;'Run a CQL statement without opening the interactive shell
-
nodetool tablestats mykeyspace.mytableShow read and write latency and the SSTable count for a table
-
nodetool repair -full mykeyspaceRun a full repair to sync all replicas of a keyspace