[PHOENIX-172] Support the ability for a client to do query more

• Type: Task
• Status: Resolved
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Labels: enhancement
• old issue number: 41
• Assignee: Samarth Jain
• Reporter: James R. Taylor
• Created: 10/Mar/14 23:46
• Updated: 16/Oct/18 00:13
• Resolved: 16/Mar/14 07:18

Description

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) .