nodetool getsstables
Prints the SSTable that owns the partition key.
Prints 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. |
Italics |
Variable value. Replace with a valid option or user-defined value. |
[ ] |
Optional. Square brackets ( [ ] ) surround optional command
arguments. Do not type the square brackets. |
( ) |
Group. Parentheses ( ( ) ) identify a group to choose from. Do
not type the parentheses. |
| |
Or. A vertical bar ( | ) separates alternative elements. Type
any one of the elements. Do not type the vertical bar. |
... |
Repeatable. An ellipsis ( ... ) indicates that you can repeat
the syntax element as often as required. |
'Literal string' |
Single quotation ( ' ) marks must surround literal strings in
CQL statements. Use single quotation marks to preserve upper case. |
{ key:value } |
Map collection. Braces ( { } ) enclose map collections or key
value pairs. A colon separates the key and the value. |
<datatype1,datatype2> |
Set, list, map, or tuple. Angle brackets ( < > ) enclose
data types in a set, list, map, or tuple. Separate the data types with a comma.
|
cql_statement; |
End CQL statement. A semicolon ( ; ) terminates all CQL
statements. |
[ -- ] |
Separate the command line options from the command arguments with two hyphens (
-- ). This syntax is useful when arguments might be mistaken for
command line options. |
' <schema> ... </schema>
' |
Search CQL only: Single quotation marks ( ' ) surround an entire
XML schema declaration. |
@xml_entity='xml_entity_type' |
Search CQL only: Identify the entity and literal value to overwrite the XML element in the schema and solrconfig files. |
Definition
The short form and long form parameters 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 user name for authenticating with secure JMX.
Command arguments
--
- Separates an option from an argument that could be mistaken for a 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 key
nodetool getsstables cycling cyclist_name fb372533-eb95-4bb4-8685-6ef61e994caa
The result is:
/var/lib/cassandra/data/cycling/comments-b6239e719c0411e8a6f11f56fd0aa24a/aa-3-bti-Data.db
The hex string representation of the partition key is useful to resolve errors. For
example, find out which SSTable owns the faulty partition key for this
exception:
java.lang.AssertionError: row DecoratedKey(2769066505137675224, 00040000002e00000800000153441a3ef000) received out of order wrt DecoratedKey(2774747040849866654, 00040000019b0000080000015348847eb200)
When
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 00040000002e00000800000153441a3ef000
/var/lib/cassandra/data/cycling/comments-b6239e719c0411e8a6f11f5cd5459987/aa-2-bti-Data.db
Get the SSTables by specifying the full primary key
nodetool getsstables cycling rank_by_year_and_name "2014:4th Tour of Beijing"
/var/lib/cassandra/data/cycling/comments-b6239e719c0411e8a6f11f5cd5459987/aa-2-bti-Data.db