[jira] [Created] (FLINK-5256) Extend DataSetSingleRowJoin to support Left and Right joins

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (FLINK-5256) Extend DataSetSingleRowJoin to support Left and Right joins

Shang Yuanchun (Jira)
Fabian Hueske created FLINK-5256:
------------------------------------

             Summary: Extend DataSetSingleRowJoin to support Left and Right joins
                 Key: FLINK-5256
                 URL: https://issues.apache.org/jira/browse/FLINK-5256
             Project: Flink
          Issue Type: Improvement
          Components: Table API & SQL
    Affects Versions: 1.2.0
            Reporter: Fabian Hueske


The {{DataSetSingleRowJoin}} is a broadcast-map join that supports arbitrary inner joins where one input is a single row.

I found that Calcite translates certain subqueries into non-equi left and right joins with single input. These cases can be handled if the  {{DataSetSingleRowJoin}} is extended to support outer joins on the non-single-row input, i.e., left joins if the right side is single input and vice versa.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)