Was this page helpful?
Caution
You're viewing documentation for an unstable version of ScyllaDB Open Source. Switch to the latest stable version.
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]
Was this page helpful?