nodetool getsstables
Provides the SSTables that own the partition key.
Synopsis
nodetool <options> getsstables [(-hf | --hex-format)]
-- <keyspace> <table> <key>Tarball and Installer No-Services path:
<installation_location>/resources/cassandra/bin| Short | Long | Description |
|---|---|---|
|
|
Hostname or IP address. |
|
|
Port number. |
|
|
Password file path. |
|
|
Password. |
|
|
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 an option. |
|
Description
This command can be used to retrieve an SSTable.
Examples
The following example of this command retrieves the SSTable for cycling.cyclist_name with the key argument fb372533-eb95-4bb4-8685-6ef61e994caa, which is the id for one of the cyclists listed in the cyclist_name table:
nodetool getsstables cycling cyclist_name 'fb372533-eb95-4bb4-8685-6ef61e994caa'The output is:
/var/lib/cassandra/data/cycling/cyclist_name-612a64002ec211e6a92457e568fce26f/ma-1-big-Data.dbSometimes it’s useful to retrieve an SSTable from the hex string representation of its key, for instance, when you get this exception and you want to find out which SSTable owns the faulty key:
java.lang.AssertionError: row DecoratedKey(2769066505137675224, 00040000002e00000800000153441a3ef000) received out of order wrt DecoratedKey(2774747040849866654, 00040000019b0000080000015348847eb200)The nodetool getsstables command will only work if the primary key of the given table is a blob.
nodetool getsstables keyspace table_name 00040000002e00000800000153441a3ef000Use the --hex-key option to retrieve the DecoratedKey from the hexstr representation of the key:
nodetool getsstables ks cf --hex-key 00040000002e00000800000153441a3ef000nodetool getsstables keyspace1 standard1 3330394c344e35313730