Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-6511

extend LIMIT to define offset, row_count

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Won't Fix
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                ps0296 Pardeep Singh
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: