sstablelevelreset

The sstablelevelreset utility will reset the level to 0 on a given set of SSTables.

Reset level to 0 on a given set of SSTables that use LeveledCompactionStrategy.

Usage:
C:\> cd %CASSANDRA_HOME%
C:\> sstablelevelreset [--really-reset] keyspace table
The option --really-reset is a warning that Cassandra is stopped before the tool is run.

Procedure

Stop Cassandra on the node. Choose a keyspace and table to reset to level 0. 
C:\> %CASSANDRA_HOME%\tools\bin\sstablelevelreset --really-reset cycling cyclist_name

If the designated table is already at level 0, then no change occurs. If the SSTable is releveled, the metadata is rewritten to designate the level to 0.

Example

CASSANDRA_HOME
Windows 3.0 installations C:\Program Files\Datastax Community\apache-cassandra\
Windows 3.x installations C:\Program Files\Datastax-DDC\apache-cassandra\
On a standard Windows installation, the installation wizard creates %CASSANDRA_HOME% as an environment variable.