Re: LCS not removing rows with all TTL expired columns

2013-01-22 Thread Bryan Talbot
and irrevocably delete this message and any copies. *From:* aaron morton [mailto:aa...@thelastpickle.com] *Sent:* Thursday, January 17, 2013 06:24 *To:* user@cassandra.apache.org *Subject:* Re: LCS not removing rows with all TTL expired columns ** ** Minor compaction (with Size Tiered

Re: LCS not removing rows with all TTL expired columns

2013-01-22 Thread Derek Williams
and any copies. *From:* aaron morton [mailto:aa...@thelastpickle.com] *Sent:* Thursday, January 17, 2013 06:24 *To:* user@cassandra.apache.org *Subject:* Re: LCS not removing rows with all TTL expired columns ** ** Minor compaction (with Size Tiered) will only purge tombstones if all

RE: LCS not removing rows with all TTL expired columns

2013-01-17 Thread Viktor Jevdokimov
@cassandra.apache.org Subject: Re: LCS not removing rows with all TTL expired columns Minor compaction (with Size Tiered) will only purge tombstones if all fragments of a row are contained in the SSTables being compacted. So if you have a long lived row, that is present in many size tiers, the columns

Re: LCS not removing rows with all TTL expired columns

2013-01-17 Thread Bryan Talbot
:* aaron morton [mailto:aa...@thelastpickle.com] *Sent:* Thursday, January 17, 2013 06:24 *To:* user@cassandra.apache.org *Subject:* Re: LCS not removing rows with all TTL expired columns ** ** Minor compaction (with Size Tiered) will only purge tombstones if all fragments of a row

Re: LCS not removing rows with all TTL expired columns

2013-01-17 Thread Bryan Talbot
[mailto:aa...@thelastpickle.com] *Sent:* Thursday, January 17, 2013 06:24 *To:* user@cassandra.apache.org *Subject:* Re: LCS not removing rows with all TTL expired columns ** ** Minor compaction (with Size Tiered) will only purge tombstones if all fragments of a row are contained

Re: LCS not removing rows with all TTL expired columns

2013-01-17 Thread Derek Williams
...@thelastpickle.com] *Sent:* Thursday, January 17, 2013 06:24 *To:* user@cassandra.apache.org *Subject:* Re: LCS not removing rows with all TTL expired columns ** ** Minor compaction (with Size Tiered) will only purge tombstones if all fragments of a row are contained in the SSTables

Re: LCS not removing rows with all TTL expired columns

2013-01-17 Thread Bryan Talbot
@cassandra.apache.org *Subject:* Re: LCS not removing rows with all TTL expired columns ** ** Minor compaction (with Size Tiered) will only purge tombstones if all fragments of a row are contained in the SSTables being compacted. So if you have a long lived row, that is present in many

Re: LCS not removing rows with all TTL expired columns

2013-01-16 Thread Andrey Ilinykh
To get column removed you have to meet two requirements 1. column should be expired 2. after that CF gets compacted I guess your expired columns are propagated to high tier CF, which gets compacted rarely. So, you have to wait when high tier CF gets compacted. Andrey On Wed, Jan 16, 2013 at

Re: LCS not removing rows with all TTL expired columns

2013-01-16 Thread Bryan Talbot
According to the timestamps (see original post) the SSTable was written (thus compacted compacted) 3 days after all columns for that row had expired and 6 days after the row was created; yet all columns are still showing up in the SSTable. Note that the column shows now rows when a get for that

Re: LCS not removing rows with all TTL expired columns

2013-01-16 Thread aaron morton
Minor compaction (with Size Tiered) will only purge tombstones if all fragments of a row are contained in the SSTables being compacted. So if you have a long lived row, that is present in many size tiers, the columns will not be purged. (thus compacted compacted) 3 days after all columns for