Describe table

Show CREATE TABLE statement with all settings

cqlsh -e 'DESCRIBE TABLE <keyspace>.<table>'
tool
cassandra15 commands
tags
cassandra

More cassandra commands

  • Check node status
    nodetool status

    Show cluster ring with status, load and ownership

  • Check compaction stats
    nodetool compactionstats

    Show pending and active compaction tasks

  • Run CQL from cqlsh
    cqlsh -u cassandra -p cassandra -e 'DESCRIBE KEYSPACES;'

    Execute a CQL statement non-interactively

  • Check table stats
    nodetool tablestats mykeyspace.mytable

    Show read/write latencies and SSTable count for a table

  • Repair a keyspace
    nodetool repair -full mykeyspace

    Full repair to sync all replicas for a keyspace

all 15 cassandra commands