GuangMing Lu created HIVE-26505:
-----------------------------------

             Summary: Case When Some result data is lost when there are common 
column conditions and partitioned column conditions 
                 Key: HIVE-26505
                 URL: https://issues.apache.org/jira/browse/HIVE-26505
             Project: Hive
          Issue Type: Bug
          Components: Hive
    Affects Versions: 4.0.0-alpha-1, 3.1.0
            Reporter: GuangMing Lu


insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-24'),('d', 
'2022-08-244');
insert into test0831 values ('a', '2022-08-24'),('b', '2022-08-24');

select * from test0831;
+-------------+--------------+
| test0831.id | test0831.cp  |
+-------------+--------------+
| a           | 2022-08-23   |
| b           | 2022-08-23   |
| a           | 2022-08-23   |
| c           | 2022-08-24   |
| d           | 2022-08-24   |
+-------------+--------------+

select * from test0831 where (case when id='a' and cp='2022-08-24' then 1 else 
0 end)=0;

+--------------+--------------+
| test0830.id  | test0830.cp  |
+--------------+--------------+
| a            | 2022-08-23   |
| c            | 2022-08-23   |
| d            | 2022-08-23   |
+--------------+--------------+



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to