Write CQL output to a file

1. Create a file (say cquery.txt) with any cassandra queries.. For ex. given below

use system;

select * from schema_keyspaces;

2. Run either of the following commands to achieve desired output

<cassandra_home>/bin/cqlsh -f cquery.txt > cquery.out

<cassandra_home>/bin/cqlsh --file=cquery.txt > cquery.out

How to list all the key spaces in Cassandra?

use system;

select * from schema_keyspaces;

How to list all the tables in a key space in Cassandra?

Its as simple as these 2 steps

1. use <keyspace_name>;

2. describe tables;