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

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

     [ https://issues.apache.org/jira/browse/KYLIN-3291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shaofeng SHI updated KYLIN-3291:
--------------------------------
    Fix Version/s: v2.6.0

> 在构建好的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
>            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)