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:

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.