[
https://issues.apache.org/jira/browse/KYLIN-4480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17126029#comment-17126029
]
nichunen edited comment on KYLIN-4480 at 6/4/20, 3:58 PM:
----------------------------------------------------------
Tested with sql
{code:java}
SELECT * FROM
(
SELECT PART_DT, TRANS_ID FROM KYLIN_SALES GROUP BY PART_DT, TRANS_ID
) FACT
LEFT JOIN
(
SELECT CAL_DT as DT_CAL_DT, WEEK_BEG_DT FROM KYLIN_CAL_DT
) DT
ON FACT.PART_DT = DT.DT_CAL_DT AND WEEK_BEG_DT != DATE'2013-03-24'
{code}
!image-2020-06-04-23-57-51-652.png!
was (Author: nichunen):
Tested with sql
{code:java}
SELECT * FROM
(
SELECT PART_DT, TRANS_ID FROM KYLIN_SALES GROUP BY PART_DT, TRANS_ID
) FACT
LEFT JOIN
(
SELECT CAL_DT as DT_CAL_DT, WEEK_BEG_DT FROM KYLIN_CAL_DT
) DT
ON FACT.PART_DT = DT.DT_CAL_DT AND WEEK_BEG_DT = DATE'2013-03-24'
{code}
!image-2020-06-04-23-57-51-652.png!
> Implement runtime non-equi join
> -------------------------------
>
> Key: KYLIN-4480
> URL: https://issues.apache.org/jira/browse/KYLIN-4480
> Project: Kylin
> Issue Type: New Feature
> Components: Query Engine
> Reporter: Li Xian
> Assignee: Li Xian
> Priority: Minor
> Fix For: v3.1.0
>
> Attachments: image-2020-06-04-23-57-32-114.png,
> image-2020-06-04-23-57-39-920.png, image-2020-06-04-23-57-51-652.png
>
>
> Currently Kylin does not support non-equi join. This issue is aim to add
> runtime non-equi join feature to Kylin so that queries like
> {code:java}
> select
> |
> non-equi join
> / \
> subquery1 subquery2
> {code}
> can now be executed like below. Kylin will read data from subquery cubes and
> do non-equi join during runtime
> {code:java}
> select
> |
> runtime non-equi join
> / \
> cube1 cube2
> {code}
> I have submitted a PR for this issue
> [https://github.com/apache/kylin/pull/1195]
> [https://github.com/Kyligence/calcite/pull/133]
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
