Cassandra Cqlsh

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Cassandra CQLsh

Cassandra CQLsh stands for Cassandra CQL shell. CQLsh specifies how to use Cassandra commands. After installation, Cassandra provides a prompt Cassandra query language shell (cqlsh). It facilitates users to communicate with it.

Cassandra commands are executed on CQLsh. It looks like this:

Start CQLsh:

Cassandra CQLsh 1

CQLsh provides a lot of options which you can see in the following table:




This command is used to show help topics about the options of CQLsh commands.


it is used to see the version of the CQLsh you are using.


it is used for colored output.


It shows additional debugging information.


It is used to direct the shell to accept and execute a CQL command.

file= "file name"

By using this option, cassandra executes the command in the given file and exits.


It directs cassandra not to use colored output.

u "username"

Using this option, you can authenticate a user. The default user name is: cassandra.

p "password"

Using this option, you can authenticate a user with a password. The default password is: cassandra.