[jira] [Created] (CASSANDRA-6511) extend LIMIT to define offset, row_count

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

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)