Re: will compaction delete empty rows after all columns expired?

2012-05-31 Thread aaron morton
You can set the gc_grace_secs as a little value and force major compaction after the row is expired. After then please check whether the row still exists. There are some downsides to major compactions. (There have been some recent discussions). You can provoke (some) minor compactions by:

Re: will compaction delete empty rows after all columns expired?

2012-05-30 Thread aaron morton
Minor compaction will remove the tombstones if the row only exists in the sstable being compaction. Are these very wide rows that are constantly written to ? Cheers p.s. cassandra 1.0 really does rock. - Aaron Morton Freelance Developer @aaronmorton

RE: will compaction delete empty rows after all columns expired?

2012-05-30 Thread Curt Allred
No, these were not wide rows. They are rows that formerly had one or 2 columns. The columns are deleted but the empty rows dont go away, even after gc_grace_secs. So if I understand... the empty row will only be removed after gc_grace if enough compactions have occurred so that all the column

Re: will compaction delete empty rows after all columns expired?

2012-05-30 Thread Zhu Han
On Thu, May 31, 2012 at 9:31 AM, Curt Allred c...@mediosystems.com wrote: No, these were not wide rows. They are rows that formerly had one or 2 columns. The columns are deleted but the empty rows dont go away, even after gc_grace_secs. The empty row goes away only during a compaction after

RE: will compaction delete empty rows after all columns expired?

2012-05-25 Thread Curt Allred
This is an old thread from December 27, 2011. I interpret the yes answer to mean you do not have to explicitly delete an empty row after all of its columns have been deleted, the empty row (i.e. row key) will automatically be deleted eventually (after gc_grace). Is that true? I am not

Re: will compaction delete empty rows after all columns expired?

2012-05-25 Thread Radim Kolar
do not delete empty rows. It refreshes tombstone and they will never expire.

Re: will compaction delete empty rows after all columns expired?

2011-12-27 Thread Peter Schuller
Compaction should delete empty rows once gc_grace_seconds is passed, right? Yes. -- / Peter Schuller (@scode, http://worldmodscode.wordpress.com)

Re: will compaction delete empty rows after all columns expired?

2011-12-27 Thread Peter Schuller
Compaction should delete empty rows once gc_grace_seconds is passed, right? Yes. But just to be extra clear: Data will not actually be removed once the row in question participates in compaction. Compactions will not be actively triggered by Cassandra for tombstone processing reasons. -- /

Re: will compaction delete empty rows after all columns expired?

2011-12-27 Thread Radim Kolar
But just to be extra clear: Data will not actually be removed once the row in question participates in compaction. Compactions will not be actively triggered by Cassandra for tombstone processing reasons. leveled compaction is really good for this because it compacts often