[
https://issues.apache.org/jira/browse/HIVE-28705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17926349#comment-17926349
]
Denys Kuzmenko commented on HIVE-28705:
---------------------------------------
Merged to master
Thanks [~Indhumathi27] for the fix!
> Data Inconsistency due to missing 'IS NOT? TRUE/FALSE' parsing in Partition
> Filter Pruning
> ------------------------------------------------------------------------------------------
>
> Key: HIVE-28705
> URL: https://issues.apache.org/jira/browse/HIVE-28705
> Project: Hive
> Issue Type: Bug
> Reporter: chiranjeevi
> Assignee: Indhumathi Muthumurugesh
> Priority: Major
> Labels: pull-request-available
>
> create table t1(id string) partitioned by (month string);
> insert into t1 select '1','2020-12';
> set hive.cbo.enable=false;
> select id from t1 where (case when month='2023-07' then false else true END);
> -- output: 1
> set hive.cbo.enable=true;
> select id from t1 where (case when month='2023-07' then false else true END);
> -- ouput: \{no result}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
