Details
-
Bug
-
Status: Closed
-
Blocker
-
Resolution: Not A Problem
-
v2.0.0
-
kylin 2.0 hbase 1.2.0
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结果一致。