[
https://issues.apache.org/jira/browse/FLINK-5256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15986357#comment-15986357
]
ASF GitHub Bot commented on FLINK-5256:
---------------------------------------
Github user fhueske commented on a diff in the pull request:
https://github.com/apache/flink/pull/3673#discussion_r113664467
--- Diff:
flink-libraries/flink-table/src/main/scala/org/apache/flink/table/plan/nodes/dataset/DataSetSingleRowJoin.scala
---
@@ -138,32 +146,97 @@ class DataSetSingleRowJoin(
val condition = codeGenerator.generateExpression(joinCondition)
val joinMethodBody =
- s"""
- |${condition.code}
- |if (${condition.resultTerm}) {
- | ${conversion.code}
- |
${codeGenerator.collectorTerm}.collect(${conversion.resultTerm});
- |}
- |""".stripMargin
+ if (joinType == JoinRelType.INNER) {
+ s"""
+ |${condition.code}
+ |if (${condition.resultTerm}) {
+ | ${conversion.code}
+ |
${codeGenerator.collectorTerm}.collect(${conversion.resultTerm});
+ |}
+ |""".stripMargin
+ } else {
+ val singleNode =
+ if (rightIsSingle) {
+ rightNode
+ }
+ else {
+ leftNode
+ }
+
+ val notSuitedToCondition = singleNode
+ .getRowType
+ .getFieldList
+ .map(field => getRowType.getFieldNames.indexOf(field.getName))
+ .map(i => s"${conversion.resultTerm}.setField($i,null);")
+
+ if (joinType == JoinRelType.LEFT && leftIsSingle) {
+ s"""
+ |${condition.code}
+ |${conversion.code}
+ |if(!${condition.resultTerm}){
+ |${notSuitedToCondition.mkString("\n")}
+ |}
+ |if(!${condition.leftNullTerm}){
+
|${codeGenerator.collectorTerm}.collect(${conversion.resultTerm});
+ |}
+ |""".stripMargin
+ } else if (joinType == JoinRelType.RIGHT && rightIsSingle){
+ s"""
+ |${condition.code}
+ |${conversion.code}
+ |if(!${condition.resultTerm}){
+ |${notSuitedToCondition.mkString("\n")}
+ |}
+ |if(!${condition.leftNullTerm} && ${condition.resultTerm}){
+
|${codeGenerator.collectorTerm}.collect(${conversion.resultTerm});
+ |}
+ |""".stripMargin
+ } else {
+ s"""
+ |${condition.code}
+ |${conversion.code}
+ |if(!${condition.resultTerm}){
--- End diff --
we can add `|| ${codeGenerator.input1Term} == null` to check if the first
input is null for the `JoinRelType.RIGHT && leftIsSingle` case and `||
${codeGenerator.input2Term} == null` for the `JoinRelType.LEFT &&
rightIsSingle` case
> 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: Dmytro Shkvyra
>
> 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.15#6346)
