sstablelevelreset

Uses LeveledCompactionStrategy to reset the level to zero on a set of SSTables while the HCD 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.

Restriction: Stop HCD before you run this command.

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

Package installations: /usr/bin/
Tarball installations: <installation_location>/resources/cassandra/tools/bin

Synopsis

sstablelevelreset
[--really-reset]
<keyspace_name> <table_name>

The short form and long form parameters are comma-separated.

Command arguments

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

Examples

Verify HCD 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\