[
https://issues.apache.org/jira/browse/FLINK-5256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15767649#comment-15767649
]
Fabian Hueske commented on FLINK-5256:
--------------------------------------
The feature can be tested with the following test case:
{code}
@Test
def testSingleRowOuterJoin(): Unit = {
val env = ExecutionEnvironment.getExecutionEnvironment
val tEnv = TableEnvironment.getTableEnvironment(env, config)
val sqlQuery =
"SELECT a, cnt FROM t1 LEFT JOIN (SELECT COUNT(*) AS cnt FROM t2) AS x ON a
> cnt"
val ds1 = CollectionDataSets.get5TupleDataSet(env).toTable(tEnv).as('a, 'b,
'c, 'd, 'e)
val ds2 = CollectionDataSets.getSmall3TupleDataSet(env).toTable(tEnv)
tEnv.registerTable("t1", ds1)
tEnv.registerTable("t2", ds2)
val result = tEnv.sql(sqlQuery)
val expected = Seq(
"1,null",
"2,null", "2,null",
"3,null", "3,null", "3,null",
"4,3", "4,3", "4,3", "4,3",
"5,3", "5,3", "5,3", "5,3", "5,3").mkString("\n")
val results = result.toDataSet[Row].collect()
TestBaseUtils.compareResultAsText(results.asJava, expected)
}
{code}
> 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
> Assignee: Anton Mushin
>
> 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)
