Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.1.0
    • 3.4.0
    • SQL
    • None

    Description

      LIMIT and OFFSET

      LIMIT and OFFSET allow you to retrieve just a portion of the rows that are generated by the rest of the query:

      SELECT select_list
          FROM table_expression
          [ ORDER BY ... ]
          [ LIMIT { number | ALL } ] [ OFFSET number ]
      

      If a limit count is given, no more than that many rows will be returned (but possibly fewer, if the query itself yields fewer rows). LIMIT ALL is the same as omitting the LIMIT clause, as is LIMIT with a NULL argument.

      OFFSET says to skip that many rows before beginning to return rows. OFFSET 0 is the same as omitting the OFFSET clause, as is OFFSET with a NULL argument.

      If both OFFSET and LIMIT appear, then OFFSET rows are skipped before starting to count the LIMIT rows that are returned.

      https://www.postgresql.org/docs/11/queries-limit.html

      Feature ID: F861

      Attachments

        Issue Links

          Activity

            beliefer Jiaan Geng added a comment -

            I'm working.

            beliefer Jiaan Geng added a comment - I'm working.
            zhengshengjun Shengjun Zheng added a comment -

            any progress ?

            zhengshengjun Shengjun Zheng added a comment - any progress ?
            abij Alexander Bij added a comment -

            I'm looking forward to this feature!

             

            I noticed it is absends when using DBeaver sql-client (simba-spark driver) to look at Table data. It's downloading full datasets when viewing tables.

            Comparing it to Hive SQL offset is implemented and working in DBeaver, scrolling pages when looking at tables.

             

            All the PR's are closed (not merged) and mentioned the work is suspended (at 27-april-2021)

             

            At lease you can upvote the feature to raise importance

            abij Alexander Bij added a comment - I'm looking forward to this feature!   I noticed it is absends when using DBeaver sql-client (simba-spark driver) to look at Table data. It's downloading full datasets when viewing tables. Comparing it to Hive SQL offset is implemented and working in DBeaver, scrolling pages when looking at tables.   All the PR's are closed (not merged) and mentioned the work is suspended (at 27-april-2021)   At lease you can upvote the feature to raise importance
            apachespark Apache Spark added a comment -

            User 'beliefer' has created a pull request for this issue:
            https://github.com/apache/spark/pull/35975

            apachespark Apache Spark added a comment - User 'beliefer' has created a pull request for this issue: https://github.com/apache/spark/pull/35975
            cloud_fan Wenchen Fan added a comment -

            Issue resolved by pull request 35975
            https://github.com/apache/spark/pull/35975

            cloud_fan Wenchen Fan added a comment - Issue resolved by pull request 35975 https://github.com/apache/spark/pull/35975
            apachespark Apache Spark added a comment -

            User 'beliefer' has created a pull request for this issue:
            https://github.com/apache/spark/pull/36319

            apachespark Apache Spark added a comment - User 'beliefer' has created a pull request for this issue: https://github.com/apache/spark/pull/36319
            apachespark Apache Spark added a comment -

            User 'beliefer' has created a pull request for this issue:
            https://github.com/apache/spark/pull/36417

            apachespark Apache Spark added a comment - User 'beliefer' has created a pull request for this issue: https://github.com/apache/spark/pull/36417
            apachespark Apache Spark added a comment -

            User 'beliefer' has created a pull request for this issue:
            https://github.com/apache/spark/pull/36417

            apachespark Apache Spark added a comment - User 'beliefer' has created a pull request for this issue: https://github.com/apache/spark/pull/36417

            People

              beliefer Jiaan Geng
              yumwang Yuming Wang
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: