You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Csaba Ringhofer (Jira)" <ji...@apache.org> on 2019/10/30 19:01:00 UTC
[jira] [Updated] (HIVE-21806) Renaming a table to another db does
not handle Impala stats in partitoned tables
[ https://issues.apache.org/jira/browse/HIVE-21806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Csaba Ringhofer updated HIVE-21806:
-----------------------------------
Description:
The issue seems similar to HIVE-9720, but only happens with partitioned tables. I only tested with Hive 3.1 in Impala dev environment.
The issue can be reproduced by the following statements (it doesn't matter whether Hive or Impala runs them with the exception of compute/show stats).
{code}
create database db1;
create database db2;
create table db1.t(i int) partitioned by (p int);
insert into db1.t partition (p=1) values (2);
compute stats db1.t; -- needs Impala
alter table db1.t rename to db2.t;
show column stats db2.t; -- needs Impala, null count and ndv will be incorrectly -1
drop table db2.t; -- this will hang
{code}
was:
The issue seems similar to HIVE-9720, but only happens with partitioned tables. I only tested with Hive 3.1 in Impala dev environment.
The issue can be reproduced by the following statements (it doesn't matter whether Hive or Impala runs them with the exception of compute/show stats).
create database db1;
create database db2;
create table db1.t(i int) partitioned by (p int);
insert into db1.t partition (p=1) values (2);
compute stats db1.t; -- needs Impala
alter table db1.t rename to db2.t;
show column stats db1.2; -- needs Impala, null count and ndv will be incorrectly -1
drop table db2.t; -- this will hang
> Renaming a table to another db does not handle Impala stats in partitoned tables
> --------------------------------------------------------------------------------
>
> Key: HIVE-21806
> URL: https://issues.apache.org/jira/browse/HIVE-21806
> Project: Hive
> Issue Type: Bug
> Components: Metastore, Standalone Metastore
> Affects Versions: 3.1.0
> Reporter: Csaba Ringhofer
> Assignee: Thejas Nair
> Priority: Major
>
> The issue seems similar to HIVE-9720, but only happens with partitioned tables. I only tested with Hive 3.1 in Impala dev environment.
> The issue can be reproduced by the following statements (it doesn't matter whether Hive or Impala runs them with the exception of compute/show stats).
> {code}
> create database db1;
> create database db2;
> create table db1.t(i int) partitioned by (p int);
> insert into db1.t partition (p=1) values (2);
> compute stats db1.t; -- needs Impala
> alter table db1.t rename to db2.t;
> show column stats db2.t; -- needs Impala, null count and ndv will be incorrectly -1
> drop table db2.t; -- this will hang
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)