[jira] [Created] (KYLIN-5328) Query match join error

["pengfei.zhan (Jira)" <ji...@apache.org>]

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)