Dropping a table does not delete the directories on the disk

cassandra

I am just testing the drop table command in Cassandra 3.11. The sequence is as follows:

  1. Load data worth 10gb
  2. drop the table
  3. on the node,
    • nodetool flush
    • nodetool clearsnapshot
    • nodetool cleanup

Still I see those SSTables directory under the data folder (using default auto_snapshot = true).

select count(*) .. shows ZERO, which is correct.

Why the folders are not getting deleted?

Best Answer

Did you clear the snapshot of all clusters?

Clear it with

nodetool -h <ip address> -p <port> clearsnapshot
Related Question