[KYLIN-4480] Implement runtime non-equi join

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: v3.1.0
• Component/s: Query Engine
• Sprint: Sprint 52
• Assignee: Li Xian
• Reporter: Li Xian
• Created: 06/May/20 07:37
• Updated: 10/Jul/20 12:18
• Resolved: 04/Jun/20 15:58

Description

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

    select
      |
    non-equi join
     /        \
   subquery1  subquery2

can now be executed like below. Kylin will read data from subquery cubes and do non-equi join during runtime

    select
      |
    runtime non-equi join
     /        \
   cube1     cube2

I have submitted a PR for this issue

https://github.com/apache/kylin/pull/1195

https://github.com/Kyligence/calcite/pull/133