Github user fhueske commented on a diff in the pull request:

    https://github.com/apache/flink/pull/3033#discussion_r96419377
  
    --- Diff: 
flink-libraries/flink-table/src/main/scala/org/apache/flink/table/plan/nodes/dataset/DataSetSingleRowJoin.scala
 ---
    @@ -144,21 +150,46 @@ class DataSetSingleRowJoin(
     
         val condition = codeGenerator.generateExpression(joinCondition)
     
    -    val joinMethodBody = s"""
    -                  |${condition.code}
    -                  |if (${condition.resultTerm}) {
    -                  |  ${conversion.code}
    -                  |  
${codeGenerator.collectorTerm}.collect(${conversion.resultTerm});
    -                  |}
    -                  |""".stripMargin
    +    val joinMethodBody =
    +      if (joinType == JoinRelType.INNER) {
    +        s"""
    +         |${condition.code}
    +         |if (${condition.resultTerm}) {
    +         |  ${conversion.code}
    +         |  
${codeGenerator.collectorTerm}.collect(${conversion.resultTerm});
    +         |}
    +         |""".stripMargin
    +    } else {
    +        val singleNode =
    +          if (leftIsSingle) {
    +            leftNode
    +          }
    +          else {
    +            rightNode
    +          }
    +        val notSuitedToCondition = singleNode
    +          .getRowType
    +          .getFieldList
    +          .map(field => getRowType.getFieldNames.indexOf(field.getName))
    +          .map(i => s"${conversion.resultTerm}.setField($i,null);")
    --- End diff --
    
    This only works if the result term is a `Row`. 
    
    It think a better approach is to generate a dedicated result expression for 
the null case based on `CodeGenerator.generateResultExpression()`, where the 
field expressions are the outer fields and the null expressions. Then we could 
use the current result expression if the condition is met and the result 
expression with null values if that is not the case.
    
    We would need to extend the `CodeGenerator` with methods for 
`generateFieldAccesses(boolean firstInput)` (see 
`generateConverterResultExpression()`) and `generateNullValues(boolean 
firstInput)` which generates expressions for null values.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

Reply via email to