Indhumathi Muthumurugesh created HIVE-28704:
-----------------------------------------------

             Summary: Query giving incorrect Results: CASE WHEN expression on 
Partition column and CBO enabled
                 Key: HIVE-28704
                 URL: https://issues.apache.org/jira/browse/HIVE-28704
             Project: Hive
          Issue Type: Bug
            Reporter: Indhumathi Muthumurugesh
            Assignee: Indhumathi Muthumurugesh


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)

Reply via email to