pengfei.zhan created KYLIN-5328: ----------------------------------- Summary: 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 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, ``` lineorder inner join customer on lineorder.lo_custkey = customer.c_custkey left join dates on lineorder.lo_orderdate = dates.d_datekey ``` 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 ``` -- This message was sent by Atlassian Jira (v8.20.10#820010)