Check a rows TTL in cassandra?

Question

I have a table/column family which I am inserting rows that expire after a certain amount of time. Is it possible to then query the table to check which rows are going to expire soon (for diagnostic purposes, ie something like this:

select subject, ?ttl? from discussions;

https://docs.datastax.com/en/cql/3.0/cql/cql_using/use_ttl_t.html — OrangeDog, Jan 11 '16 at 16:54

score 53 · Accepted Answer · answered Sep 28 '13 at 13:05

53

You can do

select subject, TTL(subject) from discussions;

to return the remaining TTL in seconds for subject.

E.g.

> insert into discussions (uid, subject) VALUES (now(), 'hello') using ttl 100;
> select subject, TTL(subject) from discussions;

 subject | ttl(subject)
---------+--------------
   hello |           84

since I waited 16 seconds before running the select.

answered Sep 28 '13 at 13:05

Richard

11,050
2
46
33

Excellent detailed but concise answer. Thanks! – Jay Jun 02 '14 at 23:51
1

this is not working for me : somebody else had the same issue http://stackoverflow.com/questions/22201000/check-current-ttl-on-collection-columns-in-cassandra – Jean-Philippe Caruana Jul 02 '15 at 09:01
Works for me. Perhaps post a question detailing your exact scenario. – Jay Oct 17 '17 at 04:50

Check a rows TTL in cassandra?

1 Answers1