Or Upgrade to a version with https://issues.apache.org/jira/browse/CASSANDRA-13418 and enable that feature
-- Jeff Jirsa > On Mar 26, 2019, at 6:23 PM, Rahul Singh <rahul.xavier.si...@gmail.com> wrote: > > What's your timewindow? Roughly how much data is in each window? > > If you examine the sstable data and see that is truly old data with little > chance that it has any new data, you can just remove the SStables. You can do > a rolling restart -- take down a node, remove mc-254400-* and then start it > up. > > > rahul.xavier.si...@gmail.com > > http://cassandra.link > > > >> On Tue, Mar 26, 2019 at 8:01 AM Nick Hatfield <nick.hatfi...@metricly.com> >> wrote: >> How does one properly rid of sstables that have fallen victim to overlapping >> timestamps? I realized that we had TWCS set in our CF which also had a >> read_repair = 0.1 and after correcting this to 0.0 I can clearly see the >> affects over time on the new sstables. However, I still have old sstables >> that date back some time last year, and I need to remove them: >> >> Max: 09/05/2018 Min: 09/04/2018 Estimated droppable tombstones: >> 0.8832057909932046 >> 13G Mar 26 11:34 mc-254400-big-Data.db >> >> >> What is the best way to do this? This is on a production system so any help >> would be greatly appreciated. >> >> Thanks,