Re: Read data from Cassandra ordered by writetime using cql.

2014-06-17 Thread Abhishek Mukherjee
Thanks I'll have a look. On 17 Jun 2014 17:42, "Abhishek Mukherjee" <4271...@gmail.com> wrote: > Thanks Jen. I'll r > On 17 Jun 2014 17:37, "Jens Rantil" wrote: > >> Hi Abhishek, >> >> You can't. You need to use a clustering key to keep track of your >> ordering. See >> http://www.datastax.com/do

Re: Read data from Cassandra ordered by writetime using cql.

2014-06-17 Thread Abhishek Mukherjee
Thanks Jen. I'll r On 17 Jun 2014 17:37, "Jens Rantil" wrote: > Hi Abhishek, > > You can't. You need to use a clustering key to keep track of your > ordering. See > http://www.datastax.com/documentation/cql/3.0/cql/cql_reference/select_r.html?scroll=reference_ds_d35_v2q_xj__querying-compound-prim

Re: Read data from Cassandra ordered by writetime using cql.

2014-06-17 Thread Jens Rantil
Hi Abhishek, You can't. You need to use a clustering key to keep track of your ordering. See http://www.datastax.com/documentation/cql/3.0/cql/cql_reference/select_r.html?scroll=reference_ds_d35_v2q_xj__querying-compound-primary-keys-and-sorting-results Cheers, Jens On Tue, Jun 17, 2014 at 1:48

Re: Read data from Cassandra ordered by writetime using cql.

2014-06-17 Thread subhankar biswas
this question has been raised several times. But only one answer u can/should not. On 17-Jun-2014, at 5:18 pm, Abhishek Mukherjee <4271...@gmail.com> wrote: > Hi Everyone, > > I am trying to read data from my Cassandra database in the order in which it > got written into the DB. There is a WRIT

Read data from Cassandra ordered by writetime using cql.

2014-06-17 Thread Abhishek Mukherjee
Hi Everyone, I am trying to read data from my Cassandra database in the order in which it got written into the DB. There is a WRITETIME function which gives me the write time for a column. How can I use this so that the data when I do a returned from my query gets ordered by write time. I am tryi