Mailing-List: contact dev-help@flink.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@flink.apache.org
Date: Mon, 5 Dec 2016 08:22:58 +0000 (UTC)
From: "Fabian Hueske (JIRA)" <jira@apache.org>
To: dev@flink.apache.org
Message-ID: <JIRA.13025564.1480926154000.436619.1480926178731@Atlassian.JIRA>
In-Reply-To: <JIRA.13025564.1480926154000@Atlassian.JIRA>
References: <JIRA.13025564.1480926154000@Atlassian.JIRA> <JIRA.13025564.1480926154815@arcas>
Subject: [jira] [Created] (FLINK-5256) Extend DataSetSingleRowJoin to
 support Left and Right joins
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Mon, 05 Dec 2016 08:23:06 -0000

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)