Was this page helpful?
Caution
You're viewing documentation for a previous version. Switch to the latest stable version.
SSTabledump¶
Warning
SSTabledump is deprecated since ScyllaDB 5.4, and will be removed in a future release. Please consider switching to ScyllaDB SSTable.
This tool allows you to converts SSTable into a JSON format file. If you need more flexibility or want to dump more than just the data-component, see scylla-sstable.
Use the full path to the data file when executing the command.
For example:
sstabledump /var/lib/scylla/data/keyspace1/standard1-7119946056b211e98e85000000000001/mc-12-big-Data.db
Example output:
[
{
"partition" : {
"key" : [ "3137343334334f4f4d30" ],
"position" : 0
},
"rows" : [
{
"type" : "static_block",
"position" : 281,
"cells" : [
{ "name" : "\"C0\"", "value" : "0xb7789e7cdf2af541061f207714a3b8e14c72f74e663bd5c2577ac329bcb3161cf10c", "tstamp" : "2019-04-04T08:22:24.336001Z" },
{ "name" : "\"C1\"", "value" : "0xe8ed77f078a23e37f8a7246ccd8cd4099585c7031e242529e5070246860d7a1b1e85", "tstamp" : "2019-04-04T08:22:24.336001Z" },
{ "name" : "\"C2\"", "value" : "0x3b836d4333d2d5a02a63ced47596bfb5f80ecb8e80686061c3daaba87380994b7b61", "tstamp" : "2019-04-04T08:22:24.336001Z" },
{ "name" : "\"C3\"", "value" : "0x9220219581df87ff131306b8bf793c14ae8ebf8c8af1b638827ebfcab85660a378b8", "tstamp" : "2019-04-04T08:22:24.336001Z" },
{ "name" : "\"C4\"", "value" : "0x5b4c972cdeb330035b82dc0b1daa9051fff7956d45e3c6c2b21dfb1fd2bb43fb1146", "tstamp" : "2019-04-04T08:22:24.336001Z" }
]
}
]
NOTE:
When running as a user that is not root or scylla an error (java traceback) might be observed.
To work around the error, please use the following syntax:
cassandra_storagedir="/tmp" sstabledump [filename]