[ https://issues.apache.org/jira/browse/KYLIN-3830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16790145#comment-16790145 ]
Yuzhang QIU commented on KYLIN-3830: ------------------------------------ Query kylin_sales by this sql in kylin ``` SELECT SUM(SELLER_ID) FROM KYLIN_SALES ; ``` return 10000499500. But it's return 100004990384 in hive. > return wrong result when 'SELECT SUM(dim1)' without set a relative metric of > dim1. > ---------------------------------------------------------------------------------- > > Key: KYLIN-3830 > URL: https://issues.apache.org/jira/browse/KYLIN-3830 > Project: Kylin > Issue Type: Bug > Affects Versions: v2.5.2 > Reporter: Yuzhang QIU > Priority: Major > > Hi, dear team: > I design an cube1 based on table table1 with dim1, dim2, dim3.... and only > one metric count(1), and 'SELECT SUM(dim1) FROM table1 group by dim2', Kylin > process this SQL and return some result1. It seems ok. But as we know, Kylin > don't store the detail data, the dimensions' members have been encoded and > stored in Hbase as rowkey(cause I don't set any metric with an column). So, > is the result1 right? > Then, I clone cube1 to cube2, and set a metric SUM(dim1). the same SQL has > been passed to kylin and got result2. It's different from result1 at the > aggregation field. I also pass same SQL to hive and got result3, it's same > with result2. > Yes, I turn off the pushdown. > I think there are some problems. > I can't upload some picture of results for secret policy, sorry for that. -- This message was sent by Atlassian JIRA (v7.6.3#76005)