Pardeep Singh created CASSANDRA-6511:
----------------------------------------
Summary: extend LIMIT to define offset, row_count
Key: CASSANDRA-6511
URL: https://issues.apache.org/jira/browse/CASSANDRA-6511
Project: Cassandra
Issue Type: New Feature
Reporter: Pardeep Singh
Currently I can to do:
SELECT * FROM top_posts WHERE id="music" LIMIT 10;
If it was possible to extend the LIMIT clause to:
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
SELECT * FROM top_posts WHERE id="music" LIMIT 10, 10;
Pagination will be possible without using clustering key with less than or
greater than.
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)
