76

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:

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

Options	Usage
help	This command is used to show help topics about the options of CQLsh commands.
version	it is used to see the version of the CQLsh you are using.
color	it is used for colored output.
debug	It shows additional debugging information.
execute	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.
no-color	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.

---