nodetool getsstables

Provides the SSTables that own the partition key.

Provides the SSTables that own the partition key.

Synopsis 

C:\> %CASSANDRA_HOME%\bin\nodetool <options> getsstables [(-hf | --hex-format)] -- <keyspace> <table> <key>
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:

C:\> %CASSANDRA_HOME%\bin\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
C:\> %CASSANDRA_HOME%\bin\nodetool getsstables keyspace1 standard1 3330394c344e35313730
CASSANDRA_HOME
Windows 3.0 installations C:\Program Files\Datastax Community\apache-cassandra\
Windows 3.x installations C:\Program Files\Datastax-DDC\apache-cassandra\
On a standard Windows installation, the installation wizard creates %CASSANDRA_HOME% as an environment variable.