maheshk114 commented on a change in pull request #1147:
URL: https://github.com/apache/hive/pull/1147#discussion_r466822516
##########
File path: ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java
##########
@@ -2129,6 +2133,16 @@ private RelNode applyPreJoinOrderingTransforms(RelNode
basePlan, RelMetadataProv
HiveRemoveSqCountCheck.INSTANCE);
}
+ // 10. Convert left outer join + null filter on right side table column
to anti join. Add this
+ // rule after all the optimization for which calcite support for anti
join is missing.
+ // Needs to be done before ProjectRemoveRule as it expect a project over
filter.
+ // This is done before join re-ordering as join re-ordering is
converting the left outer
Review comment:
As discussed, i have created a Jira
https://issues.apache.org/jira/browse/HIVE-24013
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
