That’s right Jeff. That’s why I am thinking why not compaction gets rid of old exited sstables?
Regards, Nitan Cell: 510 449 9629 > On Feb 11, 2019, at 3:53 PM, Jeff Jirsa <jji...@gmail.com> wrote: > > It's probably not safe. You shouldn't touch the underlying sstables unless > you're very sure you know what you're doing. > > >> On Mon, Feb 11, 2019 at 1:05 PM Akash Gangil <akashg1...@gmail.com> wrote: >> I have in the past tried to delete SSTables manually, but have noticed bits >> and pieces of that data still remain, even though the sstables of that >> window is deleted. So always wondered if playing directly with the >> underlying filesystem is a safe bet? >> >> >>> On Mon, Feb 11, 2019 at 1:01 PM Jonathan Haddad <j...@jonhaddad.com> wrote: >>> Deleting SSTables manually can be useful if you don't know your TTL up >>> front. For example, you have an ETL process that moves your raw Cassandra >>> data into S3 as parquet files, and you want to be sure that process is >>> completed before you delete the data. You could also start out without >>> setting a TTL and later realize you need one. This is a remarkably common >>> problem. >>> >>>> On Mon, Feb 11, 2019 at 12:51 PM Nitan Kainth <nitankai...@gmail.com> >>>> wrote: >>>> Jeff, >>>> >>>> It means we have to delete sstables manually? >>>> >>>> >>>> Regards, >>>> Nitan >>>> Cell: 510 449 9629 >>>> >>>>> On Feb 11, 2019, at 2:40 PM, Jeff Jirsa <jji...@gmail.com> wrote: >>>>> >>>>> There's a bit of headache around overlapping sstables being strictly safe >>>>> to delete. https://issues.apache.org/jira/browse/CASSANDRA-13418 was >>>>> added to allow the "I know it's not technically safe, but just delete it >>>>> anyway" use case. For a lot of people who started using TWCS before >>>>> 13418, "stop cassandra, remove stuff we know is expired, start cassandra" >>>>> is a not-uncommon pattern in very high-write, high-disk-space use cases. >>>>> >>>>> >>>>> >>>>>> On Mon, Feb 11, 2019 at 12:34 PM Nitan Kainth <nitankai...@gmail.com> >>>>>> wrote: >>>>>> Hi, >>>>>> In regards to comment “Purging data is also straightforward, just >>>>>> dropping SSTables (by a script) where create date is older than a >>>>>> threshold, we don't even need to rely on TTL” >>>>>> >>>>>> Doesn’t the old sstables drop by itself? One ttl and gc grace seconds >>>>>> past whole sstable will have only tombstones. >>>>>> >>>>>> >>>>>> Regards, >>>>>> Nitan >>>>>> Cell: 510 449 9629 >>>>>> >>>>>>> On Feb 11, 2019, at 2:23 PM, DuyHai Doan <doanduy...@gmail.com> wrote: >>>>>>> >>>>>>> Purging data is also straightforward, just dropping SSTables (by a >>>>>>> script) where create date is older than a threshold, we don't even need >>>>>>> to rely on TTL >>> >>> >>> -- >>> Jon Haddad >>> http://www.rustyrazorblade.com >>> twitter: rustyrazorblade >> >> >> -- >> Akash