Joe McDonnell has posted comments on this change. ( http://gerrit.cloudera.org:8080/21908 )
Change subject: IMPALA-13429: Calcite planner crashing with outer join ...................................................................... Patch Set 2: (1 comment) http://gerrit.cloudera.org:8080/#/c/21908/2/java/calcite-planner/src/main/java/org/apache/impala/calcite/rel/node/ImpalaJoinRel.java File java/calcite-planner/src/main/java/org/apache/impala/calcite/rel/node/ImpalaJoinRel.java: http://gerrit.cloudera.org:8080/#/c/21908/2/java/calcite-planner/src/main/java/org/apache/impala/calcite/rel/node/ImpalaJoinRel.java@444 PS2, Line 444: // left side expr may only contain inputrefs from left side. : // right side expr may only contain inputrefs from right side. For my own understanding, let me work through some examples. Suppose we are joining table A (left) with table B (right). Here are some conjuncts: 1. "A.id = B.id" - classic equijoin 2. "A.id = B.id + B.offset" - equijoin 3. "A.id - B.offset = B.id" - not an equijoin conjunct (first for loop triggers) 4. "A.id = B.id - A.offset" - not an equijoin conjunct (second for loop triggers) 5. "A.id = A.int_col" - not an equijoin conjunct (second for loop triggers) 6. "A.id = 2" - not an equijoin conjunct (??) I'm a bit unclear whether this function would encounter conjuncts like #5 and #6. Those could be pushed down to the children. #3/#4 are conjuncts that could come up and would be assigned to a join (and this looks good for those). >From walking through this, would #6 return true here? It's left side is ok and >it doesn't have any inputs on the right side. -- To view, visit http://gerrit.cloudera.org:8080/21908 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I4ae2d257fa58f3a58079b6aa551c32ffda7d28cf Gerrit-Change-Number: 21908 Gerrit-PatchSet: 2 Gerrit-Owner: Steve Carlin <[email protected]> Gerrit-Reviewer: Aman Sinha <[email protected]> Gerrit-Reviewer: Anonymous Coward (816) Gerrit-Reviewer: Impala Public Jenkins <[email protected]> Gerrit-Reviewer: Joe McDonnell <[email protected]> Gerrit-Reviewer: Michael Smith <[email protected]> Gerrit-Reviewer: Steve Carlin <[email protected]> Gerrit-Comment-Date: Thu, 10 Oct 2024 04:16:11 +0000 Gerrit-HasComments: Yes
