[ https://issues.apache.org/jira/browse/KYLIN-4544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
wangrupeng updated KYLIN-4544: ------------------------------ Summary: Kylin on Parquet LEFT JOIN Query failed (was: Kylin on Parquet不兼容LEFT JOIN) > 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 > Priority: Major > Fix For: v4.0.0-beta > > > 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 > 查询出错,但在3.0版本可以。 > 错误信息如下: > 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.3.4#803005)