cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Ellis <jbel...@gmail.com>
Subject Re: Sorting by secondary index
Date Fri, 01 Oct 2010 16:25:32 GMT
No, additional expressions (the GTE here) only affect what rows come
back and do not affect sort order.

On Fri, Oct 1, 2010 at 10:55 AM, Petr Odut <petr.odut@gmail.com> wrote:
> OK,
> I have a query with 2 expressions:
> 1st: with GTE operator
> 2nd: with EQ operator
> both columns are indexed, but results are sorted in token order (I should
> expect to be sorted by 1st expression column values).
> Am I correct?
> On Fri, Oct 1, 2010 at 5:18 PM, Jonathan Ellis <jbellis@gmail.com> wrote:
>>
>> secondary index results are always sorted by indexed column value.
>> rows with the same index value are sorted in token order (although
>> support for comparator order is planned).
>>
>> sorting by a different column is not possible to do efficiently
>> server-side and therefore is left to the client.
>>
>> On Fri, Oct 1, 2010 at 10:13 AM, Petr Odut <petr.odut@gmail.com> wrote:
>> > Hi,
>> > is it possible to sort results based on secondary index search?
>> > Typical use case is to get most recent comments from specified group
>> > CF: comments
>> >  * SI: group
>> >  * SI: timestamp
>> > I've asked before, but I can't still found any information.
>> > Thanks
>> > --
>> > Petr Odut [petr.odut@gmail.com]
>> >
>>
>>
>>
>> --
>> Jonathan Ellis
>> Project Chair, Apache Cassandra
>> co-founder of Riptano, the source for professional Cassandra support
>> http://riptano.com
>
>
>
> --
> Petr Odut [petr.odut@gmail.com]
>



-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support
http://riptano.com

Mime
View raw message