Re: Sorting by secondary index

2010-10-04 Thread Petr Odut
partly good news, thanks Petr Odut On Mon, Oct 4, 2010 at 5:40 PM, Jonathan Ellis wrote: > Yes, but probably not in 0.7.0. > > On Sun, Oct 3, 2010 at 12:08 PM, Petr Odut wrote: > > Thanks for the info. Will be ever possible to going throught a secondary > > index (since SI is sorted by default

Re: Sorting by secondary index

2010-10-04 Thread Jonathan Ellis
Yes, but probably not in 0.7.0. On Sun, Oct 3, 2010 at 12:08 PM, Petr Odut wrote: > Thanks for the info. Will be ever possible to going throught a secondary > index (since SI is sorted by default)? My use case is to display newest > comments, users, etc. SI from my point of view perfectly fits he

Re: Sorting by secondary index

2010-10-03 Thread Petr Odut
Thanks for the info. Will be ever possible to going throught a secondary index (since SI is sorted by default)? My use case is to display newest comments, users, etc. SI from my point of view perfectly fits here. Thanks :) Petr Odut. Dne 2010 10 1 18:26 "Jonathan Ellis" napsal(a): No, additional

Re: Sorting by secondary index

2010-10-01 Thread J T
Hi Jonathan, I don't suppose there's any plan to support subcolumns of supercolumns in secondary indexes in the future ? Regards Jason On Fri, Oct 1, 2010 at 4:18 PM, Jonathan Ellis wrote: > secondary index results are always sorted by indexed column value. > rows with the same index value ar

Re: Sorting by secondary index

2010-10-01 Thread Jonathan Ellis
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 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

Re: Sorting by secondary index

2010-10-01 Thread Petr Odut
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 wrote: > secondary ind

Re: Sorting by secondary index

2010-10-01 Thread Jonathan Ellis
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,

Sorting by secondary index

2010-10-01 Thread Petr Odut
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.o...@gmail.com]