Re: Deleting old items during compaction (WAS: Deleting old items)

2013-02-18 Thread Alain RODRIGUEZ
:* aaron morton [mailto:aa...@thelastpickle.com] > *Sent:* Sunday, February 17, 2013 9:16 AM > *To:* user@cassandra.apache.org > *Subject:* Re: Deleting old items during compaction (WAS: Deleting old > items) > ** ** > That's what the TTL does. > ** ** > Manuall

Re: Deleting old items during compaction (WAS: Deleting old items)

2013-02-18 Thread aaron morton
3 There is no > support for time to live (TTL) on counter columns. Did I miss something? > > Thanks, > Ilya > From: aaron morton [mailto:aa...@thelastpickle.com] > Sent: Sunday, February 17, 2013 9:16 AM > To: user@cassandra.apache.org > Subject: Re: Deleting old items durin

RE: Deleting old items during compaction (WAS: Deleting old items)

2013-02-17 Thread Ilya Grebnov
Subject: Re: Deleting old items during compaction (WAS: Deleting old items) That's what the TTL does. Manually delete all the older data now, then start using TTL. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton

Re: Deleting old items

2013-02-17 Thread aaron morton
I'll email the docs people. I believe they are saying "use compaction throttling rather than this" not "this does nothing" Although I used this in the last month on a machine with very little ram to limit compaction memory use. Cheers - Aaron Morton Freelance Cassandra Develo

Re: Deleting old items during compaction (WAS: Deleting old items)

2013-02-17 Thread aaron morton
, > Ilya > From: aaron morton [mailto:aa...@thelastpickle.com] > Sent: Tuesday, February 12, 2013 9:01 AM > To: user@cassandra.apache.org > Subject: Re: Deleting old items > > So is it possible to delete all the data inserted in some CF between 2 dates > or data older than 1 mon

Re: Deleting old items

2013-02-16 Thread Alain RODRIGUEZ
"Can you point to the docs." http://www.datastax.com/docs/1.1/configuration/storage_configuration#max-compaction-threshold And thanks about the rest of your answers, once again ;-). Alain 2013/2/16 aaron morton > Is that a feature that could possibly be developed one day ? > > No. > Timesta

Re: Deleting old items

2013-02-16 Thread aaron morton
> Is that a feature that could possibly be developed one day ? No. Timestamps are essentially internal implementation used to resolve different values for the same column. > With "min_compaction_level_threshold" did you mean "min_compaction_threshold" > ? If so, why should I do that, what ar

Deleting old items during compaction (WAS: Deleting old items)

2013-02-13 Thread Ilya Grebnov
From: aaron morton [mailto:aa...@thelastpickle.com] Sent: Tuesday, February 12, 2013 9:01 AM To: user@cassandra.apache.org Subject: Re: Deleting old items So is it possible to delete all the data inserted in some CF between 2 dates or data older than 1 month ? No. You need to issue row

Re: Deleting old items

2013-02-13 Thread Alain RODRIGUEZ
Hi Aaron, once again thanks for this answer. "So is it possible to delete all the data inserted in some CF between 2 dates or data older than 1 month ?" "No. " Why is there no way of deleting or getting data using the internal timestamp stored alongside of any inserted column (as described here:

Re: Deleting old items

2013-02-12 Thread aaron morton
> So is it possible to delete all the data inserted in some CF between 2 dates > or data older than 1 month ? No. You need to issue row level deletes. If you don't know the row key you'll need to do range scans to locate them. If you are deleting parts of wide rows consider reducing the min_