nodetool getsstables
Returns the SSTable that owns the partition key.
Synopsis
nodetool [<connection_options>] getsstables
[-hf] [--] <keyspace_name> <table_name> <partition_key>| Syntax conventions | Description | 
|---|---|
| UPPERCASE | Literal keyword. | 
| Lowercase | Not literal. | 
| 
 | Variable value. Replace with a valid option or user-defined value. | 
| 
 | Optional.
Square brackets (  | 
| 
 | Group.
Parentheses (  | 
| 
 | Or.
A vertical bar (  | 
| 
 | Repeatable.
An ellipsis (  | 
| 
 | Single quotation (  | 
| 
 | Map collection.
Braces (  | 
| 
 | Set, list, map, or tuple.
Angle brackets (  | 
| 
 | End CQL statement.
A semicolon (  | 
| 
 | Separate the command line options from the command arguments with two hyphens (  | 
| 
 | Search CQL only: Single quotation marks (  | 
| 
 | Search CQL only: Identify the entity and literal value to overwrite the XML element in the schema and solrconfig files. | 
Definition
The short- and long-form options are comma-separated.
Connection options
- -h, --host hostname
- 
The hostname or IP address of a remote node or nodes. When omitted, the default is the local machine. 
- -p, --port jmx_port
- 
The JMX port number. 
- -pw, --password jmxpassword
- 
The JMX password for authenticating with secure JMX. If a password is not provided, you are prompted to enter one. 
- -pwf, --password-file jmx_password_filepath
- 
The filepath to the file that stores JMX authentication credentials. 
- -u, --username jmx_username
- 
The username for authenticating with secure JMX. 
Command arguments
- --
- 
Separates an option from an argument that could be mistaken for an option. 
- -hf, --hex-format
- 
Specify the key in hexadecimal string format. 
- key
- 
Partition key of the end points you want to get. 
- keyspace_name
- 
The keyspace name. 
- table_name
- 
The table name. 
Examples
Get the SSTable that owns the given partition
nodetool getsstables cycling cyclist_name fb372533-eb95-4bb4-8685-6ef61e994caaResults:
/var/lib/cassandra/data/cycling/comments-b6239e719c0411e8a6f11f56fd0aa24a/aa-3-bti-Data.dbThe hex string representation of the partition key is useful to resolve errors, such as which SSTable owns the faulty partition key for this exception:
nodetool getsstables -hf cycling stats 00040000002e00000800000153441a3ef000Results:
/var/lib/cassandra/data/cycling/comments-b6239e719c0411e8a6f11f5cd5459987/aa-2-bti-Data.dbWhen the primary key of the given table is a blob, get the DecoratedKey from the hexidecimal representation of the partition key:
nodetool getsstables -hf cycling stats 00040000002e00000800000153441a3ef000Results:
/var/lib/cassandra/data/cycling/comments-b6239e719c0411e8a6f11f5cd5459987/aa-2-bti-Data.dbGet the SSTables by specifying the full primary key
nodetool getsstables cycling rank_by_year_and_name "2014:4th Tour of Beijing"Results:
/var/lib/cassandra/data/cycling/comments-b6239e719c0411e8a6f11f5cd5459987/aa-2-bti-Data.db