Create Cassandra table using cql3 with default TTL

cassandra cql3 ttl
Ziklag picture Ziklag · May 23, 2014 · Viewed 15.3k times · Source

Is it possible to create a table that has a default TTL for all rows that are inserted into it, or do you have to always remember to set the TTL when you do an insert/update?

Cant see anything on this in the documentation:

http://www.datastax.com/documentation/cql/3.0/cql/cql_reference/create_table_r.html

Answer

reggoodwin picture reggoodwin · May 23, 2014

Yes it is possible to set TTL for the entire column family.

CREATE TABLE test_table (
    # your table definition #
) WITH default_time_to_live = 10;

Inserted rows then disappear after 10 seconds.

I believe the work was done for it here:

https://issues.apache.org/jira/browse/CASSANDRA-3974

Here's a docs reference sent by Patrick McFadin of DataStax (@PatrickMcFadin):

http://docs.datastax.com/en/cql/3.1/cql/cql_reference/tabProp.html

Cheers,

Related questions

How to auto generate uuid in cassandra CQL 3 command line

Just learning cassandra, is there a way to insert a UUID using CQL, ie create table stuff (uid uuid primary key, name varchar); insert into stuff (name) values('my name'); // fails insert into stuff (uid, name) values(1, 'my name'); // fails …

Read More
MAX(), DISTINCT and group by in Cassandra

I am trying to remodel a SQL database Cassandra such that, I can find the Cassandra equivalent for the SQL queries. I use CQL 3 and Cassandra v1.2. I modeled the db design in cassandra so that it supports the order …

Read More
Results pagination in Cassandra (CQL)

I am wondering how can I achieve pagination using Cassandra. Let us say that I have a blog. The blog lists max 10 posts per page. To access next posts a user must click on pagination menu to access page 2 (posts 11…

Read More