[ https://issues.apache.org/jira/browse/KYLIN-2706?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16119781#comment-16119781 ]
kangkaisen commented on KYLIN-2706: ----------------------------------- Thanks hongbin. This is the commit: https://github.com/apache/kylin/commit/659eeaedd571c837df3beae44456dadde3036c3d > Fix the bug for the comparator in SortedIteratorMergerWithLimit > --------------------------------------------------------------- > > Key: KYLIN-2706 > URL: https://issues.apache.org/jira/browse/KYLIN-2706 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Affects Versions: v2.0.0 > Reporter: kangkaisen > Assignee: kangkaisen > Attachments: KYLIN-2706.patch > > > For this SQL, which should disable Storage limit push. Because this SQL will > return more than one record from HBase tables, but the > SortedIteratorMergerWithLimit only return one record, which will get wrong > result. > {code:java} > SELECT sum(A) > FROM TABLE > WHERE date_id >= 20170624 and date_id <= 20170626 > limit 1 > {code} > We should disable Storage limit push down when singleValuesD doesn't > containsAll othersD -- This message was sent by Atlassian JIRA (v6.4.14#64029)