You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "Fabian Hueske (JIRA)" <ji...@apache.org> on 2016/12/05 08:22:58 UTC

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

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)