Cassandra Cqlshο
Cassandra Query Language (CQL)
Options | Usage |
---|---|
cqlsh --help | Shows help topics about the options of cqlsh commands. |
cqlsh --version | Provides the version of the cqlsh you are using. |
cqlsh --color | Directs the shell to use colored output. |
cqlsh --debug | Shows additional debugging information. |
cqlsh --execute cql_statement | Directs the shell to accept and execute a CQL command. |
cqlsh --file= βfile nameβ | If you use this option, Cassandra executes the command in the given file and exits. |
cqlsh --no-color | Directs Cassandra not to use colored output. |
cqlsh -u βuser nameβ | Using this option, you can authenticate a user. The default user name is: cassandra. |
cqlsh -p βpass wordβ | Using this option, you can authenticate a user with a password. The default password is: cassandra. |
Documented Shell Commandsο
Given below are the Cqlsh documented shell commands. These are the commands used to perform tasks such as displaying help topics, exit from cqlsh, describe,etc.
HELP
β Displays help topics for all cqlsh commands.CAPTURE
β Captures the output of a command and adds it to a file.CONSISTENCY
β Shows the current consistency level, or sets a new consistency level.COPY
β Copies data to and from Cassandra.DESCRIBE
β Describes the current cluster of Cassandra and its objects.EXPAND
β Expands the output of a query vertically.EXIT
β Using this command, you can terminate cqlsh.PAGING
β Enables or disables query paging.SHOW
β Displays the details of current cqlsh session such as Cassandra version, host, or data type assumptions.SOURCE
β Executes a file that contains CQL statements.TRACING
β Enables or disables request tracing.
CQL Data Definition Commandsο
CREATE KEYSPACE
β Creates a KeySpace in Cassandra.USE
β Connects to a created KeySpace.ALTER KEYSPACE
β Changes the properties of a KeySpace.DROP KEYSPACE
β Removes a KeySpaceCREATE TABLE
β Creates a table in a KeySpace.ALTER TABLE
β Modifies the column properties of a table.DROP TABLE
β Removes a table.TRUNCATE
β Removes all the data from a table.CREATE INDEX
β Defines a new index on a single column of a table.DROP INDEX
β Deletes a named index.
CQL Data Manipulation Commandsο
INSERT
β Adds columns for a row in a table.UPDATE
β Updates a column of a row.DELETE
β Deletes data from a table.BATCH
β Executes multiple DML statements at once.
CQL Clausesο
SELECT
β This clause reads data from a tableWHERE
β The where clause is used along with select to read a specific data.ORDERBY
β The orderby clause is used along with select to read a specific data in a specific order.