Yuzhang QIU created KYLIN-3830:
----------------------------------
Summary: 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
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)
