You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "kangkaisen (JIRA)" <ji...@apache.org> on 2017/07/03 12:47:00 UTC
[jira] [Updated] (KYLIN-2706) Should disable Storage limit push
down when singleValuesD doesn't containsAll othersD
[ https://issues.apache.org/jira/browse/KYLIN-2706?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
kangkaisen updated KYLIN-2706:
------------------------------
Attachment: KYLIN-2706.patch
This is the patch.
> Should disable Storage limit push down when singleValuesD doesn't containsAll othersD
> -------------------------------------------------------------------------------------
>
> 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)