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
    • Windows installations: C:\Program Files\DataStax Community\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: