[
https://issues.apache.org/jira/browse/PHOENIX-172?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16650988#comment-16650988
]
Thomas D'Silva commented on PHOENIX-172:
----------------------------------------
" It’s important to note that row value constructors don’t address a couple of
needs related to this paging idea. First, the ordering direction of all
elements is the same (ascending when using > and descending when using <). "
If A is sorted desc and B
{{WHERE (A, B) < ('b',2)}} translates to {{WHERE (A < 'b' OR (A='b' AND B<2)}}
but I think we really need {{WHERE (A < 'b' OR (A='b' AND B>2)}} which can't be
represented using a RVC
> Support the ability for a client to do query more
> -------------------------------------------------
>
> Key: PHOENIX-172
> URL: https://issues.apache.org/jira/browse/PHOENIX-172
> Project: Phoenix
> Issue Type: Task
> Affects Versions: 2.1.0
> Reporter: James Taylor
> Assignee: Samarth Jain
> Labels: enhancement
>
> Clients often need the ability to "page" through query results that have more
> row results than are displayable on a single screen. SQL provides LIMIT and
> OFFSET which is often used for this purpose, however supporting OFFSET in a
> performant manner is not possible with HBase. Instead, an alternate way of
> supporting query-more functionality (suggested by @larsh) is through [row
> values
> constructors](http://publib.boulder.ibm.com/infocenter/soliddb/v6r3/index.jsp?topic=/com.ibm.swg.im.soliddb.sql.doc/doc/row.value.constructors.html)
> which has been in the SQL spec since SQL-92. It has PostGres support as
> well with the benefits explained well
> [here](https://wiki.postgresql.org/images/3/35/Pagination_Done_the_PostgreSQL_Way.pdf)
> .
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
