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:
sstabledump [options]  sstable_file
Tarball and Installer No-Services path:
installation_location/resources/cassandra/tools/bin

The output file is located in the /var/lib/cassandra/data directory and has a .db extension.

Table 1. 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.