You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "Lu Yi (JIRA)" <ji...@apache.org> on 2016/04/06 12:13:25 UTC
[jira] [Created] (KYLIN-1562) get wrong result from query
Lu Yi created KYLIN-1562:
----------------------------
Summary: get wrong result from query
Key: KYLIN-1562
URL: https://issues.apache.org/jira/browse/KYLIN-1562
Project: Kylin
Issue Type: Bug
Components: Query Engine
Affects Versions: v1.2
Environment: kylin 1.2
hbase 1.0
hadoop: cdh 5.4
Reporter: Lu Yi
Assignee: liyang
hi kylin,
we encountered an issue when using kylin 1.2. A query get wrong result.
the correct result :
select FACT.STAT_DATE as c0,
FACT.PRODUCT_TYPE_CN as c1,
FACT.ITEM_NAME as c3,
FACT.CLASS_GROUP_CN as c4,
sum(FACT.AUM) as m0
from (select * from fact_a) as FACT
where FACT.CLASS_GROUP_CN = 'o'
group by FACT.STAT_DATE, FACT.PRODUCT_TYPE_CN, FACT.CLASS_GROUP_CN;
result：
---------------------------------------------------------------
c0 c1 c3 c4 m0
01-01 一级市场 a o 123.98
01-01 二级市场 b o 783
01-02 一级市场 b o 999
when added an condition " FACT.ITEM_NAME in ('a','b')" then query is :
select
FACT.STAT_DATE as c0,
FACT.PRODUCT_TYPE_CN as c1,
FACT.ITEM_NAME as c2,
FACT.CLASS_GROUP_CN as c4,
sum(FACT.AUM) as m0
from (select * from fact_a) as FACT
where FACT.CLASS_GROUP_CN = 'o'
and FACT.ITEM_NAME in ('a','b')
group by FACT.STAT_DATE, FACT.PRODUCT_TYPE_CN, FACT.ITEM_NAME, FACT.CLASS_GROUP_CN;
result：
---------------------------------------------------------------
c0 c1 c3 c4 m0
01-01 一级市场 a o 123.98
01-02 一级市场 b o 999
you can see the c1 = '二级市场' is missed.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)