Connect with cqlsh

Open CQL interactive shell

cqlsh <host> 9042 -u cassandra -p cassandra
tool
cassandra15 commands
tags
cassandra

More cassandra commands

  • List keyspaces
    cqlsh -e 'DESCRIBE KEYSPACES'

    Show all keyspaces in the cluster

  • Repair keyspace
    nodetool repair -pr <keyspace>

    Run incremental repair on the primary range (use in maintenance)

  • Compaction stats
    nodetool compactionstats

    Show ongoing compaction operations and queue length

  • Flush table to disk
    nodetool flush <keyspace> <table>

    Force memtable flush to SSTables

  • Describe table
    cqlsh -e 'DESCRIBE TABLE <keyspace>.<table>'

    Show CREATE TABLE statement with all settings

all 15 cassandra commands