[
https://issues.apache.org/jira/browse/KYLIN-5306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
pengfei.zhan updated KYLIN-5306:
--------------------------------
Affects Version/s: 5.0-alpha
> [kylin5] Allow more inner join keys in sql than the model
> ---------------------------------------------------------
>
> Key: KYLIN-5306
> URL: https://issues.apache.org/jira/browse/KYLIN-5306
> Project: Kylin
> Issue Type: Improvement
> Affects Versions: 5.0-alpha
> Reporter: Zhong Yanghong
> Priority: Major
> Labels: 5.0.0-alpha
>
> The join in model defined as follows:
> {code}
> from LINEORDER
> INNER JOIN CUSTOMER
> ON LINEORDER.LO_CUSTKEY=CUSTOMER.C_CUSTKEY
> INNER JOIN SUPPLIER
> ON LINEORDER.LO_SUPPKEY=SUPPLIER.S_SUPPKEY
> INNER JOIN PART
> ON LINEORDER.LO_PARTKEY=PART.P_PARTKEY
> INNER JOIN DATES
> ON LINEORDER.LO_ORDERDATE=DATES.D_DATEKEY
> {code}
> The join in SQL is as follows:
> {code}
> from LINEORDER
> INNER JOIN CUSTOMER
> ON LINEORDER.LO_CUSTKEY=CUSTOMER.C_CUSTKEY and LO_SHIPMODE = C_NATION
> INNER JOIN SUPPLIER
> ON LINEORDER.LO_SUPPKEY=SUPPLIER.S_SUPPKEY
> INNER JOIN PART
> ON LINEORDER.LO_PARTKEY=PART.P_PARTKEY
> INNER JOIN DATES
> ON LINEORDER.LO_ORDERDATE=DATES.D_DATEKEY
> {code}
> Ideally, the SQL can be transferred as
> {code}
> from LINEORDER
> INNER JOIN CUSTOMER
> ON LINEORDER.LO_CUSTKEY=CUSTOMER.C_CUSTKEY
> INNER JOIN SUPPLIER
> ON LINEORDER.LO_SUPPKEY=SUPPLIER.S_SUPPKEY
> INNER JOIN PART
> ON LINEORDER.LO_PARTKEY=PART.P_PARTKEY
> INNER JOIN DATES
> ON LINEORDER.LO_ORDERDATE=DATES.D_DATEKEY
> where LO_SHIPMODE = C_NATION
> {code}
> so that the model will be able to match the SQL.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
