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

mukvin commented on KYLIN-5086:
-------------------------------

Test Evidence

agg func: Avg, Max, MIN, SUM, COUNT

 

without alias

!image-2021-09-09-11-04-25-230.png|width=617,height=253!

with alias

!image-2021-09-09-11-06-22-174.png|width=615,height=250!

 

Happy test query with same order of 
[https://cwiki.apache.org/confluence/display/KYLIN/Preparation+of+Regression+Testing#PreparationofRegressionTesting-Cubequery%E6%B5%8B%E8%AF%95SQL%E9%9B%86
]

(query cube)

!image-2021-09-09-11-18-23-937.png|width=614,height=263!

 

!image-2021-09-09-11-19-47-854.png|width=613,height=249!

 

!image-2021-09-09-11-21-07-953.png|width=610,height=264!

 

(query pushdown)

!image-2021-09-09-11-23-27-633.png|width=610,height=263!

!image-2021-09-09-11-25-27-561.png|width=610,height=263!

 

(query on snapshot)

!image-2021-09-09-11-26-37-832.png|width=601,height=259!

!image-2021-09-09-11-27-34-611.png|width=600,height=251!

!image-2021-09-09-11-28-15-801.png|width=598,height=255!

 

> When query pushdown, only measure result is empty
> -------------------------------------------------
>
>                 Key: KYLIN-5086
>                 URL: https://issues.apache.org/jira/browse/KYLIN-5086
>             Project: Kylin
>          Issue Type: Bug
>    Affects Versions: v4.0.0
>            Reporter: mukvin
>            Assignee: mukvin
>            Priority: Minor
>             Fix For: v4.0.1
>
>         Attachments: image-2021-09-09-10-24-30-999.png, 
> image-2021-09-09-10-25-43-672.png, image-2021-09-09-11-04-25-230.png, 
> image-2021-09-09-11-06-22-174.png, image-2021-09-09-11-18-23-937.png, 
> image-2021-09-09-11-19-47-854.png, image-2021-09-09-11-21-07-953.png, 
> image-2021-09-09-11-23-27-633.png, image-2021-09-09-11-25-27-561.png, 
> image-2021-09-09-11-26-37-832.png, image-2021-09-09-11-27-34-611.png, 
> image-2021-09-09-11-28-15-801.png
>
>
> when query pushdown with aggregation func without a alias will get an empty 
> appearance, but the real result already returned in response.
> result as followed:
> !image-2021-09-09-10-24-30-999.png!
> !image-2021-09-09-10-25-43-672.png!
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to