sstablelevelreset

Uses LeveledCompactionStrategy (LCS) to reset the level to zero on a set of SSTables while the DataStax Enterprise (DSE) node is offline. If the SSTable is already at level 0, no change occurs. If the SSTable is releveled, the metadata is rewritten to designate the level at 0.

Stop DSE before you run this command.

The default location of this SSTable tool depends on the type of installation:

Package installations: /usr/share/dse/cassandra/tools
Tarball installations: INSTALL_DIRECTORY/resources/cassandra/bin

Synopsis

sstablelevelreset --really-reset KEYSPACE_NAME TABLE_NAME

Options

keyspace_name: Keyspace name. Required.
--really-reset: Specifies that DSE is stopped.
table_name: Table name. Required.

Examples

Verify DataStax Enterprise is not running:

nodetool status

Datacenter: Graph
================================
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
--  Address        Load       Tokens       Owns    Host ID                               Rack
UN  10.200.177.92  265.04 KiB  1            ?       980cab6a-2e5d-44c6-b897-0733dde580ac  rack1
DN  10.200.177.94  426.21 KiB  1            ?       7ecbbc0c-627d-403e-b8cc-a2daa93d9ad3  rack1

Reset cyclist_name to level 0:

sstablelevelreset cycling cyclist_name

Skipped /var/lib/cassandra/data/cycling/cyclist_name-4157ef22ce4411e8949e33016bf887c0/aa-2-bti-Data.db since it is already on level 0
Skipped /var/lib/cassandra/data/cycling/cyclist_name-4157ef22ce4411e8949e33016bf887c0/aa-3-bti-Data.db since it is already on level 0

sstablelevelreset

Synopsis

Options

Examples

Was this helpful?

Give Feedback