nodetool getsstables

Provides the SSTables that own the partition key.

Provides the SSTables that own the partition key.

Synopsis 

nodetool <options> getsstables [(-hf | --hex-format)] -- <keyspace> <table> <key>
DataStax Enterprise 5.0 Installer No-Services and tarball installations:
installation_location/resources/cassandra/bin
Options
Short Long Description
-h --host Hostname or IP address.
-p --port Port number.
-pwf --password-file Password file path.
-pw --password Password.
-u --username Remote JMX agent username.
keyspace Name of keyspace.
table One or more table names, separated by a space.
key Partition key of the SSTables.
-- Separates an option from an argument that could be mistaken for a option.

Description 

This command can be used to retrieve an SSTable.

Examples 

An example of this command retrieves the SSTable for cycling.cyclist_name with the key argument fb372533-eb95-4bb4-8685-6ef61e994caa for one of the cyclists listed:

nodetool getsstables cycling cyclist_name 'fb372533-eb95-4bb4-8685-6ef61e994caa' 
The output is:
/homedir/datastax-ddc-3.6.0/data/data/cycling/cyclist_name-612a64002ec211e6a92457e568fce26f/ma-1-big-Data.db
nodetool getsstables keyspace1 standard1 3330394c344e35313730