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:13:17 GMT
Thanks I'll have a look.
On 17 Jun 2014 17:42, "Abhishek Mukherjee" <4271693@gmail.com> wrote:

> 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