SSTabledump

This tool allows you to converts SSTable into a JSON format file. SSTabledump supported when using Scylla 3.0, Scylla Enterprise 2019.1, and newer versions. In older versions, the tool is named SSTable2json.

Note

It is not recommended to use this tool in the production cluster.

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]