[ https://issues.apache.org/jira/browse/KYLIN-5328?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
pengfei.zhan updated KYLIN-5328: -------------------------------- Description: Setting `kylin.query.join-match-optimization-enabled=true`, we can use the left join model to answer the inner join query statement. But it encounters a bug. For example: The model is as follows, {code} lineorder inner join customer on lineorder.lo_custkey = customer.c_custkey left join dates on lineorder.lo_orderdate = dates.d_datekey {code} The query statement is as follows can match this model, {code} select lineorder.lo_linenumber from ssb.lineorder inner join ssb.customer on lineorder.lo_custkey = customer.c_custkey left join ssb.dates on lineorder.lo_orderdate = dates.d_datekey {code} However, the query statement is as follows cannot match this model, {code} select lineorder.lo_linenumber from ssb.customer inner join ssb.lineorder as lineorder on lineorder.lo_custkey = customer.c_custkey left join ssb.dates as dates on lineorder.lo_orderdate = dates.d_datekey {code} was: Setting `kylin.query.join-match-optimization-enabled=true`, we can use the left join model to answer the inner join query statement. But it encounters a bug. For example: The model is as follows, {code} lineorder inner join customer on lineorder.lo_custkey = customer.c_custkey left join dates on lineorder.lo_orderdate = dates.d_datekey {code} The query statement is as follows can match this model, ``` sql select lineorder.lo_linenumber from ssb.lineorder inner join ssb.customer on lineorder.lo_custkey = customer.c_custkey left join ssb.dates on lineorder.lo_orderdate = dates.d_datekey ``` However, the query statement is as follows cannot match this model, ```sql select lineorder.lo_linenumber from ssb.customer inner join ssb.lineorder as lineorder on lineorder.lo_custkey = customer.c_custkey left join ssb.dates as dates on lineorder.lo_orderdate = dates.d_datekey ``` > Query match join error > ---------------------- > > Key: KYLIN-5328 > URL: https://issues.apache.org/jira/browse/KYLIN-5328 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Affects Versions: 5.0-alpha > Reporter: pengfei.zhan > Assignee: pengfei.zhan > Priority: Major > Fix For: 5.0-alpha > > > Setting `kylin.query.join-match-optimization-enabled=true`, we can use the > left join model to answer the inner join query statement. But it encounters a > bug. > For example: > The model is as follows, > {code} > lineorder > inner join customer on lineorder.lo_custkey = customer.c_custkey > left join dates on lineorder.lo_orderdate = dates.d_datekey > {code} > The query statement is as follows can match this model, > {code} > select lineorder.lo_linenumber > from ssb.lineorder > inner join ssb.customer on lineorder.lo_custkey = customer.c_custkey > left join ssb.dates on lineorder.lo_orderdate = dates.d_datekey > {code} > However, the query statement is as follows cannot match this model, > {code} > select lineorder.lo_linenumber > from ssb.customer > inner join ssb.lineorder as lineorder on lineorder.lo_custkey = > customer.c_custkey > left join ssb.dates as dates on lineorder.lo_orderdate = dates.d_datekey > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)