Some of the commonly used Cassandra CQLs
1. List all the keyspaces in Cassandra
2. List all the tables in a keyspace
3. How to dump CQL output on to a file
Link to an exhaustive list of CQL query examples
http://cassandra.apache.org/doc/cql/CQL.html
Below is the snip of how the CShell would look like
1. List all the keyspaces in Cassandra
use system; select * from schema_keyspaces;
2. List all the tables in a keyspace
use {keyspace_name}; describe tables;
3. How to dump CQL output on to a file
{cassandra_home}/bin/cqlsh -f cquery.txt > cquery.out
Link to an exhaustive list of CQL query examples
http://cassandra.apache.org/doc/cql/CQL.html
Below is the snip of how the CShell would look like