Run CQL with cqlsh
Run a CQL statement without opening the interactive shell
cqlsh -u cassandra -p cassandra -e 'DESCRIBE KEYSPACES;'
More cassandra commands
-
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
-
nodetool gossipinfoShow the gossip state of all nodes (for debugging)
-
nodetool flush mykeyspaceForce in-memory data to be written to SSTables
-
nodetool statusShow ring topology, load, state, and host IDs