Hi, Now you can ask for the TTL and the TIMESTAMP as shown in the following example :
cqlsh:k1> select * FROM t1 ; ise | filtre | value_1 --------+--------+--------- cyril1 | 2 | 49926 cyril2 | 1 | 18584 cyril3 | 2 | 31415 cqlsh:k1> select filtre,writetime(filtre),ttl(filtre) FROM t1 ; filtre | writetime(filtre) | ttl(filtre) --------+-------------------+------------- 2 | 1380088288623000 | null 1 | 1380088288636000 | null 2 | 1380088289309000 | null Regards -- Cyril SCETBON On 23 Oct 2013, at 12:00, Alex N <lot...@gmail.com> wrote: > Hi, > I was wondering how could I select column timestamp with CQL. I've been using > Hector so far, and it gives me this option. But I want to use datastax CQL > driver now. > I don't want to mess with this value! just read it. I know I should probably > have separate column with timestamp value created by my own, but I don't want > to change the schema and update milions of rows know. > I found this ticket https://issues.apache.org/jira/browse/CASSANDRA-4217 and > it's fixed but I don't know how to use it - > SELECT key, value, timestamp(value) FROM foo; - this doesn't work. > Regards, > Alex > >