Danylo Krupnyk created HIVE-26209: ------------------------------------- Summary: 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
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)