[CASSANDRA-6511] extend LIMIT to define offset, row_count

• Type: New Feature
• Status: Resolved
• Priority: Normal
• Resolution: Won't Fix
• Labels: cql3 query
• Assignee: Unassigned
• Reporter: Pardeep Singh
• Created: 19/Dec/13 16:31
• Updated: 16/Apr/19 09:31
• Resolved: 19/Dec/13 17:00

Description

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.

Issue Links

• is duplicated by: CASSANDRA-8799 Pagination support in CQL and henceforth in the drivers