[
https://issues.apache.org/jira/browse/HIVE-26209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Danylo Krupnyk updated HIVE-26209:
----------------------------------
Description:
I am running one SQL query in Hive and it gives different results with CBO
enabled and disabled. The results are wrong when CBO is enabled (set
hive.cbo.enable=true; ).
{*}Prerequisites{*}: Apache Hadoop 2.10.1 + Apache Hive 2.3.6 installed. (I
tried to reproduce the issue with Apache Hive 3+ version and Hadoop 3+ version
and they work fine.)
Actions to reproduce you can find in stackoverflow ticket here -
[https://stackoverflow.com/questions/71825360/hive-cbo-wrong-results-with-hive-sql-query-with-multiple-in-conditions-in-where]
was:
I am running one SQL query in Hive and it gives different results with CBO
enabled and disabled. The results are wrong when CBO is enabled (set
hive.cbo.enable=true;).
{*}Prerequisites{*}: Apache Hadoop 2.10.1 + Apache Hive 2.3.6 installed. (I
tried to reproduce the issue with Apache Hive 3+ version and Hadoop 3+ version
and they work fine.)
Actions to reproduce you can find in stackoverflow ticket here -
https://stackoverflow.com/questions/71825360/hive-cbo-wrong-results-with-hive-sql-query-with-multiple-in-conditions-in-where
> HIVE CBO. Wrong results with Hive SQL query with MULTIPLE IN conditions in
> where clause if CBO enabled
> ------------------------------------------------------------------------------------------------------
>
> Key: HIVE-26209
> URL: https://issues.apache.org/jira/browse/HIVE-26209
> Project: Hive
> Issue Type: Bug
> Components: CBO, Hive
> Affects Versions: 2.3.6
> Reporter: Danylo Krupnyk
> Priority: Major
>
> I am running one SQL query in Hive and it gives different results with CBO
> enabled and disabled. The results are wrong when CBO is enabled (set
> hive.cbo.enable=true; ).
> {*}Prerequisites{*}: Apache Hadoop 2.10.1 + Apache Hive 2.3.6 installed. (I
> tried to reproduce the issue with Apache Hive 3+ version and Hadoop 3+
> version and they work fine.)
> Actions to reproduce you can find in stackoverflow ticket here -
> [https://stackoverflow.com/questions/71825360/hive-cbo-wrong-results-with-hive-sql-query-with-multiple-in-conditions-in-where]
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
