SSTabledump

This tool allow 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 recommanded to use this tool in production cluster.

Use the full path when executing the command.

For example:

sstabledump /var/lib/scylla/data/keyspace1/standard1-7119946056b211e98e85000000000001

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" }
      ]
    }
  ]