[ 
https://issues.apache.org/jira/browse/KYLIN-983?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14732285#comment-14732285
 ] 

hongbin ma commented on KYLIN-983:
----------------------------------

hi, xiaoyu

how did you made the patch? I cannot merge it:

➜  Kylin-0.7 git:(0.7-staging) git apply --check 
~/Desktop/KYLIN-983-Query-sql-offset-keyword-bug-V2.patch 
error: 
src/main/java/org/apache/kylin/storage/hbase/SerializedHBaseTupleIterator.java: 
No such file or directory
error: src/main/java/org/apache/kylin/storage/StorageContext.java: No such file 
or directory
error: src/test/java/org/apache/kylin/query/test/KylinQueryTest.java: No such 
file or directory
error: src/main/java/org/apache/kylin/query/relnode/OLAPLimitRel.java: No such 
file or directory

please use git format-patch: 
http://kylin.incubator.apache.org/development/howto_contribute.html
And will you please also make a patch for branch 0.8?

> 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
>             Fix For: v2.0, v1.1
>
>         Attachments: KYLIN-983-Query-sql-offset-keyword-bug-V2.patch, 
> KYLIN-983-Query-sql-offset-keyword-bug.patch
>
>
> 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)

Reply via email to