[
https://issues.apache.org/jira/browse/HIVE-27124?focusedWorklogId=852227&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-852227
]
ASF GitHub Bot logged work on HIVE-27124:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 22/Mar/23 10:55
Start Date: 22/Mar/23 10:55
Worklog Time Spent: 10m
Work Description: zabetak commented on code in PR #4101:
URL: https://github.com/apache/hive/pull/4101#discussion_r1144598686
##########
common/src/java/org/apache/hadoop/hive/conf/HiveConf.java:
##########
@@ -2366,8 +2366,11 @@ public static enum ConfVars {
"Whether Hive enables the optimization about converting common join
into mapjoin based on the input file size. \n" +
"If this parameter is on, and the sum of size for n-1 of the
tables/partitions for a n-way join is smaller than the\n" +
"specified size, the join is directly converted to a mapjoin (there is
no conditional task)."),
- HIVE_CONVERT_ANTI_JOIN("hive.auto.convert.anti.join", true,
- "Whether Hive enables the optimization about converting join with null
filter to anti join"),
+ HIVE_CONVERT_ANTI_JOIN("hive.auto.convert.anti.join", false,
+ "Whether Hive enables the optimization about converting join with null
filter to anti join. The " +
+ "default is currently false because of HIVE-25669. There is the
possibility of incorrect results. " +
Review Comment:
I suppose here you meant to point to HIVE-26659 (not HIVE-25669); I will
amend before merging.
Issue Time Tracking
-------------------
Worklog Id: (was: 852227)
Time Spent: 1h 40m (was: 1.5h)
> Temporarily disable default usage of anti-join
> ----------------------------------------------
>
> Key: HIVE-27124
> URL: https://issues.apache.org/jira/browse/HIVE-27124
> Project: Hive
> Issue Type: Improvement
> Components: Hive
> Reporter: Steve Carlin
> Priority: Major
> Labels: pull-request-available
> Time Spent: 1h 40m
> Remaining Estimate: 0h
>
> Temporarily disabling the default usage for antijoin due to wrong results as
> documented by HIVE-26659
--
This message was sent by Atlassian Jira
(v8.20.10#820010)