Thanks, gc_grace works in the CLI. However, I'm not observing the desired effect. I am setting TTL on a single column in my column family, and I see the columns disappear when using 'list Session' (my columnfamily) in the CLI. I created the column family with gc_grace = 60, and after observing for a few minutes I am still seeing all the rows come back, none of them with columns. I was hoping the GC would delete the empty rows.
-Kal On Tue, Feb 8, 2011 at 11:39 AM, Sylvain Lebresne <sylv...@datastax.com> wrote: > Not very logically, It's actually gc_grace, not gc_grace_seconds in the CLI. > > On Tue, Feb 8, 2011 at 5:34 PM, Kallin Nagelberg > <kallin.nagelb...@gmail.com> wrote: >> >> I'm trying to set the gc_grace_seconds column family parameter but no >> luck.. I got the name of it from the comment in cassandra.yaml: >> >> # - gc_grace_seconds: specifies the time to wait before garbage >> # collecting tombstones (deletion markers). defaults to 864000 (10 >> # days). See http://wiki.apache.org/cassandra/DistributedDeletes >> >> create column family Session >> with comparator = UTF8Type >> and keys_cached = 10000 >> and memtable_flush_after = 1440 >> and memtable_throughput = 32 >> and gc_grace_seconds = 60; >> >> error is 'No enum const class >> >> org.apache.cassandra.cli.CliUserHelp$ColumnFamilyArgument.GC_GRACE_SECONDS'. >> >> Thanks, >> -Kal >> >> On Tue, Feb 8, 2011 at 11:02 AM, Sylvain Lebresne <sylv...@datastax.com> >> wrote: >> >> I hope you don't consider this a hijack of the thread... >> >> >> >> What I'd like to know is the following: >> >> >> >> The GC removes TTL rows some time after they expire, at its >> >> convenience. >> >> But will they stop being returned as soon as they expire? (This is the >> >> expected behavior...) >> > >> > It is the individual column that have TTL. When a column expires, it >> > becomes >> > a delete tombstone. Now, a row with tombstones (even only them) will >> > show >> > during range request. But the explanation is >> > here: http://wiki.apache.org/cassandra/FAQ#range_ghosts >> > >> >> >> >> On Tue, Feb 8, 2011 at 5:11 PM, Kallin Nagelberg >> >> <kallin.nagelb...@gmail.com> wrote: >> >>> >> >>> So the empty row will be ultimately removed then? Is there a way to >> >>> for the GC to verify this? >> >>> >> >>> Thanks, >> >>> -Kal >> >>> >> >>> On Tue, Feb 8, 2011 at 2:21 AM, Stu Hood <stuh...@gmail.com> wrote: >> >>> > The expired columns were converted into tombstones, which will live >> >>> > for >> >>> > the >> >>> > GC timeout. The "empty" row will be cleaned up when those tombstones >> >>> > are >> >>> > removed. >> >>> > Returning the empty row is unfortunate... we'd love to find a more >> >>> > appropriate solution that might not involve endless scanning. >> >>> > See >> >>> > http://wiki.apache.org/cassandra/FAQ#i_deleted_what_gives >> >>> > http://wiki.apache.org/cassandra/FAQ#range_ghosts >> >>> > >> >>> > On Mon, Feb 7, 2011 at 1:49 PM, Kallin Nagelberg >> >>> > <kallin.nagelb...@gmail.com> wrote: >> >>> >> >> >>> >> I also tried forcing a major compaction on the column family using >> >>> >> JMX >> >>> >> but the row remains. >> >>> >> >> >>> >> On Mon, Feb 7, 2011 at 4:43 PM, Kallin Nagelberg >> >>> >> <kallin.nagelb...@gmail.com> wrote: >> >>> >> > I tried that but I still see the row coming back on a list >> >>> >> > <columnfamily> in the CLI. My concern is that there will be a >> >>> >> > pointer >> >>> >> > to an empty row for all eternity. >> >>> >> > >> >>> >> > -Kal >> >>> >> > >> >>> >> > On Mon, Feb 7, 2011 at 4:38 PM, Aaron Morton >> >>> >> > <aa...@thelastpickle.com> >> >>> >> > wrote: >> >>> >> >> Deleting all the columns in a row via TTL has the same affect as >> >>> >> >> deleting th >> >>> >> >> row, the data will physically by removed during compaction. >> >>> >> >> >> >>> >> >> Aaron >> >>> >> >> >> >>> >> >> >> >>> >> >> On 08 Feb, 2011,at 10:24 AM, Bill Speirs <bill.spe...@gmail.com> >> >>> >> >> wrote: >> >>> >> >> >> >>> >> >> I don't think this is supported (but I could be completely >> >>> >> >> wrong). >> >>> >> >> However, I'd love to see this functionality as well. >> >>> >> >> >> >>> >> >> How would one go about requesting such a feature? >> >>> >> >> >> >>> >> >> Bill- >> >>> >> >> >> >>> >> >> On Mon, Feb 7, 2011 at 4:15 PM, Kallin Nagelberg >> >>> >> >> <kallin.nagelb...@gmail.com> wrote: >> >>> >> >>> Hey, >> >>> >> >>> >> >>> >> >>> I have read about the new TTL columns in Cassandra 0.7. In my >> >>> >> >>> case >> >>> >> >>> I'd >> >>> >> >>> like to expire an entire row automatically after a certain >> >>> >> >>> amount >> >>> >> >>> of >> >>> >> >>> time. Is this possible as well? >> >>> >> >>> >> >>> >> >>> Thanks, >> >>> >> >>> -Kal >> >>> >> >>> >> >>> >> >> >> >>> >> > >> >>> > >> >>> > >> >> >> > >> > > >
