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)