PAGING − Enables or disables query paging. HELP − Displays help topics for all cqlsh commands.ĬAPTURE − Captures the output of a command and adds it to a file.ĬONSISTENCY − Shows the current consistency level, or sets a new consistency level.ĬOPY − Copies data to and from Cassandra.ĭESCRIBE − Describes the current cluster of Cassandra and its objects.ĮXPAND − Expands the output of a query vertically.ĮXIT − Using this command, you can terminate cqlsh. These are the commands used to perform tasks such as displaying help topics, exit from cqlsh, describe,etc. Given below are the Cqlsh documented shell commands. The default password is: cassandra.Ĭqlsh has a few commands that allow users to interact with it. Using this option, you can authenticate a user with a password. Using this option, you can authenticate a user. If you use this option, Cassandra executes the command in the given file and exits.ĭirects Cassandra not to use colored output. Provides the version of the cqlsh you are using.ĭirects the shell to accept and execute a CQL command. Shows help topics about the options of cqlsh commands. The following table explains all the options of cqlsh and their usage. In addition, it supports a few more options as well. It gives the Cassandra cqlsh prompt as bin]$ cqlshĬonnected to Test Cluster at 127.0.0.1:9042.Ĭqlsh − As discussed above, this command is used to start the cqlsh prompt. Start cqlsh using the command cqlsh as shown below.
Using this shell, you can execute Cassandra Query Language (CQL).
Install cqlsh for cassandra 2.1 mac how to#
This chapter introduces the Cassandra query language shell and explains how to use its commands.īy default, Cassandra provides a prompt Cassandra query language shell (cqlsh) that allows users to communicate with it.