Search code examples
cassandracqlcassandra-cli

How to inspect Cassandra table's internal structure without cassandra-cli?

As for Cassandra 3.0, the utility named "cassandra-cli" was removed. It allowed to see how the table is stored internally. Like here:

RowKey: title1
=> (name=, value=, timestamp=1393102991499000)
=> (name=author, value=Some Author, timestamp=1393102991499000)
=> (name=year, value=1993, timestamp=1393102991499000)
RowKey: title2
=> (name=, value=, timestamp=1393102991499100)
=> (name=author, value=Another Author, timestamp=1393102991499100)
=> (name=year, value=1987, timestamp=1393102991499100)

How to do that in Cassandra >= 3.0?

Solution

  • For Cassandra 3.0 they changed the sstable format and didn't update the tools for debugging the contents, so those tools were removed. See CASSANDRA-7464.

    If you read the comments, it looks like some people are working on an updated version of sstable2json for 3.x.