[jira] [Resolved] (HIVE-27897) Backport of HIVE-22373, HIVE-25553, HIVE-23561, HIVE-24321, HIVE-22856, HIVE-22973, HIVE-21729, HIVE-23022, HIVE-23034, HIVE-22221, HIVE-23230 to branch-3
[ https://issues.apache.org/jira/browse/HIVE-27897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27897. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-22373, HIVE-25553, HIVE-23561, HIVE-24321, HIVE-22856, > HIVE-22973, HIVE-21729, HIVE-23022, HIVE-23034, HIVE-1, HIVE-23230 to > branch-3 > -- > > Key: HIVE-27897 > URL: https://issues.apache.org/jira/browse/HIVE-27897 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-28097) Backport of HIVE-20082, HIVE-19564, HIVE-20174, HIVE-20197, HIVE-20207, HIVE-20245, HIVE-20294, HIVE-26447, HIVE-20315, HIVE-22170, HIVE-22331, HIVE-24113, HIVE-25458, H
[ https://issues.apache.org/jira/browse/HIVE-28097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-28097. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-20082, HIVE-19564, HIVE-20174, HIVE-20197, HIVE-20207, > HIVE-20245, HIVE-20294, HIVE-26447, HIVE-20315, HIVE-22170, HIVE-22331, > HIVE-24113, HIVE-25458, HIVE-25577, HIVE-25403 > -- > > Key: HIVE-28097 > URL: https://issues.apache.org/jira/browse/HIVE-28097 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-28068) Backport of HIVE-24808, HIVE-24811, HIVE-22476, HIVE-25299, HIVE-22200, HIVE-21544, HIVE-22841, HIVE-20292, HIVE-17040, HIVE-20718, HIVE-20193 to branch-3
[ https://issues.apache.org/jira/browse/HIVE-28068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-28068: Summary: Backport of HIVE-24808, HIVE-24811, HIVE-22476, HIVE-25299, HIVE-22200, HIVE-21544, HIVE-22841, HIVE-20292, HIVE-17040, HIVE-20718, HIVE-20193 to branch-3 (was: Backport of HIVE-24808, HIVE-24811, HIVE-22476, HIVE-25299, HIVE-22200, HIVE-21544, HIVE-22841, HIVE-20292, HIVE-17040, HIVE-20718, HIVE-20193) > Backport of HIVE-24808, HIVE-24811, HIVE-22476, HIVE-25299, HIVE-22200, > HIVE-21544, HIVE-22841, HIVE-20292, HIVE-17040, HIVE-20718, HIVE-20193 to > branch-3 > -- > > Key: HIVE-28068 > URL: https://issues.apache.org/jira/browse/HIVE-28068 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-28068) Backport of HIVE-24808, HIVE-24811, HIVE-22476, HIVE-25299, HIVE-22200, HIVE-21544, HIVE-22841, HIVE-20292, HIVE-17040, HIVE-20718, HIVE-20193
[ https://issues.apache.org/jira/browse/HIVE-28068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-28068. - Fix Version/s: 3.2.0 Target Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-24808, HIVE-24811, HIVE-22476, HIVE-25299, HIVE-22200, > HIVE-21544, HIVE-22841, HIVE-20292, HIVE-17040, HIVE-20718, HIVE-20193 > -- > > Key: HIVE-28068 > URL: https://issues.apache.org/jira/browse/HIVE-28068 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-28049) Backport of HIVE-21862, HIVE-20437, HIVE-22589, HIVE-22840, HIVE-24074, HIVE-25104 to branch-3
[ https://issues.apache.org/jira/browse/HIVE-28049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-28049: Description: Backport of HIVE-21862, HIVE-20437, HIVE-22589, HIVE-22840, HIVE-24074, HIVE-25104 to branch-3 > Backport of HIVE-21862, HIVE-20437, HIVE-22589, HIVE-22840, HIVE-24074, > HIVE-25104 to branch-3 > -- > > Key: HIVE-28049 > URL: https://issues.apache.org/jira/browse/HIVE-28049 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Fix For: 3.2.0 > > > Backport of HIVE-21862, HIVE-20437, HIVE-22589, HIVE-22840, HIVE-24074, > HIVE-25104 to branch-3 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-28049) Backport of HIVE-21862, HIVE-20437, HIVE-22589, HIVE-22840, HIVE-24074, HIVE-25104 to branch-3
[ https://issues.apache.org/jira/browse/HIVE-28049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-28049: Summary: Backport of HIVE-21862, HIVE-20437, HIVE-22589, HIVE-22840, HIVE-24074, HIVE-25104 to branch-3 (was: Backport of HIVE-21862, HIVE-20437, HIVE-22589, HIVE-22840, HIVE-24074, HIVE-25104) > Backport of HIVE-21862, HIVE-20437, HIVE-22589, HIVE-22840, HIVE-24074, > HIVE-25104 to branch-3 > -- > > Key: HIVE-28049 > URL: https://issues.apache.org/jira/browse/HIVE-28049 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-28049) Backport of HIVE-21862, HIVE-20437, HIVE-22589, HIVE-22840, HIVE-24074, HIVE-25104
[ https://issues.apache.org/jira/browse/HIVE-28049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-28049. - Fix Version/s: 3.2.0 Target Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-21862, HIVE-20437, HIVE-22589, HIVE-22840, HIVE-24074, > HIVE-25104 > -- > > Key: HIVE-28049 > URL: https://issues.apache.org/jira/browse/HIVE-28049 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (HIVE-27806) Backport of HIVE-20536, HIVE-20632, HIVE-20511, HIVE-20560, HIVE-20631, HIVE-20637, HIVE-20609, HIVE-20439
[ https://issues.apache.org/jira/browse/HIVE-27806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17806650#comment-17806650 ] Sankar Hariappan commented on HIVE-27806: - Thanks [~amanraj2520] for the contribution! The patch is committed to branch-3. > Backport of HIVE-20536, HIVE-20632, HIVE-20511, HIVE-20560, HIVE-20631, > HIVE-20637, HIVE-20609, HIVE-20439 > -- > > Key: HIVE-27806 > URL: https://issues.apache.org/jira/browse/HIVE-27806 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-20536, HIVE-20632, HIVE-20511, HIVE-20560, HIVE-20631, > HIVE-20637, HIVE-20609, HIVE-20439 into branch-3. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27806) Backport of HIVE-20536, HIVE-20632, HIVE-20511, HIVE-20560, HIVE-20631, HIVE-20637, HIVE-20609, HIVE-20439
[ https://issues.apache.org/jira/browse/HIVE-27806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27806: Affects Version/s: 3.1.3 (was: 3.2.0) > Backport of HIVE-20536, HIVE-20632, HIVE-20511, HIVE-20560, HIVE-20631, > HIVE-20637, HIVE-20609, HIVE-20439 > -- > > Key: HIVE-27806 > URL: https://issues.apache.org/jira/browse/HIVE-27806 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-20536, HIVE-20632, HIVE-20511, HIVE-20560, HIVE-20631, > HIVE-20637, HIVE-20609, HIVE-20439 into branch-3. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27806) Backport of HIVE-20536, HIVE-20632, HIVE-20511, HIVE-20560, HIVE-20631, HIVE-20637, HIVE-20609, HIVE-20439
[ https://issues.apache.org/jira/browse/HIVE-27806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27806. - Fix Version/s: 3.2.0 Target Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-20536, HIVE-20632, HIVE-20511, HIVE-20560, HIVE-20631, > HIVE-20637, HIVE-20609, HIVE-20439 > -- > > Key: HIVE-27806 > URL: https://issues.apache.org/jira/browse/HIVE-27806 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-20536, HIVE-20632, HIVE-20511, HIVE-20560, HIVE-20631, > HIVE-20637, HIVE-20609, HIVE-20439 into branch-3. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27806) Backport of HIVE-20536, HIVE-20632, HIVE-20511, HIVE-20560, HIVE-20631, HIVE-20637, HIVE-20609, HIVE-20439
[ https://issues.apache.org/jira/browse/HIVE-27806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27806: Description: Backport of HIVE-20536, HIVE-20632, HIVE-20511, HIVE-20560, HIVE-20631, HIVE-20637, HIVE-20609, HIVE-20439 into branch-3. > Backport of HIVE-20536, HIVE-20632, HIVE-20511, HIVE-20560, HIVE-20631, > HIVE-20637, HIVE-20609, HIVE-20439 > -- > > Key: HIVE-27806 > URL: https://issues.apache.org/jira/browse/HIVE-27806 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > > Backport of HIVE-20536, HIVE-20632, HIVE-20511, HIVE-20560, HIVE-20631, > HIVE-20637, HIVE-20609, HIVE-20439 into branch-3. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27842) Backport HIVE-21866: LLAP status service driver may get stuck with wrong Yarn app ID
[ https://issues.apache.org/jira/browse/HIVE-27842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27842. - Resolution: Fixed > Backport HIVE-21866: LLAP status service driver may get stuck with wrong Yarn > app ID > > > Key: HIVE-27842 > URL: https://issues.apache.org/jira/browse/HIVE-27842 > Project: Hive > Issue Type: Sub-task >Reporter: Sruthi Mooriyathvariam >Assignee: Sruthi Mooriyathvariam >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > HIVE-21866: LLAP status service driver may get stuck with wrong Yarn app ID > (Adam Szita).This requires backport of HIVE-20807: Refactor > LlapStatusServiceDriver and HIVE-20752: In case of LLAP start failure add > info how to find YARN logs > h1. > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27842) Backport HIVE-21866: LLAP status service driver may get stuck with wrong Yarn app ID
[ https://issues.apache.org/jira/browse/HIVE-27842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27842: Affects Version/s: 3.1.3 > Backport HIVE-21866: LLAP status service driver may get stuck with wrong Yarn > app ID > > > Key: HIVE-27842 > URL: https://issues.apache.org/jira/browse/HIVE-27842 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Sruthi Mooriyathvariam >Assignee: Sruthi Mooriyathvariam >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > HIVE-21866: LLAP status service driver may get stuck with wrong Yarn app ID > (Adam Szita).This requires backport of HIVE-20807: Refactor > LlapStatusServiceDriver and HIVE-20752: In case of LLAP start failure add > info how to find YARN logs > h1. > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27888) Backport of HIVE-22429, HIVE-14898, HIVE-22231, HIVE-20507, HIVE-24786 to branch-3
[ https://issues.apache.org/jira/browse/HIVE-27888?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27888. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-22429, HIVE-14898, HIVE-22231, HIVE-20507, HIVE-24786 to > branch-3 > -- > > Key: HIVE-27888 > URL: https://issues.apache.org/jira/browse/HIVE-27888 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27541) Backport of HIVE-21924, HIVE-22769, HIVE-24224, HIVE-24381,HIVE-21905
[ https://issues.apache.org/jira/browse/HIVE-27541?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27541. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-21924, HIVE-22769, HIVE-24224, HIVE-24381,HIVE-21905 > - > > Key: HIVE-27541 > URL: https://issues.apache.org/jira/browse/HIVE-27541 > Project: Hive > Issue Type: Sub-task > Components: Hive >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27851) Backport of HIVE-24693, HIVE-20433, HIVE-20792, HIVE-20838, HIVE-21241, HIVE-22099, HIVE-25093, HIVE-22400, HIVE-25306, HIVE-25268
[ https://issues.apache.org/jira/browse/HIVE-27851?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27851: Description: Backport of HIVE-24693, HIVE-20433, HIVE-20792, HIVE-20838, HIVE-21241, HIVE-22099, HIVE-25093, HIVE-22400, HIVE-25306, HIVE-25268 to branch-3 > Backport of HIVE-24693, HIVE-20433, HIVE-20792, HIVE-20838, HIVE-21241, > HIVE-22099, HIVE-25093, HIVE-22400, HIVE-25306, HIVE-25268 > -- > > Key: HIVE-27851 > URL: https://issues.apache.org/jira/browse/HIVE-27851 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-24693, HIVE-20433, HIVE-20792, HIVE-20838, HIVE-21241, > HIVE-22099, HIVE-25093, HIVE-22400, HIVE-25306, HIVE-25268 to branch-3 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27851) Backport of HIVE-24693, HIVE-20433, HIVE-20792, HIVE-20838, HIVE-21241, HIVE-22099, HIVE-25093, HIVE-22400, HIVE-25306, HIVE-25268
[ https://issues.apache.org/jira/browse/HIVE-27851?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27851. - Fix Version/s: 3.2.0 Assignee: Aman Raj Resolution: Fixed > Backport of HIVE-24693, HIVE-20433, HIVE-20792, HIVE-20838, HIVE-21241, > HIVE-22099, HIVE-25093, HIVE-22400, HIVE-25306, HIVE-25268 > -- > > Key: HIVE-27851 > URL: https://issues.apache.org/jira/browse/HIVE-27851 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27851) Backport of HIVE-24693, HIVE-20433, HIVE-20792, HIVE-20838, HIVE-21241, HIVE-22099, HIVE-25093, HIVE-22400, HIVE-25306, HIVE-25268to branch-3
[ https://issues.apache.org/jira/browse/HIVE-27851?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27851: Summary: Backport of HIVE-24693, HIVE-20433, HIVE-20792, HIVE-20838, HIVE-21241, HIVE-22099, HIVE-25093, HIVE-22400, HIVE-25306, HIVE-25268to branch-3 (was: Backport of HIVE-24693, HIVE-20433, HIVE-20792, HIVE-20838, HIVE-21241, HIVE-22099, HIVE-25093, HIVE-22400, HIVE-25306, HIVE-25268) > Backport of HIVE-24693, HIVE-20433, HIVE-20792, HIVE-20838, HIVE-21241, > HIVE-22099, HIVE-25093, HIVE-22400, HIVE-25306, HIVE-25268to branch-3 > - > > Key: HIVE-27851 > URL: https://issues.apache.org/jira/browse/HIVE-27851 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-24693, HIVE-20433, HIVE-20792, HIVE-20838, HIVE-21241, > HIVE-22099, HIVE-25093, HIVE-22400, HIVE-25306, HIVE-25268 to branch-3 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (HIVE-27324) Hive query with NOT IN condition is giving incorrect results when the sub query table contains the null value.
[
https://issues.apache.org/jira/browse/HIVE-27324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17782632#comment-17782632
]
Sankar Hariappan commented on HIVE-27324:
-
[~diksha193]: Pls backport this fix to branch-3 as well.
> Hive query with NOT IN condition is giving incorrect results when the sub
> query table contains the null value.
> --
>
> Key: HIVE-27324
> URL: https://issues.apache.org/jira/browse/HIVE-27324
> Project: Hive
> Issue Type: Bug
> Components: Hive
>Affects Versions: 3.1.3
>Reporter: Shobika Selvaraj
>Assignee: Diksha
>Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0
>
> Attachments: sql_queries.png
>
>
> Hive query giving empty results when the sub query table contains the null
> value.
> We encountered two issues here.
> 1) The query - "select * from t3 where age not in (select distinct(age) age
> from t1);" is giving empty results when the table t1 contains a null value.
> Disabling cbo didn't helped here.
> 2) Let's consider the table t3 has null value and table t1 doesn't have any
> null values. Now if we run the above query it is returning other data's but
> not the null value from t3. If we disable the cbo then it's giving result
> with null value.
>
> *REPRO STEPS WITH DETAILED EXPLANATION AS BELOW:*
> *FIRST ISSUE:*
> Create two tables and insert data with null values as below:
> ---
> create table t3 (id int,name string, age int);
>
> insert into t3
> values(1,'Sagar',23),(2,'Sultan',NULL),(3,'Surya',23),(4,'Raman',45),(5,'Scott',23),(6,'Ramya',5),(7,'',23),(8,'',23),(9,'ron',3),(10,'Sam',22),(11,'nick',19),(12,'fed',18),(13,'kong',13),(14,'hela',45);
>
> create table t1 (id int,name string, age int);
> insert into t1
> values(1,'Sagar',23),(2,'Sultan',NULL),(3,'Surya',23),(4,'Raman',45),(5,'Scott',23),(6,'Ramya',5),(7,'',23),(8,'',23);
> ---
>
> Then executed the below query:
> --
> select * from t3
> where age not in (select distinct(age) age from t1);
> --
>
> The result should be as below:
> {code:java}
> ++--+-+
> | t3.id | t3.name | t3.age |
> ++--+-+
> | 9 | ron | 3 |
> | 10 | Sam | 22 |
> | 11 | nick | 19 |
> | 12 | fed | 18 |
> | 13 | kong | 13 |
> ++--+-+
> 5 rows selected (35.897 seconds) {code}
> But when we run the above query it is giving zero records:
> {code:java}
> 0: jdbc:hive2://zk0-shobia.lhlexkfu3vfebcezzj> select * from t3
> . . . . . . . . . . . . . . . . . . . . . . .> where age not in (select
> distinct(age) age from t1);
> INFO : Compiling
> command(queryId=hive_20230427164202_e25b671a-f3bd-41e4-b364-844466305d96):
> select * from t3
> where age not in (select distinct(age) age from t1)
> INFO : Warning: Map Join MAPJOIN[37][bigTable=?] in task 'Map 1' is a cross
> product
> ..
> .
> INFO : Completed executing
> command(queryId=hive_20230427164202_e25b671a-f3bd-41e4-b364-844466305d96);
> Time taken: 10.191 seconds
> INFO : OK
> ++--+-+
> | t3.id | t3.name | t3.age |
> ++--+-+
> ++--+-+
> No rows selected (12.17 seconds) {code}
> The query works fine when we use nvl function or not null condition.
>
> So as a workaround we can use nvl function for both main and sub query as
> below:
> {code:java}
> select * from t3 where nvl(age,'-') not in (select distinct(nvl(age,'-')) age
> from t1); {code}
>
> *SECOND ISSUE:*
> Also while testing multiple scenario's i found one more issue as well.
> When the sub query table (t1) doesn't contain any null values then the query
> is giving result but it is ignoring the null values of the main table(t3) .
>
> For example: Created another table t4 and inserted the data's without any
> null values:
> create table t4 (id int,name string, age int);
> insert into t4
> values(1,'Sagar',23),(3,'Surya',23),(4,'Raman',45),(5,'Scott',23),(6,'Ramya',5),(7,'',23),(8,'',23);
> Now i tested with the below query and it gives 5 records. The count should be
> six and it omitted the null value of the table t3:
> {code:java}
> 0: jdbc:hive2://zk0-shobia.lhlexkfu3vfebcezzj> select * from t3
> . . . . . . . . . . . . . . . . . . . . . . .> where age not in (select
> distinct(age) age from t4);
> INFO : Compiling
> command(queryId=hive_20230427164745_f20f47ce-614d-493d-8910-99a118de089c):
> select * from t3
> where age not in (select distinct(age) age from t4)
> INFO : Warning: Map Join MAPJOIN[37][bigTable=?] in task 'Map 1' is a cross
> product
> ..
> ..
> INFO : Completed executing
>
[jira] [Updated] (HIVE-27324) Hive query with NOT IN condition is giving incorrect results when the sub query table contains the null value.
[
https://issues.apache.org/jira/browse/HIVE-27324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sankar Hariappan updated HIVE-27324:
Fix Version/s: 4.0.0
> Hive query with NOT IN condition is giving incorrect results when the sub
> query table contains the null value.
> --
>
> Key: HIVE-27324
> URL: https://issues.apache.org/jira/browse/HIVE-27324
> Project: Hive
> Issue Type: Bug
> Components: Hive
>Affects Versions: 3.1.3
>Reporter: Shobika Selvaraj
>Assignee: Diksha
>Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0
>
> Attachments: sql_queries.png
>
>
> Hive query giving empty results when the sub query table contains the null
> value.
> We encountered two issues here.
> 1) The query - "select * from t3 where age not in (select distinct(age) age
> from t1);" is giving empty results when the table t1 contains a null value.
> Disabling cbo didn't helped here.
> 2) Let's consider the table t3 has null value and table t1 doesn't have any
> null values. Now if we run the above query it is returning other data's but
> not the null value from t3. If we disable the cbo then it's giving result
> with null value.
>
> *REPRO STEPS WITH DETAILED EXPLANATION AS BELOW:*
> *FIRST ISSUE:*
> Create two tables and insert data with null values as below:
> ---
> create table t3 (id int,name string, age int);
>
> insert into t3
> values(1,'Sagar',23),(2,'Sultan',NULL),(3,'Surya',23),(4,'Raman',45),(5,'Scott',23),(6,'Ramya',5),(7,'',23),(8,'',23),(9,'ron',3),(10,'Sam',22),(11,'nick',19),(12,'fed',18),(13,'kong',13),(14,'hela',45);
>
> create table t1 (id int,name string, age int);
> insert into t1
> values(1,'Sagar',23),(2,'Sultan',NULL),(3,'Surya',23),(4,'Raman',45),(5,'Scott',23),(6,'Ramya',5),(7,'',23),(8,'',23);
> ---
>
> Then executed the below query:
> --
> select * from t3
> where age not in (select distinct(age) age from t1);
> --
>
> The result should be as below:
> {code:java}
> ++--+-+
> | t3.id | t3.name | t3.age |
> ++--+-+
> | 9 | ron | 3 |
> | 10 | Sam | 22 |
> | 11 | nick | 19 |
> | 12 | fed | 18 |
> | 13 | kong | 13 |
> ++--+-+
> 5 rows selected (35.897 seconds) {code}
> But when we run the above query it is giving zero records:
> {code:java}
> 0: jdbc:hive2://zk0-shobia.lhlexkfu3vfebcezzj> select * from t3
> . . . . . . . . . . . . . . . . . . . . . . .> where age not in (select
> distinct(age) age from t1);
> INFO : Compiling
> command(queryId=hive_20230427164202_e25b671a-f3bd-41e4-b364-844466305d96):
> select * from t3
> where age not in (select distinct(age) age from t1)
> INFO : Warning: Map Join MAPJOIN[37][bigTable=?] in task 'Map 1' is a cross
> product
> ..
> .
> INFO : Completed executing
> command(queryId=hive_20230427164202_e25b671a-f3bd-41e4-b364-844466305d96);
> Time taken: 10.191 seconds
> INFO : OK
> ++--+-+
> | t3.id | t3.name | t3.age |
> ++--+-+
> ++--+-+
> No rows selected (12.17 seconds) {code}
> The query works fine when we use nvl function or not null condition.
>
> So as a workaround we can use nvl function for both main and sub query as
> below:
> {code:java}
> select * from t3 where nvl(age,'-') not in (select distinct(nvl(age,'-')) age
> from t1); {code}
>
> *SECOND ISSUE:*
> Also while testing multiple scenario's i found one more issue as well.
> When the sub query table (t1) doesn't contain any null values then the query
> is giving result but it is ignoring the null values of the main table(t3) .
>
> For example: Created another table t4 and inserted the data's without any
> null values:
> create table t4 (id int,name string, age int);
> insert into t4
> values(1,'Sagar',23),(3,'Surya',23),(4,'Raman',45),(5,'Scott',23),(6,'Ramya',5),(7,'',23),(8,'',23);
> Now i tested with the below query and it gives 5 records. The count should be
> six and it omitted the null value of the table t3:
> {code:java}
> 0: jdbc:hive2://zk0-shobia.lhlexkfu3vfebcezzj> select * from t3
> . . . . . . . . . . . . . . . . . . . . . . .> where age not in (select
> distinct(age) age from t4);
> INFO : Compiling
> command(queryId=hive_20230427164745_f20f47ce-614d-493d-8910-99a118de089c):
> select * from t3
> where age not in (select distinct(age) age from t4)
> INFO : Warning: Map Join MAPJOIN[37][bigTable=?] in task 'Map 1' is a cross
> product
> ..
> ..
> INFO : Completed executing
> command(queryId=hive_20230427164745_f20f47ce-614d-493d-8910-99a118de089c);
> Time taken:
[jira] [Resolved] (HIVE-27324) Hive query with NOT IN condition is giving incorrect results when the sub query table contains the null value.
[
https://issues.apache.org/jira/browse/HIVE-27324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sankar Hariappan resolved HIVE-27324.
-
Resolution: Fixed
PR merged to master.
Thanks [~diksha193] for the patch and [~mahesh] for the review!
> Hive query with NOT IN condition is giving incorrect results when the sub
> query table contains the null value.
> --
>
> Key: HIVE-27324
> URL: https://issues.apache.org/jira/browse/HIVE-27324
> Project: Hive
> Issue Type: Bug
> Components: Hive
>Affects Versions: 3.1.3
>Reporter: Shobika Selvaraj
>Assignee: Diksha
>Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0
>
> Attachments: sql_queries.png
>
>
> Hive query giving empty results when the sub query table contains the null
> value.
> We encountered two issues here.
> 1) The query - "select * from t3 where age not in (select distinct(age) age
> from t1);" is giving empty results when the table t1 contains a null value.
> Disabling cbo didn't helped here.
> 2) Let's consider the table t3 has null value and table t1 doesn't have any
> null values. Now if we run the above query it is returning other data's but
> not the null value from t3. If we disable the cbo then it's giving result
> with null value.
>
> *REPRO STEPS WITH DETAILED EXPLANATION AS BELOW:*
> *FIRST ISSUE:*
> Create two tables and insert data with null values as below:
> ---
> create table t3 (id int,name string, age int);
>
> insert into t3
> values(1,'Sagar',23),(2,'Sultan',NULL),(3,'Surya',23),(4,'Raman',45),(5,'Scott',23),(6,'Ramya',5),(7,'',23),(8,'',23),(9,'ron',3),(10,'Sam',22),(11,'nick',19),(12,'fed',18),(13,'kong',13),(14,'hela',45);
>
> create table t1 (id int,name string, age int);
> insert into t1
> values(1,'Sagar',23),(2,'Sultan',NULL),(3,'Surya',23),(4,'Raman',45),(5,'Scott',23),(6,'Ramya',5),(7,'',23),(8,'',23);
> ---
>
> Then executed the below query:
> --
> select * from t3
> where age not in (select distinct(age) age from t1);
> --
>
> The result should be as below:
> {code:java}
> ++--+-+
> | t3.id | t3.name | t3.age |
> ++--+-+
> | 9 | ron | 3 |
> | 10 | Sam | 22 |
> | 11 | nick | 19 |
> | 12 | fed | 18 |
> | 13 | kong | 13 |
> ++--+-+
> 5 rows selected (35.897 seconds) {code}
> But when we run the above query it is giving zero records:
> {code:java}
> 0: jdbc:hive2://zk0-shobia.lhlexkfu3vfebcezzj> select * from t3
> . . . . . . . . . . . . . . . . . . . . . . .> where age not in (select
> distinct(age) age from t1);
> INFO : Compiling
> command(queryId=hive_20230427164202_e25b671a-f3bd-41e4-b364-844466305d96):
> select * from t3
> where age not in (select distinct(age) age from t1)
> INFO : Warning: Map Join MAPJOIN[37][bigTable=?] in task 'Map 1' is a cross
> product
> ..
> .
> INFO : Completed executing
> command(queryId=hive_20230427164202_e25b671a-f3bd-41e4-b364-844466305d96);
> Time taken: 10.191 seconds
> INFO : OK
> ++--+-+
> | t3.id | t3.name | t3.age |
> ++--+-+
> ++--+-+
> No rows selected (12.17 seconds) {code}
> The query works fine when we use nvl function or not null condition.
>
> So as a workaround we can use nvl function for both main and sub query as
> below:
> {code:java}
> select * from t3 where nvl(age,'-') not in (select distinct(nvl(age,'-')) age
> from t1); {code}
>
> *SECOND ISSUE:*
> Also while testing multiple scenario's i found one more issue as well.
> When the sub query table (t1) doesn't contain any null values then the query
> is giving result but it is ignoring the null values of the main table(t3) .
>
> For example: Created another table t4 and inserted the data's without any
> null values:
> create table t4 (id int,name string, age int);
> insert into t4
> values(1,'Sagar',23),(3,'Surya',23),(4,'Raman',45),(5,'Scott',23),(6,'Ramya',5),(7,'',23),(8,'',23);
> Now i tested with the below query and it gives 5 records. The count should be
> six and it omitted the null value of the table t3:
> {code:java}
> 0: jdbc:hive2://zk0-shobia.lhlexkfu3vfebcezzj> select * from t3
> . . . . . . . . . . . . . . . . . . . . . . .> where age not in (select
> distinct(age) age from t4);
> INFO : Compiling
> command(queryId=hive_20230427164745_f20f47ce-614d-493d-8910-99a118de089c):
> select * from t3
> where age not in (select distinct(age) age from t4)
> INFO : Warning: Map Join MAPJOIN[37][bigTable=?] in task 'Map 1' is a cross
> product
> ..
> ..
> INFO : Completed executing
>
[jira] [Updated] (HIVE-27324) Hive query with NOT IN condition is giving incorrect results when the sub query table contains the null value.
[
https://issues.apache.org/jira/browse/HIVE-27324?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sankar Hariappan updated HIVE-27324:
Affects Version/s: 3.1.3
(was: 3.1.0)
(was: All Versions)
> Hive query with NOT IN condition is giving incorrect results when the sub
> query table contains the null value.
> --
>
> Key: HIVE-27324
> URL: https://issues.apache.org/jira/browse/HIVE-27324
> Project: Hive
> Issue Type: Bug
> Components: Hive
>Affects Versions: 3.1.3
>Reporter: Shobika Selvaraj
>Assignee: Diksha
>Priority: Major
> Labels: pull-request-available
> Attachments: sql_queries.png
>
>
> Hive query giving empty results when the sub query table contains the null
> value.
> We encountered two issues here.
> 1) The query - "select * from t3 where age not in (select distinct(age) age
> from t1);" is giving empty results when the table t1 contains a null value.
> Disabling cbo didn't helped here.
> 2) Let's consider the table t3 has null value and table t1 doesn't have any
> null values. Now if we run the above query it is returning other data's but
> not the null value from t3. If we disable the cbo then it's giving result
> with null value.
>
> *REPRO STEPS WITH DETAILED EXPLANATION AS BELOW:*
> *FIRST ISSUE:*
> Create two tables and insert data with null values as below:
> ---
> create table t3 (id int,name string, age int);
>
> insert into t3
> values(1,'Sagar',23),(2,'Sultan',NULL),(3,'Surya',23),(4,'Raman',45),(5,'Scott',23),(6,'Ramya',5),(7,'',23),(8,'',23),(9,'ron',3),(10,'Sam',22),(11,'nick',19),(12,'fed',18),(13,'kong',13),(14,'hela',45);
>
> create table t1 (id int,name string, age int);
> insert into t1
> values(1,'Sagar',23),(2,'Sultan',NULL),(3,'Surya',23),(4,'Raman',45),(5,'Scott',23),(6,'Ramya',5),(7,'',23),(8,'',23);
> ---
>
> Then executed the below query:
> --
> select * from t3
> where age not in (select distinct(age) age from t1);
> --
>
> The result should be as below:
> {code:java}
> ++--+-+
> | t3.id | t3.name | t3.age |
> ++--+-+
> | 9 | ron | 3 |
> | 10 | Sam | 22 |
> | 11 | nick | 19 |
> | 12 | fed | 18 |
> | 13 | kong | 13 |
> ++--+-+
> 5 rows selected (35.897 seconds) {code}
> But when we run the above query it is giving zero records:
> {code:java}
> 0: jdbc:hive2://zk0-shobia.lhlexkfu3vfebcezzj> select * from t3
> . . . . . . . . . . . . . . . . . . . . . . .> where age not in (select
> distinct(age) age from t1);
> INFO : Compiling
> command(queryId=hive_20230427164202_e25b671a-f3bd-41e4-b364-844466305d96):
> select * from t3
> where age not in (select distinct(age) age from t1)
> INFO : Warning: Map Join MAPJOIN[37][bigTable=?] in task 'Map 1' is a cross
> product
> ..
> .
> INFO : Completed executing
> command(queryId=hive_20230427164202_e25b671a-f3bd-41e4-b364-844466305d96);
> Time taken: 10.191 seconds
> INFO : OK
> ++--+-+
> | t3.id | t3.name | t3.age |
> ++--+-+
> ++--+-+
> No rows selected (12.17 seconds) {code}
> The query works fine when we use nvl function or not null condition.
>
> So as a workaround we can use nvl function for both main and sub query as
> below:
> {code:java}
> select * from t3 where nvl(age,'-') not in (select distinct(nvl(age,'-')) age
> from t1); {code}
>
> *SECOND ISSUE:*
> Also while testing multiple scenario's i found one more issue as well.
> When the sub query table (t1) doesn't contain any null values then the query
> is giving result but it is ignoring the null values of the main table(t3) .
>
> For example: Created another table t4 and inserted the data's without any
> null values:
> create table t4 (id int,name string, age int);
> insert into t4
> values(1,'Sagar',23),(3,'Surya',23),(4,'Raman',45),(5,'Scott',23),(6,'Ramya',5),(7,'',23),(8,'',23);
> Now i tested with the below query and it gives 5 records. The count should be
> six and it omitted the null value of the table t3:
> {code:java}
> 0: jdbc:hive2://zk0-shobia.lhlexkfu3vfebcezzj> select * from t3
> . . . . . . . . . . . . . . . . . . . . . . .> where age not in (select
> distinct(age) age from t4);
> INFO : Compiling
> command(queryId=hive_20230427164745_f20f47ce-614d-493d-8910-99a118de089c):
> select * from t3
> where age not in (select distinct(age) age from t4)
> INFO : Warning: Map Join MAPJOIN[37][bigTable=?] in task 'Map 1' is a cross
> product
> ..
> ..
> INFO : Completed executing
>
[jira] [Commented] (HIVE-27708) Backport of HIVE-25299 : HIVE-21104: PTF with nested structure throws ClassCastException
[ https://issues.apache.org/jira/browse/HIVE-27708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17781223#comment-17781223 ] Sankar Hariappan commented on HIVE-27708: - Merged the PR to branch-3. Thanks [~kamalsharma] for the contribution! > Backport of HIVE-25299 : HIVE-21104: PTF with nested structure throws > ClassCastException > > > Key: HIVE-27708 > URL: https://issues.apache.org/jira/browse/HIVE-27708 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Kamal Sharma >Assignee: Kamal Sharma >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27708) Backport of HIVE-25299 : HIVE-21104: PTF with nested structure throws ClassCastException
[ https://issues.apache.org/jira/browse/HIVE-27708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27708: Affects Version/s: 3.1.3 > Backport of HIVE-25299 : HIVE-21104: PTF with nested structure throws > ClassCastException > > > Key: HIVE-27708 > URL: https://issues.apache.org/jira/browse/HIVE-27708 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Kamal Sharma >Assignee: Kamal Sharma >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27708) Backport of HIVE-25299 : HIVE-21104: PTF with nested structure throws ClassCastException
[ https://issues.apache.org/jira/browse/HIVE-27708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27708. - Resolution: Fixed > Backport of HIVE-25299 : HIVE-21104: PTF with nested structure throws > ClassCastException > > > Key: HIVE-27708 > URL: https://issues.apache.org/jira/browse/HIVE-27708 > Project: Hive > Issue Type: Sub-task >Reporter: Kamal Sharma >Assignee: Kamal Sharma >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27807) Backport of HIVE-20629, HIVE-20705, HIVE-20734
[ https://issues.apache.org/jira/browse/HIVE-27807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27807: Affects Version/s: 3.1.3 (was: 3.2.0) > Backport of HIVE-20629, HIVE-20705, HIVE-20734 > -- > > Key: HIVE-27807 > URL: https://issues.apache.org/jira/browse/HIVE-27807 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backports - HIVE-20629, HIVE-20705, HIVE-20734 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27807) Backport of HIVE-20629, HIVE-20705, HIVE-20734
[ https://issues.apache.org/jira/browse/HIVE-27807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27807. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-20629, HIVE-20705, HIVE-20734 > -- > > Key: HIVE-27807 > URL: https://issues.apache.org/jira/browse/HIVE-27807 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backports - HIVE-20629, HIVE-20705, HIVE-20734 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27807) Backport of HIVE-20629, HIVE-20705, HIVE-20734
[ https://issues.apache.org/jira/browse/HIVE-27807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27807: Description: Backports - HIVE-20629, HIVE-20705, HIVE-20734 > Backport of HIVE-20629, HIVE-20705, HIVE-20734 > -- > > Key: HIVE-27807 > URL: https://issues.apache.org/jira/browse/HIVE-27807 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > > Backports - HIVE-20629, HIVE-20705, HIVE-20734 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27785) Backport of HIVE-20467, HIVE-20508, HIVE-20550
[ https://issues.apache.org/jira/browse/HIVE-27785?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27785: Affects Version/s: 3.1.3 (was: 3.2.0) > Backport of HIVE-20467, HIVE-20508, HIVE-20550 > -- > > Key: HIVE-27785 > URL: https://issues.apache.org/jira/browse/HIVE-27785 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-20467, HIVE-20508, HIVE-20550 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27785) Backport of HIVE-20467, HIVE-20508, HIVE-20550
[ https://issues.apache.org/jira/browse/HIVE-27785?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27785. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-20467, HIVE-20508, HIVE-20550 > -- > > Key: HIVE-27785 > URL: https://issues.apache.org/jira/browse/HIVE-27785 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-20467, HIVE-20508, HIVE-20550 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27785) Backport of HIVE-20467, HIVE-20508, HIVE-20550
[ https://issues.apache.org/jira/browse/HIVE-27785?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27785: Description: Backport of HIVE-20467, HIVE-20508, HIVE-20550 > Backport of HIVE-20467, HIVE-20508, HIVE-20550 > -- > > Key: HIVE-27785 > URL: https://issues.apache.org/jira/browse/HIVE-27785 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > > Backport of HIVE-20467, HIVE-20508, HIVE-20550 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27604) HIVE-21167 : Bucketing: Bucketing version 1 is incorrectly partitioning data
[ https://issues.apache.org/jira/browse/HIVE-27604?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27604: Affects Version/s: 3.1.3 > HIVE-21167 : Bucketing: Bucketing version 1 is incorrectly partitioning data > > > Key: HIVE-27604 > URL: https://issues.apache.org/jira/browse/HIVE-27604 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-21167 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27604) HIVE-21167 : Bucketing: Bucketing version 1 is incorrectly partitioning data
[ https://issues.apache.org/jira/browse/HIVE-27604?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27604. - Fix Version/s: 3.2.0 Resolution: Fixed > HIVE-21167 : Bucketing: Bucketing version 1 is incorrectly partitioning data > > > Key: HIVE-27604 > URL: https://issues.apache.org/jira/browse/HIVE-27604 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-21167 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27604) HIVE-21167 : Bucketing: Bucketing version 1 is incorrectly partitioning data
[ https://issues.apache.org/jira/browse/HIVE-27604?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27604: Description: Backport of HIVE-21167 > HIVE-21167 : Bucketing: Bucketing version 1 is incorrectly partitioning data > > > Key: HIVE-27604 > URL: https://issues.apache.org/jira/browse/HIVE-27604 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > > Backport of HIVE-21167 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27784) Backport of HIVE-20364, HIVE-20549 to branch-3
[ https://issues.apache.org/jira/browse/HIVE-27784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27784: Affects Version/s: 3.1.3 (was: 3.2.0) > Backport of HIVE-20364, HIVE-20549 to branch-3 > -- > > Key: HIVE-27784 > URL: https://issues.apache.org/jira/browse/HIVE-27784 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27784) Backport of HIVE-20364, HIVE-20549 to branch-3
[ https://issues.apache.org/jira/browse/HIVE-27784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27784. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-20364, HIVE-20549 to branch-3 > -- > > Key: HIVE-27784 > URL: https://issues.apache.org/jira/browse/HIVE-27784 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27795) Fix explainanalyze_2.q test
[ https://issues.apache.org/jira/browse/HIVE-27795?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27795: Labels: release-3.2.0-blocker (was: ) > Fix explainanalyze_2.q test > --- > > Key: HIVE-27795 > URL: https://issues.apache.org/jira/browse/HIVE-27795 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: release-3.2.0-blocker > Fix For: 3.2.0 > > > Test failing with the following diff : > > Client Execution succeeded but contained differences (error code = 1) after > executing explainanalyze_2.q > 2043c2043 > < default@srcpart,c_n3,Tbl:COMPLETE,Col:PARTIAL,Output:["key"] > --- > > default@srcpart,c_n3,Tbl:COMPLETE,Col:COMPLETE,Output:["key"] -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27765) Backport of HIVE-20052, HIVE-20093, HIVE-20203, HIVE-20290, HIVE-20300, HIVE-20312, HIVE-20044, HIVE-21966
[ https://issues.apache.org/jira/browse/HIVE-27765?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27765: Description: * HIVE-20052: Arrow serde should fill ArrowColumnVector(Decimal) with the given schema precision/scale * HIVE-20093: LlapOutputFomatService: Use ArrowBuf with Netty for Accounting * HIVE-20203: Arrow SerDe leaks a DirectByteBuffer * HIVE-20290: Lazy initialize ArrowColumnarBatchSerDe so it doesn't allocate buffers during GetSplits * HIVE-20300: VectorFileSinkArrowOperator * HIVE-20312: Allow arrow clients to use their own BufferAllocator with LlapOutputFormatService * HIVE-20044: Arrow Serde should pad char values and handle empty strings correctly * HIVE-21966: Llap external client - Arrow Serializer throws ArrayIndexOutOfBoundsException in some cases > Backport of HIVE-20052, HIVE-20093, HIVE-20203, HIVE-20290, HIVE-20300, > HIVE-20312, HIVE-20044, HIVE-21966 > -- > > Key: HIVE-27765 > URL: https://issues.apache.org/jira/browse/HIVE-27765 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > * HIVE-20052: Arrow serde should fill ArrowColumnVector(Decimal) with the > given schema precision/scale > * HIVE-20093: LlapOutputFomatService: Use ArrowBuf with Netty for > Accounting > * HIVE-20203: Arrow SerDe leaks a DirectByteBuffer > * HIVE-20290: Lazy initialize ArrowColumnarBatchSerDe so it doesn't > allocate buffers during GetSplits > * HIVE-20300: VectorFileSinkArrowOperator > * HIVE-20312: Allow arrow clients to use their own BufferAllocator with > LlapOutputFormatService > * HIVE-20044: Arrow Serde should pad char values and handle empty strings > correctly > * HIVE-21966: Llap external client - Arrow Serializer throws > ArrayIndexOutOfBoundsException in some cases -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27765) Backport of HIVE-20052, HIVE-20093, HIVE-20203, HIVE-20290, HIVE-20300, HIVE-20312, HIVE-20044, HIVE-21966
[ https://issues.apache.org/jira/browse/HIVE-27765?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27765. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-20052, HIVE-20093, HIVE-20203, HIVE-20290, HIVE-20300, > HIVE-20312, HIVE-20044, HIVE-21966 > -- > > Key: HIVE-27765 > URL: https://issues.apache.org/jira/browse/HIVE-27765 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27765) Backport of HIVE-20052, HIVE-20093, HIVE-20203, HIVE-20290, HIVE-20300, HIVE-20312, HIVE-20044, HIVE-21966
[ https://issues.apache.org/jira/browse/HIVE-27765?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27765: Affects Version/s: 3.1.3 (was: 3.2.0) > Backport of HIVE-20052, HIVE-20093, HIVE-20203, HIVE-20290, HIVE-20300, > HIVE-20312, HIVE-20044, HIVE-21966 > -- > > Key: HIVE-27765 > URL: https://issues.apache.org/jira/browse/HIVE-27765 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27765) Backport of HIVE-20052: Arrow serde should fill ArrowColumnVector(Decimal) with the given schema precision/scale
[ https://issues.apache.org/jira/browse/HIVE-27765?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27765: Summary: Backport of HIVE-20052: Arrow serde should fill ArrowColumnVector(Decimal) with the given schema precision/scale (was: Backport of HIVE-20062: Arrow serde should fill ArrowColumnVector(Decimal) with the given schema precision/scale) > Backport of HIVE-20052: Arrow serde should fill ArrowColumnVector(Decimal) > with the given schema precision/scale > > > Key: HIVE-27765 > URL: https://issues.apache.org/jira/browse/HIVE-27765 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (HIVE-27573) Backport of HIVE-21799: NullPointerException in DynamicPartitionPruningOptimization, when join key is on aggregation column
[ https://issues.apache.org/jira/browse/HIVE-27573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17770015#comment-17770015 ] Sankar Hariappan commented on HIVE-27573: - Thanks [~shefali636] for the contribution! > Backport of HIVE-21799: NullPointerException in > DynamicPartitionPruningOptimization, when join key is on aggregation column > --- > > Key: HIVE-27573 > URL: https://issues.apache.org/jira/browse/HIVE-27573 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Shefali Singh >Assignee: Shefali Singh >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27573) Backport of HIVE-21799: NullPointerException in DynamicPartitionPruningOptimization, when join key is on aggregation column
[ https://issues.apache.org/jira/browse/HIVE-27573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27573. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-21799: NullPointerException in > DynamicPartitionPruningOptimization, when join key is on aggregation column > --- > > Key: HIVE-27573 > URL: https://issues.apache.org/jira/browse/HIVE-27573 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Shefali Singh >Assignee: Shefali Singh >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27573) Backport of HIVE-21799: NullPointerException in DynamicPartitionPruningOptimization, when join key is on aggregation column
[ https://issues.apache.org/jira/browse/HIVE-27573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27573: Affects Version/s: 3.1.3 (was: 3.2.0) > Backport of HIVE-21799: NullPointerException in > DynamicPartitionPruningOptimization, when join key is on aggregation column > --- > > Key: HIVE-27573 > URL: https://issues.apache.org/jira/browse/HIVE-27573 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Shefali Singh >Assignee: Shefali Singh >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27722) Added org.bouncycastle as dependency and excluded the dependencies of the same which lead to version mismatch while running tests
[ https://issues.apache.org/jira/browse/HIVE-27722?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27722. - Fix Version/s: 3.2.0 Resolution: Fixed > Added org.bouncycastle as dependency and excluded the dependencies of the > same which lead to version mismatch while running tests > - > > Key: HIVE-27722 > URL: https://issues.apache.org/jira/browse/HIVE-27722 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27377) Backport of HIVE-24803: WorkloadManager doesn't update allocation and metrics after Kill Trigger action
[ https://issues.apache.org/jira/browse/HIVE-27377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27377. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-24803: WorkloadManager doesn't update allocation and metrics > after Kill Trigger action > --- > > Key: HIVE-27377 > URL: https://issues.apache.org/jira/browse/HIVE-27377 > Project: Hive > Issue Type: Sub-task >Reporter: Diksha >Assignee: Diksha >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-24803: WorkloadManager doesn't update allocation and metrics > after Kill Trigger action -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27377) Backport of HIVE-24803: WorkloadManager doesn't update allocation and metrics after Kill Trigger action
[ https://issues.apache.org/jira/browse/HIVE-27377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27377: Affects Version/s: 3.1.3 > Backport of HIVE-24803: WorkloadManager doesn't update allocation and metrics > after Kill Trigger action > --- > > Key: HIVE-27377 > URL: https://issues.apache.org/jira/browse/HIVE-27377 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Diksha >Assignee: Diksha >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-24803: WorkloadManager doesn't update allocation and metrics > after Kill Trigger action -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27721) Backport of HIVE-23396: Many fixes and improvements to stabilize tests
[ https://issues.apache.org/jira/browse/HIVE-27721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27721. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-23396: Many fixes and improvements to stabilize tests > -- > > Key: HIVE-27721 > URL: https://issues.apache.org/jira/browse/HIVE-27721 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27721) Backport of HIVE-23396: Many fixes and improvements to stabilize tests
[ https://issues.apache.org/jira/browse/HIVE-27721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27721: Affects Version/s: 3.1.3 (was: 3.2.0) > Backport of HIVE-23396: Many fixes and improvements to stabilize tests > -- > > Key: HIVE-27721 > URL: https://issues.apache.org/jira/browse/HIVE-27721 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27715) Backport of HIVE-25235: Remove ThreadPoolExecutorWithOomHook
[ https://issues.apache.org/jira/browse/HIVE-27715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27715. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-25235: Remove ThreadPoolExecutorWithOomHook > > > Key: HIVE-27715 > URL: https://issues.apache.org/jira/browse/HIVE-27715 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27715) Backport of HIVE-25235: Remove ThreadPoolExecutorWithOomHook
[ https://issues.apache.org/jira/browse/HIVE-27715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27715: Affects Version/s: 3.1.3 (was: 3.2.0) > Backport of HIVE-25235: Remove ThreadPoolExecutorWithOomHook > > > Key: HIVE-27715 > URL: https://issues.apache.org/jira/browse/HIVE-27715 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Assigned] (HIVE-27715) Backport of HIVE-25235: Remove ThreadPoolExecutorWithOomHook
[ https://issues.apache.org/jira/browse/HIVE-27715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan reassigned HIVE-27715: --- Assignee: Aman Raj > Backport of HIVE-25235: Remove ThreadPoolExecutorWithOomHook > > > Key: HIVE-27715 > URL: https://issues.apache.org/jira/browse/HIVE-27715 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27698) Backport of HIVE-22398: Remove legacy code that can cause issue with new Yarn releases
[ https://issues.apache.org/jira/browse/HIVE-27698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27698: Affects Version/s: 3.1.3 > Backport of HIVE-22398: Remove legacy code that can cause issue with new Yarn > releases > -- > > Key: HIVE-27698 > URL: https://issues.apache.org/jira/browse/HIVE-27698 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27698) Backport of HIVE-22398: Remove legacy code that can cause issue with new Yarn releases
[ https://issues.apache.org/jira/browse/HIVE-27698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27698. - Fix Version/s: 3.2.0 Assignee: Aman Raj Resolution: Fixed > Backport of HIVE-22398: Remove legacy code that can cause issue with new Yarn > releases > -- > > Key: HIVE-27698 > URL: https://issues.apache.org/jira/browse/HIVE-27698 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27537) Backport of HIVE-19416, HIVE-20293, HIVE-20117, HIVE-18453, HIVE-20833, HIVE-21498
[ https://issues.apache.org/jira/browse/HIVE-27537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27537. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-19416, HIVE-20293, HIVE-20117, HIVE-18453, HIVE-20833, > HIVE-21498 > -- > > Key: HIVE-27537 > URL: https://issues.apache.org/jira/browse/HIVE-27537 > Project: Hive > Issue Type: Sub-task > Components: Hive >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27537) Backport of HIVE-19416, HIVE-20293, HIVE-20117, HIVE-18453, HIVE-20833, HIVE-21498
[ https://issues.apache.org/jira/browse/HIVE-27537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27537: Affects Version/s: 3.1.3 (was: 3.2.0) > Backport of HIVE-19416, HIVE-20293, HIVE-20117, HIVE-18453, HIVE-20833, > HIVE-21498 > -- > > Key: HIVE-27537 > URL: https://issues.apache.org/jira/browse/HIVE-27537 > Project: Hive > Issue Type: Sub-task > Components: Hive >Affects Versions: 3.1.3 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27537) Backport of HIVE-19416, HIVE-20293, HIVE-20117, HIVE-18453, HIVE-20833, HIVE-21498 to branch-3
[ https://issues.apache.org/jira/browse/HIVE-27537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27537: Summary: Backport of HIVE-19416, HIVE-20293, HIVE-20117, HIVE-18453, HIVE-20833, HIVE-21498 to branch-3 (was: Backport of HIVE-19416, HIVE-20293, HIVE-20117, HIVE-18453, HIVE-20833 to branch-3) > Backport of HIVE-19416, HIVE-20293, HIVE-20117, HIVE-18453, HIVE-20833, > HIVE-21498 to branch-3 > -- > > Key: HIVE-27537 > URL: https://issues.apache.org/jira/browse/HIVE-27537 > Project: Hive > Issue Type: Sub-task > Components: Hive >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27537) Backport of HIVE-19416, HIVE-20293, HIVE-20117, HIVE-18453, HIVE-20833 to branch-3
[ https://issues.apache.org/jira/browse/HIVE-27537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27537: Summary: Backport of HIVE-19416, HIVE-20293, HIVE-20117, HIVE-18453, HIVE-20833 to branch-3 (was: Backport of HIVE-19416, HIVE-20293, HIVE-20117, HIVE-18453) > Backport of HIVE-19416, HIVE-20293, HIVE-20117, HIVE-18453, HIVE-20833 to > branch-3 > -- > > Key: HIVE-27537 > URL: https://issues.apache.org/jira/browse/HIVE-27537 > Project: Hive > Issue Type: Sub-task > Components: Hive >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27644) Backport of HIVE-17917, HIVE-21457, HIVE-22582
[ https://issues.apache.org/jira/browse/HIVE-27644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27644. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-17917, HIVE-21457, HIVE-22582 > -- > > Key: HIVE-27644 > URL: https://issues.apache.org/jira/browse/HIVE-27644 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27644) Backport of HIVE-17917, HIVE-21457, HIVE-22582
[ https://issues.apache.org/jira/browse/HIVE-27644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27644: Affects Version/s: 3.1.3 (was: 3.2.0) > Backport of HIVE-17917, HIVE-21457, HIVE-22582 > -- > > Key: HIVE-27644 > URL: https://issues.apache.org/jira/browse/HIVE-27644 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (HIVE-27324) Hive query with NOT IN condition is giving incorrect results when the sub query table contains the null value.
[
https://issues.apache.org/jira/browse/HIVE-27324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17765925#comment-17765925
]
Sankar Hariappan commented on HIVE-27324:
-
[~diksha193] Pls attach the mysql output for queries in discussion.
> Hive query with NOT IN condition is giving incorrect results when the sub
> query table contains the null value.
> --
>
> Key: HIVE-27324
> URL: https://issues.apache.org/jira/browse/HIVE-27324
> Project: Hive
> Issue Type: Bug
> Components: Hive
>Affects Versions: All Versions, 3.1.0
>Reporter: Shobika Selvaraj
>Assignee: Diksha
>Priority: Major
> Labels: pull-request-available
>
> Hive query giving empty results when the sub query table contains the null
> value.
> We encountered two issues here.
> 1) The query - "select * from t3 where age not in (select distinct(age) age
> from t1);" is giving empty results when the table t1 contains a null value.
> Disabling cbo didn't helped here.
> 2) Let's consider the table t3 has null value and table t1 doesn't have any
> null values. Now if we run the above query it is returning other data's but
> not the null value from t3. If we disable the cbo then it's giving result
> with null value.
>
> *REPRO STEPS WITH DETAILED EXPLANATION AS BELOW:*
> *FIRST ISSUE:*
> Create two tables and insert data with null values as below:
> ---
> create table t3 (id int,name string, age int);
>
> insert into t3
> values(1,'Sagar',23),(2,'Sultan',NULL),(3,'Surya',23),(4,'Raman',45),(5,'Scott',23),(6,'Ramya',5),(7,'',23),(8,'',23),(9,'ron',3),(10,'Sam',22),(11,'nick',19),(12,'fed',18),(13,'kong',13),(14,'hela',45);
>
> create table t1 (id int,name string, age int);
> insert into t1
> values(1,'Sagar',23),(2,'Sultan',NULL),(3,'Surya',23),(4,'Raman',45),(5,'Scott',23),(6,'Ramya',5),(7,'',23),(8,'',23);
> ---
>
> Then executed the below query:
> --
> select * from t3
> where age not in (select distinct(age) age from t1);
> --
>
> The result should be as below:
> {code:java}
> ++--+-+
> | t3.id | t3.name | t3.age |
> ++--+-+
> | 9 | ron | 3 |
> | 10 | Sam | 22 |
> | 11 | nick | 19 |
> | 12 | fed | 18 |
> | 13 | kong | 13 |
> ++--+-+
> 5 rows selected (35.897 seconds) {code}
> But when we run the above query it is giving zero records:
> {code:java}
> 0: jdbc:hive2://zk0-shobia.lhlexkfu3vfebcezzj> select * from t3
> . . . . . . . . . . . . . . . . . . . . . . .> where age not in (select
> distinct(age) age from t1);
> INFO : Compiling
> command(queryId=hive_20230427164202_e25b671a-f3bd-41e4-b364-844466305d96):
> select * from t3
> where age not in (select distinct(age) age from t1)
> INFO : Warning: Map Join MAPJOIN[37][bigTable=?] in task 'Map 1' is a cross
> product
> ..
> .
> INFO : Completed executing
> command(queryId=hive_20230427164202_e25b671a-f3bd-41e4-b364-844466305d96);
> Time taken: 10.191 seconds
> INFO : OK
> ++--+-+
> | t3.id | t3.name | t3.age |
> ++--+-+
> ++--+-+
> No rows selected (12.17 seconds) {code}
> The query works fine when we use nvl function or not null condition.
>
> So as a workaround we can use nvl function for both main and sub query as
> below:
> {code:java}
> select * from t3 where nvl(age,'-') not in (select distinct(nvl(age,'-')) age
> from t1); {code}
>
> *SECOND ISSUE:*
> Also while testing multiple scenario's i found one more issue as well.
> When the sub query table (t1) doesn't contain any null values then the query
> is giving result but it is ignoring the null values of the main table(t3) .
>
> For example: Created another table t4 and inserted the data's without any
> null values:
> create table t4 (id int,name string, age int);
> insert into t4
> values(1,'Sagar',23),(3,'Surya',23),(4,'Raman',45),(5,'Scott',23),(6,'Ramya',5),(7,'',23),(8,'',23);
> Now i tested with the below query and it gives 5 records. The count should be
> six and it omitted the null value of the table t3:
> {code:java}
> 0: jdbc:hive2://zk0-shobia.lhlexkfu3vfebcezzj> select * from t3
> . . . . . . . . . . . . . . . . . . . . . . .> where age not in (select
> distinct(age) age from t4);
> INFO : Compiling
> command(queryId=hive_20230427164745_f20f47ce-614d-493d-8910-99a118de089c):
> select * from t3
> where age not in (select distinct(age) age from t4)
> INFO : Warning: Map Join MAPJOIN[37][bigTable=?] in task 'Map 1' is a cross
> product
> ..
> ..
> INFO : Completed executing
>
[jira] [Updated] (HIVE-26751) Bug Fixes and Improvements for 3.2.0 release
[ https://issues.apache.org/jira/browse/HIVE-26751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-26751: Issue Type: Improvement (was: Task) > Bug Fixes and Improvements for 3.2.0 release > > > Key: HIVE-26751 > URL: https://issues.apache.org/jira/browse/HIVE-26751 > Project: Hive > Issue Type: Improvement >Affects Versions: 3.1.3 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Blocker > Labels: hive-3.2.0-must, pull-request-available, release-3.2.0 > > Creating subtask to track the bug fixes that will go as part of 3.2.0 release. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27212) Backport of HIVE-24316: Upgrade ORC from 1.5.6 to 1.5.8 in branch-3.1
[ https://issues.apache.org/jira/browse/HIVE-27212?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27212. - Fix Version/s: 3.2.0 Assignee: Diksha Resolution: Duplicate Duplicate with https://issues.apache.org/jira/browse/HIVE-27058 > Backport of HIVE-24316: Upgrade ORC from 1.5.6 to 1.5.8 in branch-3.1 > - > > Key: HIVE-27212 > URL: https://issues.apache.org/jira/browse/HIVE-27212 > Project: Hive > Issue Type: Sub-task >Reporter: Diksha >Assignee: Diksha >Priority: Major > Fix For: 3.2.0 > > > Backport of HIVE-24316: Upgrade ORC from 1.5.6 to 1.5.8 in branch-3.1 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27666) Backport of HIVE-22903 : Vectorized row_number() resets the row number after one batch in case of constant expression in partition clause
[ https://issues.apache.org/jira/browse/HIVE-27666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27666: Affects Version/s: 3.1.3 > Backport of HIVE-22903 : Vectorized row_number() resets the row number after > one batch in case of constant expression in partition clause > -- > > Key: HIVE-27666 > URL: https://issues.apache.org/jira/browse/HIVE-27666 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Diksha >Assignee: Diksha >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-22903 : Vectorized row_number() resets the row number after > one batch in case of constant expression in partition clause -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27666) Backport of HIVE-22903 : Vectorized row_number() resets the row number after one batch in case of constant expression in partition clause
[ https://issues.apache.org/jira/browse/HIVE-27666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27666. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-22903 : Vectorized row_number() resets the row number after > one batch in case of constant expression in partition clause > -- > > Key: HIVE-27666 > URL: https://issues.apache.org/jira/browse/HIVE-27666 > Project: Hive > Issue Type: Sub-task >Reporter: Diksha >Assignee: Diksha >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-22903 : Vectorized row_number() resets the row number after > one batch in case of constant expression in partition clause -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27388) Backport of HIVE-23058: Compaction task reattempt fails with FileAlreadyExistsException
[ https://issues.apache.org/jira/browse/HIVE-27388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27388: Affects Version/s: 3.1.3 > Backport of HIVE-23058: Compaction task reattempt fails with > FileAlreadyExistsException > --- > > Key: HIVE-27388 > URL: https://issues.apache.org/jira/browse/HIVE-27388 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Diksha >Assignee: Diksha >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-23058: Compaction task reattempt fails with > FileAlreadyExistsException -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27388) Backport of HIVE-23058: Compaction task reattempt fails with FileAlreadyExistsException
[ https://issues.apache.org/jira/browse/HIVE-27388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27388. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-23058: Compaction task reattempt fails with > FileAlreadyExistsException > --- > > Key: HIVE-27388 > URL: https://issues.apache.org/jira/browse/HIVE-27388 > Project: Hive > Issue Type: Sub-task >Reporter: Diksha >Assignee: Diksha >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-23058: Compaction task reattempt fails with > FileAlreadyExistsException -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27668) Backport of HIVE-21126: Allow session level queries in LlapBaseInputFormat#getSplits() before actual get_splits() call
[ https://issues.apache.org/jira/browse/HIVE-27668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27668. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-21126: Allow session level queries in > LlapBaseInputFormat#getSplits() before actual get_splits() call > -- > > Key: HIVE-27668 > URL: https://issues.apache.org/jira/browse/HIVE-27668 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27385) Backport of HIVE-22099: Several date related UDFs can't handle Julian dates properly since HIVE-20007
[ https://issues.apache.org/jira/browse/HIVE-27385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27385. - Fix Version/s: 3.2.0 Assignee: Aman Raj (was: Diksha) Resolution: Fixed > Backport of HIVE-22099: Several date related UDFs can't handle Julian dates > properly since HIVE-20007 > - > > Key: HIVE-27385 > URL: https://issues.apache.org/jira/browse/HIVE-27385 > Project: Hive > Issue Type: Sub-task >Reporter: Diksha >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-22099: Several date related UDFs can't handle Julian dates > properly since HIVE-20007 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27605) Backport of HIVE-19661 : switch Hive UDFs to use Re2J regex engine
[ https://issues.apache.org/jira/browse/HIVE-27605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27605. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-19661 : switch Hive UDFs to use Re2J regex engine > -- > > Key: HIVE-27605 > URL: https://issues.apache.org/jira/browse/HIVE-27605 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27611) Backport of HIVE-22168: Remove very expensive logging from the llap cache hotpath
[ https://issues.apache.org/jira/browse/HIVE-27611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27611. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-22168: Remove very expensive logging from the llap cache > hotpath > - > > Key: HIVE-27611 > URL: https://issues.apache.org/jira/browse/HIVE-27611 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27612) Backport of HIVE-22169: Tez: SplitGenerator tries to look for plan files which won't exist for Tez
[ https://issues.apache.org/jira/browse/HIVE-27612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27612. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-22169: Tez: SplitGenerator tries to look for plan files > which won't exist for Tez > -- > > Key: HIVE-27612 > URL: https://issues.apache.org/jira/browse/HIVE-27612 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27612) Backport of HIVE-22169: Tez: SplitGenerator tries to look for plan files which won't exist for Tez
[ https://issues.apache.org/jira/browse/HIVE-27612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27612: Summary: Backport of HIVE-22169: Tez: SplitGenerator tries to look for plan files which won't exist for Tez (was: Backport of Tez: SplitGenerator tries to look for plan files which won't exist for Tez) > Backport of HIVE-22169: Tez: SplitGenerator tries to look for plan files > which won't exist for Tez > -- > > Key: HIVE-27612 > URL: https://issues.apache.org/jira/browse/HIVE-27612 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27610) Backport of HIVE-22161 UDF: FunctionRegistry synchronizes on org.apache.hadoop.hive.ql.udf.UDFType class
[ https://issues.apache.org/jira/browse/HIVE-27610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27610. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-22161 UDF: FunctionRegistry synchronizes on > org.apache.hadoop.hive.ql.udf.UDFType class > > > Key: HIVE-27610 > URL: https://issues.apache.org/jira/browse/HIVE-27610 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27606) Backport of HIVE-21171: Skip creating scratch dirs for tez if RPC is on
[ https://issues.apache.org/jira/browse/HIVE-27606?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27606. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-21171: Skip creating scratch dirs for tez if RPC is on > --- > > Key: HIVE-27606 > URL: https://issues.apache.org/jira/browse/HIVE-27606 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27607) Backport of HIVE-21182 Skip setting up hive scratch dir during planning
[ https://issues.apache.org/jira/browse/HIVE-27607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27607. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-21182 Skip setting up hive scratch dir during planning > --- > > Key: HIVE-27607 > URL: https://issues.apache.org/jira/browse/HIVE-27607 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27617) Backport of HIVE-18284: Fix NPE when inserting data with 'distribute by' clause with dynpart sort optimization
[ https://issues.apache.org/jira/browse/HIVE-27617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27617. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-18284: Fix NPE when inserting data with 'distribute by' > clause with dynpart sort optimization > -- > > Key: HIVE-27617 > URL: https://issues.apache.org/jira/browse/HIVE-27617 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27613) Backport of HIVE-22204: Beeline option to show/not show execution report
[ https://issues.apache.org/jira/browse/HIVE-27613?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27613. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-22204: Beeline option to show/not show execution report > > > Key: HIVE-27613 > URL: https://issues.apache.org/jira/browse/HIVE-27613 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27624) Backport of HIVE-26080: Upgrade accumulo-core to 1.10.1
[ https://issues.apache.org/jira/browse/HIVE-27624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27624. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-26080: Upgrade accumulo-core to 1.10.1 > --- > > Key: HIVE-27624 > URL: https://issues.apache.org/jira/browse/HIVE-27624 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27618) Backport of HIVE-25446: Wrong execption thrown if capacity<=0
[ https://issues.apache.org/jira/browse/HIVE-27618?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27618. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-25446: Wrong execption thrown if capacity<=0 > - > > Key: HIVE-27618 > URL: https://issues.apache.org/jira/browse/HIVE-27618 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27615) Backport of HIVE-21280 : Null pointer exception on running compaction against a MM table.
[ https://issues.apache.org/jira/browse/HIVE-27615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27615. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-21280 : Null pointer exception on running compaction against > a MM table. > - > > Key: HIVE-27615 > URL: https://issues.apache.org/jira/browse/HIVE-27615 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27552) Backport of HIVE-22360, HIVE-20619 : MultiDelimitSerDe returns wrong results in last column when the loaded file has more columns than those in table schema
[ https://issues.apache.org/jira/browse/HIVE-27552?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27552. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-22360, HIVE-20619 : MultiDelimitSerDe returns wrong results > in last column when the loaded file has more columns than those in table > schema > > > Key: HIVE-27552 > URL: https://issues.apache.org/jira/browse/HIVE-27552 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27569) Backport of HIVE-22405: Add ColumnVector support for ProlepticCalendar
[ https://issues.apache.org/jira/browse/HIVE-27569?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27569: Affects Version/s: 3.1.3 (was: 3.2.0) > Backport of HIVE-22405: Add ColumnVector support for ProlepticCalendar > -- > > Key: HIVE-27569 > URL: https://issues.apache.org/jira/browse/HIVE-27569 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Shefali Singh >Assignee: Shefali Singh >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27569) Backport of HIVE-22405: Add ColumnVector support for ProlepticCalendar
[ https://issues.apache.org/jira/browse/HIVE-27569?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27569. - Fix Version/s: 3.2.0 Resolution: Fixed Thanks [~shefali636] for the contribution! > Backport of HIVE-22405: Add ColumnVector support for ProlepticCalendar > -- > > Key: HIVE-27569 > URL: https://issues.apache.org/jira/browse/HIVE-27569 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Shefali Singh >Assignee: Shefali Singh >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27570) Backport of HIVE-21815: Stats in ORC file are parsed twice
[ https://issues.apache.org/jira/browse/HIVE-27570?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27570. - Fix Version/s: 3.2.0 Resolution: Fixed Thanks [~shefali636] for the contribution! > Backport of HIVE-21815: Stats in ORC file are parsed twice > -- > > Key: HIVE-27570 > URL: https://issues.apache.org/jira/browse/HIVE-27570 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Shefali Singh >Assignee: Shefali Singh >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27571) Backport of HIVE-18702: INSERT OVERWRITE TABLE doesn't clean the table directory before overwriting
[ https://issues.apache.org/jira/browse/HIVE-27571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27571. - Fix Version/s: 3.2.0 Resolution: Fixed Thanks [~shefali636] for the contribution! > Backport of HIVE-18702: INSERT OVERWRITE TABLE doesn't clean the table > directory before overwriting > --- > > Key: HIVE-27571 > URL: https://issues.apache.org/jira/browse/HIVE-27571 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Shefali Singh >Assignee: Shefali Singh >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27571) Backport of HIVE-18702: INSERT OVERWRITE TABLE doesn't clean the table directory before overwriting
[ https://issues.apache.org/jira/browse/HIVE-27571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27571: Affects Version/s: 3.1.3 (was: 3.2.0) > Backport of HIVE-18702: INSERT OVERWRITE TABLE doesn't clean the table > directory before overwriting > --- > > Key: HIVE-27571 > URL: https://issues.apache.org/jira/browse/HIVE-27571 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Shefali Singh >Assignee: Shefali Singh >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27572) Backport of HIVE-21296: Dropping varchar partition throw exception
[ https://issues.apache.org/jira/browse/HIVE-27572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27572. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-21296: Dropping varchar partition throw exception > -- > > Key: HIVE-27572 > URL: https://issues.apache.org/jira/browse/HIVE-27572 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Shefali Singh >Assignee: Shefali Singh >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27572) Backport of HIVE-21296: Dropping varchar partition throw exception
[ https://issues.apache.org/jira/browse/HIVE-27572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan updated HIVE-27572: Affects Version/s: 3.1.3 (was: 3.2.0) > Backport of HIVE-21296: Dropping varchar partition throw exception > -- > > Key: HIVE-27572 > URL: https://issues.apache.org/jira/browse/HIVE-27572 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Shefali Singh >Assignee: Shefali Singh >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (HIVE-27572) Backport of HIVE-21296: Dropping varchar partition throw exception
[ https://issues.apache.org/jira/browse/HIVE-27572?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17756688#comment-17756688 ] Sankar Hariappan commented on HIVE-27572: - Thanks [~shefali636] for the contribution! > Backport of HIVE-21296: Dropping varchar partition throw exception > -- > > Key: HIVE-27572 > URL: https://issues.apache.org/jira/browse/HIVE-27572 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.1.3 >Reporter: Shefali Singh >Assignee: Shefali Singh >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27623) Backport of HIVE-26081: Upgrade ant to 1.10.9
[ https://issues.apache.org/jira/browse/HIVE-27623?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27623. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-26081: Upgrade ant to 1.10.9 > - > > Key: HIVE-27623 > URL: https://issues.apache.org/jira/browse/HIVE-27623 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27621) backport of HIVE-25697: Upgrade commons-compress to 1.21
[ https://issues.apache.org/jira/browse/HIVE-27621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27621. - Fix Version/s: 3.2.0 Resolution: Fixed > backport of HIVE-25697: Upgrade commons-compress to 1.21 > > > Key: HIVE-27621 > URL: https://issues.apache.org/jira/browse/HIVE-27621 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27620) Backport of HIVE-25945: Upgrade H2 database version to 2.1.210
[ https://issues.apache.org/jira/browse/HIVE-27620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27620. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-25945: Upgrade H2 database version to 2.1.210 > -- > > Key: HIVE-27620 > URL: https://issues.apache.org/jira/browse/HIVE-27620 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27614) Backport of HIVE-21009: Adding ability for user to set bind user
[ https://issues.apache.org/jira/browse/HIVE-27614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27614. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-21009: Adding ability for user to set bind user > > > Key: HIVE-27614 > URL: https://issues.apache.org/jira/browse/HIVE-27614 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27609) Backport of HIVE-22115: Prevent the creation of query routing appender if property is set to false
[ https://issues.apache.org/jira/browse/HIVE-27609?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27609. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-22115: Prevent the creation of query routing appender if > property is set to false > -- > > Key: HIVE-27609 > URL: https://issues.apache.org/jira/browse/HIVE-27609 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27608) Backport of HIVE-22106: Remove cross-query synchronization for the partition-eval
[ https://issues.apache.org/jira/browse/HIVE-27608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27608. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-22106: Remove cross-query synchronization for the > partition-eval > - > > Key: HIVE-27608 > URL: https://issues.apache.org/jira/browse/HIVE-27608 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27603) Backport of HIVE-22498
[ https://issues.apache.org/jira/browse/HIVE-27603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27603. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-22498 > -- > > Key: HIVE-27603 > URL: https://issues.apache.org/jira/browse/HIVE-27603 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27602) Backport of HIVE-21915: Hive with TEZ UNION ALL and UDTF results in data loss
[ https://issues.apache.org/jira/browse/HIVE-27602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27602. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-21915: Hive with TEZ UNION ALL and UDTF results in data loss > - > > Key: HIVE-27602 > URL: https://issues.apache.org/jira/browse/HIVE-27602 > Project: Hive > Issue Type: Sub-task >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27551) Backport of HIVE-22208 : Column name with reserved keyword is unescaped when query including join on table with mask column is re-written
[ https://issues.apache.org/jira/browse/HIVE-27551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27551. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-22208 : Column name with reserved keyword is unescaped when > query including join on table with mask column is re-written > - > > Key: HIVE-27551 > URL: https://issues.apache.org/jira/browse/HIVE-27551 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27550) Backport of HIVE-22113: Prevent LLAP shutdown on AMReporter related RuntimeException
[ https://issues.apache.org/jira/browse/HIVE-27550?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sankar Hariappan resolved HIVE-27550. - Fix Version/s: 3.2.0 Resolution: Fixed > Backport of HIVE-22113: Prevent LLAP shutdown on AMReporter related > RuntimeException > > > Key: HIVE-27550 > URL: https://issues.apache.org/jira/browse/HIVE-27550 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Aman Raj >Assignee: Aman Raj >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > -- This message was sent by Atlassian Jira (v8.20.10#820010)
