[
https://issues.apache.org/jira/browse/HIVE-26659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17690998#comment-17690998
]
Sungwoo Park commented on HIVE-26659:
-------------------------------------
For testing hive.auto.convert.anti.join, we used Hive on Tez.
1) create a database consisting of external tables from a 100GB TPC-DS text
dataset
2) load a database consisting of ORC tables
3) compute column statistics
4) run TPC-DS queries
5) check the results for correctness
With hive.auto.convert.anti.join set to true (default), wrong results are
returned. Setting hive.auto.convert.anti.join to false fixed the errors.
> TPC-DS query 16, 69, 94 return wrong results.
> ---------------------------------------------
>
> Key: HIVE-26659
> URL: https://issues.apache.org/jira/browse/HIVE-26659
> Project: Hive
> Issue Type: Sub-task
> Affects Versions: 4.0.0-alpha-2
> Reporter: Sungwoo Park
> Priority: Major
>
> TPC-DS query 16, 69, 94 return wrong results when hive.auto.convert.anti.join
> is set to true.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
