[jira] [Commented] (HIVE-26209) HIVE CBO. Wrong results with Hive SQL query with MULTIPLE IN conditions in where clause if CBO enabled

["Stamatis Zampetakis (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-26209?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17534435#comment-17534435 ] 

Stamatis Zampetakis commented on HIVE-26209:
--------------------------------------------

[~TORBACH] For what is worth, I have seen this ticket after replying to stackoverflow.

> 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: Critical
>
> 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)