nodetool getsstables

Provides the SSTables that own the partition key.

Synopsis

nodetool <options> getsstables [(-hf | --hex-format)] -- <keyspace> <table> <key>

Cassandra tarball installations:

installation_location/cassandra/bin

Table 1. 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