Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-983

Query sql offset keyword bug

    XMLWordPrintableJSON

    Details

    • Flags:
      Patch

      Description

      SQL is:

      select type,count(*) from test group by type limit 1 offset 10
      

      the resultset size is 0.
      I see the hbase scanner only judge the limit size,not found the offset size.
      The most queries offset is calcite service when the scan count bigger than limit+offset.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mahongbin Hongbin Ma
                Reporter:
                wangxiaoyu Xiaoyu Wang
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: