[jira] [Created] (KYLIN-3291) 在构建好的cube上提交逻辑相同的sql查询结果不同

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

zhang created KYLIN-3291:
----------------------------

             Summary: 在构建好的cube上提交逻辑相同的sql查询结果不同
                 Key: KYLIN-3291
                 URL: https://issues.apache.org/jira/browse/KYLIN-3291
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: v2.0.0
         Environment: kylin 2.0    hbase 1.2.0
            Reporter: zhang


select 
    a.agent
	,b.channel_name
	,a.ONLINE_SECONDS_TYPE
	,a.pt_dt
	,count(*) ct
from (
    select
        agent , ONLINE_SECONDS_TYPE ,pt_dt
    from zhangyc02.DM_CHL_REGUSER_1D_WIDETABLE_D 
    where pt_dt>='2017-12-01' and pt_dt<='2017-12-03' and agent in (60000,30000)
) a
left join zhangyc02.dim_res_info b
on a.agent = b.channel_id
group by a.agent,b.channel_name,a.ONLINE_SECONDS_TYPE,a.pt_dt
order by agent, pt_dt , ONLINE_SECONDS_TYPE	;
这种查询结果是错误的

select
    a.agent
    ,b.channel_name agent_name
    ,a.ONLINE_SECONDS_TYPE
    ,pt_dt
    ,count(*) ct
from zhangyc02.DM_CHL_REGUSER_1D_WIDETABLE_D a
left join zhangyc02.dim_res_info b
on a.agent = b.channel_id
where pt_dt>='2017-12-01' and pt_dt<='2017-12-03' and a.agent in (60000,30000)
group by a.agent,b.channel_name,a.ONLINE_SECONDS_TYPE,a.pt_dt
order by agent, pt_dt , ONLINE_SECONDS_TYPE	;
这种查询结果是正确的

校验方式：我将两个sql在impala中分别查询，结果一致并且与kylin中的下面的sql结果一致。



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)