[ https://issues.apache.org/jira/browse/PHOENIX-2722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15173379#comment-15173379 ]
James Taylor commented on PHOENIX-2722: --------------------------------------- You could force a query with an offset to run serially and at a minimum push the offset to the server so that the coprocessor can do the next() rather than return all the data back to the client (at least for the non order by case). > support mysql "limit,offset" clauses > ------------------------------------- > > Key: PHOENIX-2722 > URL: https://issues.apache.org/jira/browse/PHOENIX-2722 > Project: Phoenix > Issue Type: New Feature > Reporter: Ankit Singhal > Assignee: Ankit Singhal > Priority: Minor > > For serial query(query with “serial" hint or “limit" without "order by”), we > can limit each scan(using page filter) to “limit+offset” instead of limit > earlier. > And then, for all queries, we can forward the relevant client iterators to > the offset provided and then return the result. > WDYT, [~jamestaylor] -- This message was sent by Atlassian JIRA (v6.3.4#6332)