[jira] [Updated] (HIVE-27810) Backport of HIVE-22593: Compaction fails on non bucketed table with data loaded inpath
[ https://issues.apache.org/jira/browse/HIVE-27810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated HIVE-27810: -- Labels: pull-request-available (was: ) > Backport of HIVE-22593: Compaction fails on non bucketed table with data > loaded inpath > -- > > Key: HIVE-27810 > URL: https://issues.apache.org/jira/browse/HIVE-27810 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Diksha >Assignee: Diksha >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > This is a backport of HIVE-22593: Compaction fails on non bucketed table with > data loaded inpath -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Created] (HIVE-27810) Backport of HIVE-22593: Compaction fails on non bucketed table with data loaded inpath
Diksha created HIVE-27810: - Summary: Backport of HIVE-22593: Compaction fails on non bucketed table with data loaded inpath Key: HIVE-27810 URL: https://issues.apache.org/jira/browse/HIVE-27810 Project: Hive Issue Type: Sub-task Affects Versions: 3.2.0 Reporter: Diksha Assignee: Diksha Fix For: 3.2.0 This is a backport of HIVE-22593: Compaction fails on non bucketed table with data loaded inpath -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27574) Backport of HIVE-22661: Compaction fails on non bucketed table with data loaded inpath
[ https://issues.apache.org/jira/browse/HIVE-27574?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated HIVE-27574: -- Labels: pull-request-available (was: ) > Backport of HIVE-22661: Compaction fails on non bucketed table with data > loaded inpath > -- > > Key: HIVE-27574 > URL: https://issues.apache.org/jira/browse/HIVE-27574 > Project: Hive > Issue Type: Sub-task >Reporter: Diksha >Assignee: Diksha >Priority: Major > Labels: pull-request-available > > Backport of HIVE-22661: Compaction fails on non bucketed table with data > loaded inpath -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27346) Getting exception for wildcard (*) search for database and table name
[ https://issues.apache.org/jira/browse/HIVE-27346?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhihua Deng resolved HIVE-27346. Fix Version/s: 4.0.0 Resolution: Fixed > Getting exception for wildcard (*) search for database and table name > - > > Key: HIVE-27346 > URL: https://issues.apache.org/jira/browse/HIVE-27346 > Project: Hive > Issue Type: Improvement >Reporter: Hongdan Zhu >Assignee: Hongdan Zhu >Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > > Hive resource lookup is not working properly. > When there is wildcard * sign in the database or table search, got exception: > org.apache.hadoop.hive.metastore.api.UnknownDBException Could not find > database hive.{*}: There is no database hive.{*} > UnknownDBException(message:Could not find database hive.{*}: There is no > database hive.{*}) -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (HIVE-27346) Getting exception for wildcard (*) search for database and table name
[ https://issues.apache.org/jira/browse/HIVE-27346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17776962#comment-17776962 ] Zhihua Deng commented on HIVE-27346: Fix has been merged to master. Thank you [~danielzhu] for the PR! > Getting exception for wildcard (*) search for database and table name > - > > Key: HIVE-27346 > URL: https://issues.apache.org/jira/browse/HIVE-27346 > Project: Hive > Issue Type: Improvement >Reporter: Hongdan Zhu >Assignee: Hongdan Zhu >Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > > Hive resource lookup is not working properly. > When there is wildcard * sign in the database or table search, got exception: > org.apache.hadoop.hive.metastore.api.UnknownDBException Could not find > database hive.{*}: There is no database hive.{*} > UnknownDBException(message:Could not find database hive.{*}: There is no > database hive.{*}) -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-25351) stddev(), stddev_pop() with CBO enable returning null
[ https://issues.apache.org/jira/browse/HIVE-25351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated HIVE-25351: -- Labels: pull-request-available (was: ) > stddev(), stddev_pop() with CBO enable returning null > - > > Key: HIVE-25351 > URL: https://issues.apache.org/jira/browse/HIVE-25351 > Project: Hive > Issue Type: Bug >Reporter: Ashish Sharma >Assignee: Dayakar M >Priority: Blocker > Labels: pull-request-available > > *script used to repro* > create table cbo_test (key string, v1 double, v2 decimal(30,2), v3 > decimal(30,2)); > insert into cbo_test values ("00140006375905", 10230.72, > 10230.72, 10230.69), ("00140006375905", 10230.72, 10230.72, > 10230.69), ("00140006375905", 10230.72, 10230.72, 10230.69), > ("00140006375905", 10230.72, 10230.72, 10230.69), > ("00140006375905", 10230.72, 10230.72, 10230.69), > ("00140006375905", 10230.72, 10230.72, 10230.69); > select stddev(v1), stddev(v2), stddev(v3) from cbo_test; > *Enable CBO* > ++ > | Explain | > ++ > | Plan optimized by CBO. | > || > | Vertex dependency in root stage| > | Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)| > || > | Stage-0| > | Fetch Operator | > | limit:-1 | > | Stage-1| > | Reducer 2 vectorized | > | File Output Operator [FS_13] | > | Select Operator [SEL_12] (rows=1 width=24) | > | Output:["_col0","_col1","_col2"] | > | Group By Operator [GBY_11] (rows=1 width=72) | > | > Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"],aggregations:["sum(VALUE._col0)","sum(VALUE._col1)","count(VALUE._col2)","sum(VALUE._col3)","sum(VALUE._col4)","count(VALUE._col5)","sum(VALUE._col6)","sum(VALUE._col7)","count(VALUE._col8)"] > | > | <-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized | > | PARTITION_ONLY_SHUFFLE [RS_10] | > | Group By Operator [GBY_9] (rows=1 width=72) | > | > Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"],aggregations:["sum(_col3)","sum(_col0)","count(_col0)","sum(_col5)","sum(_col4)","count(_col1)","sum(_col7)","sum(_col6)","count(_col2)"] > | > | Select Operator [SEL_8] (rows=6 width=232) | > | > Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"] | > | TableScan [TS_0] (rows=6 width=232) | > | default@cbo_test,cbo_test, ACID > table,Tbl:COMPLETE,Col:COMPLETE,Output:["v1","v2","v3"] | > || > ++ > *Query Result* > _c0 _c1 _c2 > 0.0 NaN NaN > *Disable CBO* > ++ > | Explain | > ++ > | Vertex dependency in root stage| > | Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE)| > || > | Stage-0| > | Fetch Operator | > | limit:-1 | > | Stage-1| > | Reducer 2 vectorized | > | File Output Operator [FS_11] | > | Group By Operator [GBY_10] (rows=1 width=24) | > | > Output:["_col0","_col1","_col2"],aggregations:["stddev(VALUE._col0)","stddev(VALUE._col1)","stddev(VALUE._col2)"] > | > | <-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized| > | PARTITION_ONLY_SHUFFLE [RS_9]| > | Group By Operator [GBY_8] (rows=1 width=240) | > | > Output:["_col0","_col1","_col2"],aggregations:["stddev(v1)","stddev(v2)","stddev(v3)"] > | > | Select Operator [SEL_7] (rows=6 width=232) | > | Output:["v1","v2","v3"]| > | TableScan [TS_0] (rows=6 width=232) | > | default@cbo_test,cbo_test, ACID > table,Tbl:COMPLETE,Col:COMPLETE,Output:["v1","v2","v3"] | > |
[jira] [Updated] (HIVE-27808) Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458 , 25577
[ https://issues.apache.org/jira/browse/HIVE-27808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Diksha updated HIVE-27808: -- Summary: Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458 , 25577 (was: Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458 ) > Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458 , 25577 > - > > Key: HIVE-27808 > URL: https://issues.apache.org/jira/browse/HIVE-27808 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Diksha >Assignee: Diksha >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458 for all Unix timestamps > related JIRAs. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27808) Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458
[ https://issues.apache.org/jira/browse/HIVE-27808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated HIVE-27808: -- Labels: pull-request-available (was: ) > Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458 > -- > > Key: HIVE-27808 > URL: https://issues.apache.org/jira/browse/HIVE-27808 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Diksha >Assignee: Diksha >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458 for all Unix timestamps > related JIRAs. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27808) Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458 , 25577
[ https://issues.apache.org/jira/browse/HIVE-27808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Diksha updated HIVE-27808: -- Description: Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458 , 25577 for all Unix timestamps related JIRAs. (was: Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458 for all Unix timestamps related JIRAs.) > Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458 , 25577 > - > > Key: HIVE-27808 > URL: https://issues.apache.org/jira/browse/HIVE-27808 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Diksha >Assignee: Diksha >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458 , 25577 for all Unix > timestamps related JIRAs. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27809) Backport of HIVE-21715: Adding a new partition specified by location (which is empty) leads to Exceptions
[ https://issues.apache.org/jira/browse/HIVE-27809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated HIVE-27809: -- Labels: pull-request-available (was: ) > Backport of HIVE-21715: Adding a new partition specified by location (which > is empty) leads to Exceptions > - > > Key: HIVE-27809 > URL: https://issues.apache.org/jira/browse/HIVE-27809 > Project: Hive > Issue Type: Sub-task >Affects Versions: 3.2.0 >Reporter: Diksha >Assignee: Diksha >Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > > Backport of HIVE-21715: Adding a new partition specified by location (which > is empty) leads to Exceptions -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Created] (HIVE-27809) Backport of HIVE-21715: Adding a new partition specified by location (which is empty) leads to Exceptions
Diksha created HIVE-27809: - Summary: Backport of HIVE-21715: Adding a new partition specified by location (which is empty) leads to Exceptions Key: HIVE-27809 URL: https://issues.apache.org/jira/browse/HIVE-27809 Project: Hive Issue Type: Sub-task Affects Versions: 3.2.0 Reporter: Diksha Assignee: Diksha Fix For: 3.2.0 Backport of HIVE-21715: Adding a new partition specified by location (which is empty) leads to Exceptions -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Created] (HIVE-27808) Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458
Diksha created HIVE-27808: - Summary: Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458 Key: HIVE-27808 URL: https://issues.apache.org/jira/browse/HIVE-27808 Project: Hive Issue Type: Sub-task Affects Versions: 3.2.0 Reporter: Diksha Assignee: Diksha Fix For: 3.2.0 Backport of HIVE-20082 ,22170 ,22331 , 24113 , 25458 for all Unix timestamps related JIRAs. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Resolved] (HIVE-27783) Iceberg: Implement Copy-On-Write for Update queries
[ https://issues.apache.org/jira/browse/HIVE-27783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Denys Kuzmenko resolved HIVE-27783. --- Fix Version/s: 4.0.0 Resolution: Fixed > Iceberg: Implement Copy-On-Write for Update queries > --- > > Key: HIVE-27783 > URL: https://issues.apache.org/jira/browse/HIVE-27783 > Project: Hive > Issue Type: Sub-task >Reporter: Denys Kuzmenko >Assignee: Denys Kuzmenko >Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > > Implement copy on write mode for updates on iceberg tables -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (HIVE-27783) Iceberg: Implement Copy-On-Write for Update queries
[ https://issues.apache.org/jira/browse/HIVE-27783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17776662#comment-17776662 ] Denys Kuzmenko commented on HIVE-27783: --- Merged to master. Thanks for the review [~zhangbutao], [~kkasa]! > Iceberg: Implement Copy-On-Write for Update queries > --- > > Key: HIVE-27783 > URL: https://issues.apache.org/jira/browse/HIVE-27783 > Project: Hive > Issue Type: Sub-task >Reporter: Denys Kuzmenko >Assignee: Denys Kuzmenko >Priority: Major > Labels: pull-request-available > > Implement copy on write mode for updates on iceberg tables -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-20082) HiveDecimal to string conversion doesn't format the decimal correctly - master
[ https://issues.apache.org/jira/browse/HIVE-20082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated HIVE-20082: -- Labels: pull-request-available (was: ) > HiveDecimal to string conversion doesn't format the decimal correctly - master > -- > > Key: HIVE-20082 > URL: https://issues.apache.org/jira/browse/HIVE-20082 > Project: Hive > Issue Type: Bug > Components: Types >Reporter: Sergey Shelukhin >Assignee: Jason Dere >Priority: Major > Labels: pull-request-available > Fix For: 4.0.0-alpha-1 > > Attachments: HIVE-20082.1.patch, HIVE-20082.2.patch, > HIVE-20082.3.patch, HIVE-20082.4.patch > > > Example: LPAD on a decimal(7,1) values of 0 returns "0" (plus padding) but it > should be "0.0" (plus padding) -- 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)