maheshk114 commented on a change in pull request #1147:
URL: https://github.com/apache/hive/pull/1147#discussion_r459986329
##########
File path:
ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveSubQueryRemoveRule.java
##########
@@ -414,6 +416,13 @@ private RexNode rewriteInExists(RexSubQuery e,
Set<CorrelationId> variablesSet,
// null keys we do not need to generate count(*), count(c)
if (e.getKind() == SqlKind.EXISTS) {
logic = RelOptUtil.Logic.TRUE_FALSE;
+ if (conf.getBoolVar(HiveConf.ConfVars.HIVE_CONVERT_ANTI_JOIN)) {
+ //TODO : As of now anti join is first converted to left outer join
Review comment:
Now also the conversion is not done. The code is present but actual
conversion is not done and logic is still TRUE_FALSE. For the code to be
effective , the logic should be changed to FALSE. I have not done it yet, as it
was causing some change in plan which i could not judge to be expected or not.
Anyways i have created a JIRA to track this.
https://issues.apache.org/jira/browse/HIVE-23928
----------------------------------------------------------------
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]
