How to select timestamp with CQL

2013-10-23 Thread Alex N
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

Re: How to select timestamp with CQL

2013-10-23 Thread Cyril Scetbon
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

Re: How to select timestamp with CQL

2013-10-23 Thread Alex N
Thanks! I can't find it in the documentation... 2013/10/23 Cyril Scetbon cyril.scet...@free.fr 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* |

Re: How to select timestamp with CQL

2013-10-23 Thread Laing, Michael
http://www.datastax.com/documentation/cql/3.1/webhelp/index.html#cql/cql_reference/select_r.html On Wed, Oct 23, 2013 at 6:50 AM, Alex N lot...@gmail.com wrote: Thanks! I can't find it in the documentation... 2013/10/23 Cyril Scetbon cyril.scet...@free.fr Hi, Now you can ask for the