> > Oh. So our data is all messed up now because of the “nodetool compact” I > ran. > > > > Hi Erick. Thanks for the quick reply. > > > > I just want to be sure about compact. I saw Cassandra will do compaction > by itself even when I do not run “nodetool compact” manually (nodetool > compactionstats always has some compaction running). So this automatic > compact by Cassandra will clean up the tombstoned data files? >
They won't "compact", but will rather just be deleted once all the data in the file passes its expiration time. > Another question I have is, is there a way to un-mess my messed up data > now? > Not really. The easiest way would be to re-insert all your data. If you're not having any read performance issues you might be better just waiting the 7 days until the large SSTable is dropped. -- raft.so - Cassandra consulting, support, and managed services