[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2024-04-06 Thread Denys Kuzmenko (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Denys Kuzmenko updated HIVE-26505:
--
Target Version/s: 4.1.0

> 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: 3.1.0, 4.0.0
>Reporter: GuangMing Lu
>Assignee: Krisztian Kasa
>Priority: Critical
>  Labels: check, pull-request-available
>
> {code:java}https://issues.apache.org/jira/browse/HIVE-26505#
> create table test0831 (id string) partitioned by (cp string);
> insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', 
> '2022-08-23');
> 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-23' then 1 
> else 0 end)=0;  
> +--+--+
> | test0830.id  | test0830.cp  |
> +--+--+
> | a        | 2022-08-24   |
> | b        | 2022-08-24   |
> +--+--+
> {code}
>  



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

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2024-04-06 Thread Denys Kuzmenko (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Denys Kuzmenko updated HIVE-26505:
--
Labels: check hive-4.1.0-must pull-request-available  (was: check 
pull-request-available)

> 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: 3.1.0, 4.0.0
>Reporter: GuangMing Lu
>Assignee: Krisztian Kasa
>Priority: Critical
>  Labels: check, hive-4.1.0-must, pull-request-available
>
> {code:java}https://issues.apache.org/jira/browse/HIVE-26505#
> create table test0831 (id string) partitioned by (cp string);
> insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', 
> '2022-08-23');
> 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-23' then 1 
> else 0 end)=0;  
> +--+--+
> | test0830.id  | test0830.cp  |
> +--+--+
> | a        | 2022-08-24   |
> | b        | 2022-08-24   |
> +--+--+
> {code}
>  



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

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2023-12-19 Thread ASF GitHub Bot (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

ASF GitHub Bot updated HIVE-26505:
--
Labels: check pull-request-available  (was: check)

> 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: 3.1.0, 4.0.0
>Reporter: GuangMing Lu
>Assignee: Krisztian Kasa
>Priority: Critical
>  Labels: check, pull-request-available
>
> {code:java}https://issues.apache.org/jira/browse/HIVE-26505#
> create table test0831 (id string) partitioned by (cp string);
> insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', 
> '2022-08-23');
> 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-23' then 1 
> else 0 end)=0;  
> +--+--+
> | test0830.id  | test0830.cp  |
> +--+--+
> | a        | 2022-08-24   |
> | b        | 2022-08-24   |
> +--+--+
> {code}
>  



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

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2023-12-04 Thread Denys Kuzmenko (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Denys Kuzmenko updated HIVE-26505:
--
Labels: check  (was: check hive-4.0.0-must)

> 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: 3.1.0, 4.0.0-alpha-1
>Reporter: GuangMing Lu
>Assignee: Krisztian Kasa
>Priority: Critical
>  Labels: check
>
> {code:java}https://issues.apache.org/jira/browse/HIVE-26505#
> create table test0831 (id string) partitioned by (cp string);
> insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', 
> '2022-08-23');
> 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-23' then 1 
> else 0 end)=0;  
> +--+--+
> | test0830.id  | test0830.cp  |
> +--+--+
> | a        | 2022-08-24   |
> | b        | 2022-08-24   |
> +--+--+
> {code}
>  



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

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2023-12-04 Thread Denys Kuzmenko (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Denys Kuzmenko updated HIVE-26505:
--
Affects Version/s: 4.0.0
   (was: 4.0.0-alpha-1)

> 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: 3.1.0, 4.0.0
>Reporter: GuangMing Lu
>Assignee: Krisztian Kasa
>Priority: Critical
>  Labels: check
>
> {code:java}https://issues.apache.org/jira/browse/HIVE-26505#
> create table test0831 (id string) partitioned by (cp string);
> insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', 
> '2022-08-23');
> 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-23' then 1 
> else 0 end)=0;  
> +--+--+
> | test0830.id  | test0830.cp  |
> +--+--+
> | a        | 2022-08-24   |
> | b        | 2022-08-24   |
> +--+--+
> {code}
>  



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

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2023-08-22 Thread Attila Turoczy (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Attila Turoczy updated HIVE-26505:
--
Labels: check hive-4.0.0-must  (was: check)

> 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: 3.1.0, 4.0.0-alpha-1
>Reporter: GuangMing Lu
>Priority: Critical
>  Labels: check, hive-4.0.0-must
>
> {code:java}https://issues.apache.org/jira/browse/HIVE-26505#
> create table test0831 (id string) partitioned by (cp string);
> insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', 
> '2022-08-23');
> 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-23' then 1 
> else 0 end)=0;  
> +--+--+
> | test0830.id  | test0830.cp  |
> +--+--+
> | a        | 2022-08-24   |
> | b        | 2022-08-24   |
> +--+--+
> {code}
>  



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

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2023-08-22 Thread Attila Turoczy (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Attila Turoczy updated HIVE-26505:
--
Labels: check  (was: )

> 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: 3.1.0, 4.0.0-alpha-1
>Reporter: GuangMing Lu
>Priority: Critical
>  Labels: check
>
> {code:java}https://issues.apache.org/jira/browse/HIVE-26505#
> create table test0831 (id string) partitioned by (cp string);
> insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', 
> '2022-08-23');
> 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-23' then 1 
> else 0 end)=0;  
> +--+--+
> | test0830.id  | test0830.cp  |
> +--+--+
> | a        | 2022-08-24   |
> | b        | 2022-08-24   |
> +--+--+
> {code}
>  



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

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2022-10-18 Thread Zhihua Deng (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Zhihua Deng updated HIVE-26505:
---
Description: 
{code:java}https://issues.apache.org/jira/browse/HIVE-26505#
create table test0831 (id string) partitioned by (cp string);
insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', 
'2022-08-23');
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-23' then 1 else 
0 end)=0;  
+--+--+
| test0830.id  | test0830.cp  |
+--+--+
| a        | 2022-08-24   |
| b        | 2022-08-24   |
+--+--+
{code}
 

  was:
{code:java}
create table test0831 (id string) partitioned by (cp string);
insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', 
'2022-08-23');
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-23' then 1 else 
0 end)=0;  
+--+--+
| test0830.id  | test0830.cp  |
+--+--+
| a        | 2022-08-24   |
| b        | 2022-08-24   |
+--+--+
{code}
 


> 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: 3.1.0, 4.0.0-alpha-1
>Reporter: GuangMing Lu
>Priority: Critical
>
> {code:java}https://issues.apache.org/jira/browse/HIVE-26505#
> create table test0831 (id string) partitioned by (cp string);
> insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', 
> '2022-08-23');
> 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-23' then 1 
> else 0 end)=0;  
> +--+--+
> | test0830.id  | test0830.cp  |
> +--+--+
> | a        | 2022-08-24   |
> | b        | 2022-08-24   |
> +--+--+
> {code}
>  



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

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2022-09-01 Thread GuangMing Lu (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

GuangMing Lu updated HIVE-26505:

Description: 
{code:java}
create table test0831 (id string) partitioned by (cp string);
insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', 
'2022-08-23');
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-23' then 1 else 
0 end)=0;  
+--+--+
| test0830.id  | test0830.cp  |
+--+--+
| a        | 2022-08-24   |
| b        | 2022-08-24   |
+--+--+
{code}
 

  was:
{code:java}
create table test0831 (id string) partitioned by (cp string);
insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', 
'2022-08-23');
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   |
+--+--+{code}
 


> 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: 3.1.0, 4.0.0-alpha-1
>Reporter: GuangMing Lu
>Priority: Critical
>
> {code:java}
> create table test0831 (id string) partitioned by (cp string);
> insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', 
> '2022-08-23');
> 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-23' then 1 
> else 0 end)=0;  
> +--+--+
> | test0830.id  | test0830.cp  |
> +--+--+
> | a        | 2022-08-24   |
> | b        | 2022-08-24   |
> +--+--+
> {code}
>  



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

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2022-08-30 Thread GuangMing Lu (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

GuangMing Lu updated HIVE-26505:

Description: 
{code:java}
create table test0831 (id string) partitioned by (cp string);
insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', 
'2022-08-23');
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   |
+--+--+{code}
 

  was:
{code:java}
create table test0831 (id string) partitioned by (cp string);
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   |
+--+--+{code}
 


> 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: 3.1.0, 4.0.0-alpha-1
>Reporter: GuangMing Lu
>Priority: Critical
>
> {code:java}
> create table test0831 (id string) partitioned by (cp string);
> insert into test0831 values ('a', '2022-08-23'),('c', '2022-08-23'),('d', 
> '2022-08-23');
> 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   |
> +--+--+{code}
>  



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

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2022-08-30 Thread GuangMing Lu (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

GuangMing Lu updated HIVE-26505:

Description: 
{code:java}
create table test0831 (id string) partitioned by (cp string);
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   |
+--+--+{code}
 

  was:
{code:java}
create table test0831 (id string, cp string) stored as orc;
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   |
+--+--+{code}
 


> 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: 3.1.0, 4.0.0-alpha-1
>Reporter: GuangMing Lu
>Priority: Critical
>
> {code:java}
> create table test0831 (id string) partitioned by (cp string);
> 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   |
> +--+--+{code}
>  



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

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2022-08-30 Thread GuangMing Lu (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

GuangMing Lu updated HIVE-26505:

Description: 
{code:java}
create table test0831 (id string, cp string) stored as orc;
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   |
+--+--+{code}
 

  was:
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   |
+--+--+


> 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: 3.1.0, 4.0.0-alpha-1
>Reporter: GuangMing Lu
>Priority: Major
>
> {code:java}
> create table test0831 (id string, cp string) stored as orc;
> 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   |
> +--+--+{code}
>  



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

[jira] [Updated] (HIVE-26505) Case When Some result data is lost when there are common column conditions and partitioned column conditions

2022-08-30 Thread GuangMing Lu (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-26505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

GuangMing Lu updated HIVE-26505:

Priority: Critical  (was: Major)

> 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: 3.1.0, 4.0.0-alpha-1
>Reporter: GuangMing Lu
>Priority: Critical
>
> {code:java}
> create table test0831 (id string, cp string) stored as orc;
> 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   |
> +--+--+{code}
>  



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