[
https://issues.apache.org/jira/browse/HIVE-28705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17921688#comment-17921688
]
Shohei Okumiya edited comment on HIVE-28705 at 1/28/25 11:24 AM:
-----------------------------------------------------------------
I am feeling Calcite should convert `case when month='2023-07' then false else
true END` into a simpler expression such as `month!='2023-07'`. I'm not 100%
confident.
was (Author: okumin):
I am feeling Calcite should convert `case when month='2023-07' then false else
true END` into a simpler expression such as `month='2023-07'`. I'm not 100%
confident.
> 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)
