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)
