[jira] [Comment Edited] (KYLIN-1980) TopN issue: result not consistent with hive

["Zhong Yanghong (JIRA)" <ji...@apache.org>]

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

Zhong Yanghong edited comment on KYLIN-1980 at 8/29/16 8:50 AM:
----------------------------------------------------------------

A cube based on the sample data with measure TopN is created. When do the following query, 

select seller_id, sum(price) as price_sum
from kylin_sales 
group by seller_id
order by price_sum
desc
limit 15

The result by kylin is shown in figure 
!kylin_result.png!
The result by hive is shown in figure 
!hive_result.png!

For seller id with 10000102, it's strange that the related result by hive is smaller than the one by kylin with TopN.


was (Author: yaho):
A cube based on the sample data with measure TopN is created. When do the following query, 

select seller_id, sum(price) as price_sum
from kylin_sales 
group by seller_id
order by price_sum
desc
limit 15

The result by kylin is shown in figure !kylin_result.png|thumbnail!
The result by hive is shown in figure !hive_result.png|thumbnail!

For seller id with 10000102, it's strange that the related result by hive is smaller than the one by kylin with TopN.

> TopN issue: result not consistent with hive
> -------------------------------------------
>
>                 Key: KYLIN-1980
>                 URL: https://issues.apache.org/jira/browse/KYLIN-1980
>             Project: Kylin
>          Issue Type: Bug
>            Reporter: Zhong Yanghong
>         Attachments: hive_result.png, kylin_result.png
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)