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

Query sql offset keyword bug

    XMLWordPrintableJSON

Details

    • 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

          is related to

          Test - A new unit, integration or system test. KYLIN-1006 Restore ignore test cases in KylinQueryTest

          • Major - Major loss of function.
          • Closed
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. KYLIN-1064 restore disabled queries in KylinQueryTest.testVerifyQuery

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: