[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=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=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)
