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

extend LIMIT to define offset, row_count

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Normal
    • Resolution: Won't Fix
    • None
    • None

    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

              Unassigned Unassigned
              ps0296 Pardeep Singh
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: