[
https://issues.apache.org/jira/browse/KYLIN-5306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhong Yanghong updated KYLIN-5306:
----------------------------------
Description:
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.
> [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
> Reporter: Zhong Yanghong
> Priority: Major
>
> 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)
