[jira] Issue Comment Edited: (CASSANDRA-1599) Add sort/order support for secondary indexing

["LiuJingSi (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-1599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12964761#action_12964761 ] 

LiuJingSi edited comment on CASSANDRA-1599 at 11/29/10 9:17 AM:
----------------------------------------------------------------

Hi,all

>Expose 0.8.0 distributed indexes as readonly column families which are sorted by the index value, and which are queried using get_range_slices
i am wondering how to solve this query with the readonly index:
 email == 'bob@gmail.com' && (lastlogindate > today - 5 days || newmessagedate > today -1 day).

since i met the similar problem: in SQL expression,it is like:
select * from sometable where author='somebody' order by last_reply_time desc.

or do i make some misunderstanding?

thank very much.

      was (Author: lookis):
    Hi,all

>Expose 0.8.0 distributed indexes as readonly column families which are sorted by the index value, and which are queried using get_range_slices
i am wondering how to solve this query with the readonly index:
 email == 'bob@gmail.com' && (lastlogindate > today - 5 days || newmessagedate > today -1 day).

since i met the similar problem: in SQL expression,it is like:
select * from sometable where author='somebody' order by last_reply_time desc.

thank very much.
  
> Add sort/order support for secondary indexing
> ---------------------------------------------
>
>                 Key: CASSANDRA-1599
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-1599
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: API
>            Reporter: Todd Nine
>             Fix For: 0.8
>
>
> For a lot of users paging is a standard use case on many web applications.  It would be nice to allow paging as part of a Boolean Expression.
> Page -> start index
>            -> end index
>            -> page timestamp 
>            -> Sort Order
> When sorting, is it possible to sort both ASC and DESC? 
>             

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.