Run CQL from cqlsh

Execute a CQL statement non-interactively

cqlsh -u cassandra -p cassandra -e 'DESCRIBE KEYSPACES;'
tool
cassandra15 commands
tags
cassandra

More cassandra commands

  • 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

  • Get gossip info
    nodetool gossipinfo

    Show gossip state for all nodes (debug)

  • Flush memtables to disk
    nodetool flush mykeyspace

    Force flush in-memory data to SSTables

  • Nodetool status
    nodetool status

    Show ring topology, load, state, and host IDs

all 15 cassandra commands