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:
  • Cassandra Package installations: $ sstablelevelreset [--really-reset] keyspace table
  • Cassandra Tarball installations:
    $ cd install_location/tools
    $ bin/sstablelevelreset [--really-reset] keyspace table
  • DataStax Enterprise 4.8 tarball installations:
    $ cd install_location/resources/cassandra/tools
    
    $ bin/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.
$ 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.