You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@kylin.apache.org by "bright liao (Jira)" <ji...@apache.org> on 2020/06/03 08:03:00 UTC

[jira] [Created] (KYLIN-4544) Kylin on Parquet不兼容LEFT JOIN

bright liao created KYLIN-4544:
----------------------------------

             Summary: Kylin on Parquet不兼容LEFT JOIN
                 Key: KYLIN-4544
                 URL: https://issues.apache.org/jira/browse/KYLIN-4544
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: v4.0.0-beta
            Reporter: bright liao
             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)