Thanks, it works perfectly with ALTER TABLE. Stupid I didn't thought of this. Maybe I overlooked, but maybe this should be added in the docs. Really a great feature!
Kind regards, [Description: cid:image003.png@01CD9CE5.CE5A2330] Pieter Callewaert Web & IT engineer Web: www.be-mobile.be<http://www.be-mobile.be/> Email: pieter.callewa...@be-mobile.be<mailto:pieter.callewa...@be-mobile.be> Tel: + 32 9 330 51 80 From: Sylvain Lebresne [mailto:sylv...@datastax.com] Sent: dinsdag 1 oktober 2013 19:10 To: user@cassandra.apache.org Subject: Re: default_time_to_live You're not supposed to change the table settings by modifying system.schema_columnfamilies as this will skip proper propagation of the change. Instead, you're supposed to do an ALTER TABLE, so something like: ALTER TABLE hol WITH default_time_to_live=10; That being said, if you restart the node on which you've made the update, the change "should" be picked up and propagated to all nodes. Still not a bad idea to do the ALTER TABLE to make sure everything is set right. -- Sylvain On Tue, Oct 1, 2013 at 10:50 AM, Pieter Callewaert <pieter.callewa...@be-mobile.be<mailto:pieter.callewa...@be-mobile.be>> wrote: Hi, We are starting up a new cluster with Cassandra 2.0.0 and one of the features we were interested in was Per-CF TTL (https://issues.apache.org/jira/browse/CASSANDRA-3974) I didn't find any commands in CQL to set this value, so I've used the following: UPDATE system.schema_columnfamilies SET default_time_to_live = 10 WHERE keyspace_name = 'testschema' AND columnfamily_name = 'hol'; Confirming it is set: cqlsh:testschema> select default_time_to_live from system.schema_columnfamilies where keyspace_name = 'testschema' and columnfamily_name = 'hol'; default_time_to_live ---------------------- 10 Then I Insert some dummy data, but it never expires... Using the ttl command I get this: cqlsh:testschema> select ttl(coverage) from hol; ttl(coverage) --------------- Null Am I doing something wrong? Or is this a bug? Kind regards, [Description: cid:image003.png@01CD9CE5.CE5A2330] Pieter Callewaert Web & IT engineer Web: www.be-mobile.be<http://www.be-mobile.be/> Email: pieter.callewa...@be-mobile.be<mailto:pieter.callewa...@be-mobile.be> Tel: + 32 9 330 51 80
<<inline: image001.png>>