[ https://issues.apache.org/jira/browse/KYLIN-3291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zhong Yanghong resolved KYLIN-3291. ----------------------------------- Resolution: Not A Problem > 在构建好的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 > Assignee: Zhong Yanghong > Priority: Blocker > Labels: patch > Fix For: v2.6.0 > > > 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)