You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@kylin.apache.org by "Xiaoyu Wang (JIRA)" <ji...@apache.org> on 2015/08/31 11:14:45 UTC

[jira] [Created] (KYLIN-983) Query sql offset keyword bug

Xiaoyu Wang created KYLIN-983:
---------------------------------

             Summary: Query sql offset keyword bug
                 Key: KYLIN-983
                 URL: https://issues.apache.org/jira/browse/KYLIN-983
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine, Storage - HBase
    Affects Versions: v0.7.2
            Reporter: Xiaoyu Wang
            Assignee: liyang


SQL is:
{code}
select type,count(*) from test group by type limit 1 offset 10
{code}
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.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)