You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2018/12/28 05:37:00 UTC
[jira] [Updated] (KYLIN-3746) Limit should not be pushed down when
group by an expression
[ https://issues.apache.org/jira/browse/KYLIN-3746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shaofeng SHI updated KYLIN-3746:
--------------------------------
Summary: Limit should not be pushed down when group by an expression (was: group by an expression ,the limit is impact result)
> Limit should not be pushed down when group by an expression
> ------------------------------------------------------------
>
> Key: KYLIN-3746
> URL: https://issues.apache.org/jira/browse/KYLIN-3746
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v2.5.2
> Reporter: meizhennan
> Priority: Major
> Attachments: image-2018-12-28-12-04-20-536.png, image-2018-12-28-12-09-37-507.png, image-2018-12-28-12-15-37-539.png
>
>
> For example:
> SELECT case when hk_optime-hk_createtime <60 then 1 when hk_optime-hk_createtime <300 then 2 when hk_optime-hk_createtime <900 then 3 else 4 end,count(1)
> FROM temp_nativeapp_tblQuestion_dayinc
> WHERE dt = '20181223'
> AND hk_optime != 0
> and hk_createtime>1545494400
> group by case when hk_optime-hk_createtime <60 then 1 when hk_optime-hk_createtime <300 then 2 when hk_optime-hk_createtime <900 then 3 else 4 end
>
> when i use the choose the limit , the result is wrong.
> !image-2018-12-28-12-09-37-507.png!
> but i cancle the limit ,the result is rigth.
> !image-2018-12-28-12-04-20-536.png!
>
> when i use the purely column "hk_delay" , "hk_delay" is same the expression "hk_optime-hk_createtime" .limit is not impact the result.
> !image-2018-12-28-12-15-37-539.png!
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)