Re: TWCS on Non TTL Data

2021-09-20 Thread Bowen Song
:* Re: TWCS on Non TTL Data If you use TWCS with TTL, the old SSTables won't be compacted, the entire SSTable file will get dropped after it expires. I don't think you will need to manage the compaction or cleanup at all, as they are automatic. There's no space limit on the table holding the near

RE: TWCS on Non TTL Data

2021-09-19 Thread Isaeed Mohanna
Subject: Re: TWCS on Non TTL Data If you use TWCS with TTL, the old SSTables won't be compacted, the entire SSTable file will get dropped after it expires. I don't think you will need to manage the compaction or cleanup at all, as they are automatic. There's no space limit on the table holding

Re: TWCS on Non TTL Data

2021-09-17 Thread Bowen Song
? *From:* Jim Shaw *Sent:* Wednesday, September 15, 2021 3:49 PM *To:* user@cassandra.apache.org *Subject:* Re: TWCS on Non TTL Data You may try roll up the data, i.e.  a table only 1 month data, old data roll up to a table keep a year data. Thanks, Jim On Wed, Sep 15, 2021 at 1:26 AM

RE: TWCS on Non TTL Data

2021-09-17 Thread Isaeed Mohanna
Jirsa mailto:jji...@gmail.com>> Sent: Tuesday, September 14, 2021 10:35 PM To: cassandra mailto:user@cassandra.apache.org>> Subject: Re: TWCS on Non TTL Data Inline On Tue, Sep 14, 2021 at 11:47 AM Isaeed Mohanna mailto:isa...@xsense.co>> wrote: Hi Jeff My data is partitioned

Re: TWCS on Non TTL Data

2021-09-15 Thread Jim Shaw
hange the time > window right? > > > > Thanks > > > > > > *From:* Jeff Jirsa > *Sent:* Tuesday, September 14, 2021 10:35 PM > *To:* cassandra > *Subject:* Re: TWCS on Non TTL Data > > > > Inline > > > > On Tue, Sep 14, 2021 at

RE: TWCS on Non TTL Data

2021-09-14 Thread Isaeed Mohanna
week bucket, I could later change the time window right? Thanks From: Jeff Jirsa Sent: Tuesday, September 14, 2021 10:35 PM To: cassandra Subject: Re: TWCS on Non TTL Data Inline On Tue, Sep 14, 2021 at 11:47 AM Isaeed Mohanna mailto:isa...@xsense.co>> wrote: Hi Jeff My data is parti

Re: TWCS on Non TTL Data

2021-09-14 Thread Jeff Jirsa
help. > > > > > > > > > > > > > > > > > > *From:* Jeff Jirsa > *Sent:* Tuesday, September 14, 2021 4:51 PM > *To:* cassandra > *Subject:* Re: TWCS on Non TTL Data > > > > > > > > On Tue, Sep 14, 2021 at 5:42 AM

RE: TWCS on Non TTL Data

2021-09-14 Thread Isaeed Mohanna
Subject: Re: TWCS on Non TTL Data On Tue, Sep 14, 2021 at 5:42 AM Isaeed Mohanna mailto:isa...@xsense.co>> wrote: Hi I have a table that stores time series data, the data is not TTLed since we want to retain the data for the foreseeable future, and there are no updates or deletes. (deletes

Re: TWCS on Non TTL Data

2021-09-14 Thread Jeff Jirsa
On Tue, Sep 14, 2021 at 5:42 AM Isaeed Mohanna wrote: > Hi > > I have a table that stores time series data, the data is not TTLed since > we want to retain the data for the foreseeable future, and there are no > updates or deletes. (deletes could happens rarely in case some scrambled > data