meizhennan created KYLIN-3746:
---------------------------------
Summary: group by an expression ,the limit is impact result
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
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)
