incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek Mukherjee <4271...@gmail.com>
Subject Re: Read data from Cassandra ordered by writetime using cql.
Date Tue, 17 Jun 2014 12:12:15 GMT
Thanks Jen. I'll r
On 17 Jun 2014 17:37, "Jens Rantil" <jens.rantil@tink.se> 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-primary-keys-and-sorting-results
>
> Cheers,
> Jens
>
>
> On Tue, Jun 17, 2014 at 1:48 PM, Abhishek Mukherjee <4271693@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 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 trying to achieve something like this:
>>
>> select column1, column2, column3 from table order by writetime (column4);
>>
>>
>> Thanks in advance,
>> Abhishek
>>
>
>

Mime
View raw message