sstablekeys

The sstablekeys utility dumps table keys.

The sstablekeys utility dumps table keys.

Usage:
  • Package installations: $ sstablekeys sstable_name
  • Tarball installations: 
    cd install_location/tools
$ bin/sstablekeys sstable_name

Procedure

  1. If data has not been previously flushed to disk, manually flush it. For example: 
    nodetool flush cycling cyclist_name
  2. To list the keys in an SSTable, find the name of the SSTable file.
    The file is located in the data directory and has a .db extension.
    • Package installations: /var/lib/cassandra/data
    • Tarball installations: install_location/data/data
  3. Look at keys in the SSTable data. For example, use sstablekeys followed by the path to the data. Use the path to data for your Cassandra installation: 
    ## Package installations
$ sstablekeys /var/lib/cassandra/data/cycling/cyclist_name-a882dca02aaf11e58c7b8b496c707234/la-1-big-Data.db

## Tarball installations
$ sstablekeys install_location/data/data/cycling/cyclist_name-a882dca02aaf11e58c7b8b496c707234/la-1-big-Data.db

    The output appears, for example: