Cassandra cqlsh

1. cqlsh is a command line utility for issuing query statemets to cassandra or         altering schema's in cassandra.
                    install/bin/cqlsh

2. Some of the options that you can pass to the cqlsh command are                  

  
3. cqlsh has some commands that are not there in Cassandra Query Language
       Below are some such commands

4. Copying data to or from a specified table and csv file
       

5. Default keyspaces in Cassandra:
             a) system_traces
             b) system
          

6.  cqlsh commands and CQL commands
     

Cassandra Nodetool

Introduction to Cassandra Nodetool:

1. Nodetool is the command line utility for managing cassandra cluster.

             /install/bin/nodetool

2. Command to connect to the node other than that you are currently on use         the below command.

           $ bin/nodetool -h 'hostname' -p 'jmx_port' [command] [options]
               > jmx_port is configured in cassandra-env.sh
               > default jmx port is 7199.
          Example:  

3. Nodetool supports over 60 commands including:
         > status
         > info
         > ring 
            Example:

4. Sample outout of nodetool info command.

5.Additional nodetool commands