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?

  • 1
    Does stackoverflow.com/a/41333018/246260 help? – dezso Jun 21 '18 at 14:42
  • No, I followed all the steps as mentioned in the link you provided. Do not want to set auto_snapshot=false. My question is if we drop 10 tables, then are we live with the folders in the /data directory even if the tables are dropped? Is this normal behavior? – Bhupen Sinha Jun 21 '18 at 16:24
  • I believe the important point over there is that it will be the first compaction that removes your SSTables. This I base on some rusty memories, so take it carefully. – dezso Jun 21 '18 at 16:38
  • Did your directories already disappear? – dezso Sep 4 '18 at 8:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.