[jira] [Updated] (KYLIN-4544) Kylin on Parquet LEFT JOIN Query failed

[pengfei.zhan (Jira)]

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

pengfei.zhan updated KYLIN-4544:
--------------------------------
    Labels: kylin-4.x  (was: )

> Kylin on Parquet LEFT JOIN Query failed
> ---------------------------------------
>
>                 Key: KYLIN-4544
>                 URL: https://issues.apache.org/jira/browse/KYLIN-4544
>             Project: Kylin
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: bright liao
>            Assignee: Wang Rupeng
>            Priority: Major
>              Labels: kylin-4.x
>
> select t.n,t1.n from (
> select count(*) as n from dm.dm_bi_device_info_day where 
> deal_date='20200527') as t
> LEFT JOIN (
> select count(*) as n from dm.dm_bi_device_info_day where 
> deal_date='20200526') as t1
> on 1=1
> This sql execute failed while kylin-3.0 runs with no problem.
> Error message：
> Error while applying rule OLAPJoinRule, args 
> [rel#234029:LogicalJoin.NONE.[](left=rel#234022:Subset#3.NONE.[],right=rel#234028:Subset#6.NONE.[],condition==(1,
>  1),joinType=left)] while executing SQL: "select * from (select t.n,t1.n from 
> ( select count(*) as n from dm.dm_bi_device_info_day where 
> deal_date='20200527') as t LEFT JOIN ( select count(*) as n from 
> dm.dm_bi_device_info_day where deal_date='20200526') as t1 on 1=1) limit 
> 50000"



--
This message was sent by Atlassian Jira
(v8.20.10#820010)