sstabledump 

Dump the contents of the specified SSTable in JSON format

This tool outputs the contents of the specified SSTable in the JSON format.

Depending on your task, you may wish to flush the table to disk (using nodetool flush)before dumping its contents.

Usage:

  • Package installations:
    $ sstabledump [options]  sstable_file
  • Tarball installations:
    $ cd install_location
    $ bin/sstabledump [options] 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
Options
Flag Description
-d Outputs an internal representation, one CQL row per line.
-e Limits output to the list of keys.
-k key Limits output to information about the row identified by the specified key.
-xkey Excludes information about the row identified by the specified key from output.