[KYLIN-5328] Query match join error

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 5.0-alpha
• Component/s: Query Engine
• Assignee: pengfei.zhan
• Reporter: pengfei.zhan
• Created: 01/Dec/22 14:58
• Updated: 23/Aug/23 07:56

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,

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,

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,

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