[
https://issues.apache.org/jira/browse/KYLIN-4544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
wangrupeng updated KYLIN-4544:
------------------------------
Description:
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"
was:
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"
> 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
> 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.3.4#803005)
