= sstablelevelreset

If LeveledCompactionStrategy is set, this script can be used to reset
level to 0 on a given set of sstables. This is useful if you want to,
for example, change the minimum sstable size, and therefore restart the
compaction process using this new configuration.

See
http://cassandra.apache.org/doc/latest/operating/compaction.html#leveled-compaction-strategy
for information on how levels are used in this compaction strategy.

Cassandra must be stopped before this tool is executed, or unexpected
results will occur. Note: the script does not verify that Cassandra is
stopped.

ref: https://issues.apache.org/jira/browse/CASSANDRA-5271

== Usage

sstablelevelreset --really-reset <keyspace> <table>

The really-reset flag is required, to ensure this intrusive command is
not run accidentally.

== Table not found

If the keyspace and/or table is not in the schema (e.g., if you
misspelled the table name), the script will return an error.

Example:

....
ColumnFamily not found: keyspace/evenlog.
....

== Table has no sstables

Example:

....
Found no sstables, did you give the correct keyspace/table?
....

== Table already at level 0

The script will not set the level if it is already set to 0.

Example:

....
Skipped /var/lib/cassandra/data/keyspace/eventlog-65c429e08c5a11e8939edf4f403979ef/mc-1-big-Data.db since it is already on level 0
....

== Table levels reduced to 0

If the level is not already 0, then this will reset it to 0.

Example:

....
sstablemetadata /var/lib/cassandra/data/keyspace/eventlog-6365332094dd11e88f324f9c503e4753/mc-8-big-Data.db | grep -i level
SSTable Level: 1

sstablelevelreset --really-reset keyspace eventlog
Changing level from 1 to 0 on /var/lib/cassandra/data/keyspace/eventlog-6365332094dd11e88f324f9c503e4753/mc-8-big-Data.db

sstablemetadata /var/lib/cassandra/data/keyspace/eventlog-6365332094dd11e88f324f9c503e4753/mc-8-big-Data.db | grep -i level
SSTable Level: 0
....