[
https://issues.apache.org/jira/browse/KYLIN-3830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shaofeng SHI reassigned KYLIN-3830:
-----------------------------------
Assignee: Yuzhang QIU
> 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
> Assignee: 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)
