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

   Email: pieter.callewaert@be-mobile.be

   Tel:  + 32 9 330 51 80

 

 

From: Sylvain Lebresne [mailto:sylvain@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.callewaert@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

   Email: pieter.callewaert@be-mobile.be

   Tel:  + 32 9 330 51 80