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

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Not A Problem
• Affects Version/s: v2.0.0
• Fix Version/s: v2.6.0
• Component/s: Query Engine
• Labels: patch
• Environment: kylin 2.0 hbase 1.2.0
• Assignee: Zhong Yanghong
• Reporter: zhang
• Created: 13/Mar/18 09:43
• Updated: 12/Jan/19 06:41
• Resolved: 27/Dec/18 01:44

Description

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结果一致。