sstableutil

Lists SSTable files for the provided table.

The default location of this SSTable tool depends on the type of installation:

Package installations: /usr/bin/
Tarball installations: <installation_location>/resources/cassandra/tools/bin

Synopsis

sstableutil
[-c] [-d] [-h] [-o]
[-t <type>] [-v]
<keyspace_name> <table_name>

Definition

The short form and long form parameters are comma-separated.

Command arguments

-c, --cleanup

Removes remaining transactions from incomplete compactions or writes.

-d, --debug

Display stack traces.

-h, --help

Display the usage and listing of the commands.

keyspace_name

Keyspace name. Required.

-o, --oplog

Include operation logs.

table_name

Table name. Required.

-t, --type type

Type of files:

all - all final and temporary files
tmp - only temporary files
final - only final files

-v,--verbose

Verbose output.

Examples

List SSTables files for comments table on cycling keyspace

sstableutil cycling comments

Listing files...
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-1-bti-CompressionInfo.db
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-1-bti-Data.db
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-1-bti-Digest.crc32
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-1-bti-Filter.db
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-1-bti-Partitions.db
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-1-bti-Rows.db
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-1-bti-Statistics.db
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-1-bti-TOC.txt
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-2-bti-CompressionInfo.db
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-2-bti-Data.db
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-2-bti-Digest.crc32
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-2-bti-Filter.db
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-2-bti-Partitions.db
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-2-bti-Rows.db
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-2-bti-Statistics.db
/var/lib/cassandra/data/cycling/comments-eae06ce2ce4211e8949e33016bf887c0/aa-2-bti-TOC.txt