Toby Allsopp created HIVE-12604:
-----------------------------------
Summary: Cannot drop a table after creating an index and then
renaming to a different database
Key: HIVE-12604
URL: https://issues.apache.org/jira/browse/HIVE-12604
Project: Hive
Issue Type: Bug
Affects Versions: 1.2.1
Environment: Hortonworks Sandbox VM with HDP 2.3
Reporter: Toby Allsopp
Priority: Minor
{noformat}
Connected to: Apache Hive (version 1.2.1.2.3.0.0-2557)
Driver: Hive JDBC (version 1.2.1.2.3.0.0-2557)
0: jdbc:hive2://localhost:10000> create database db1;
No rows affected (0.997 seconds)
0: jdbc:hive2://localhost:10000> create database db2;
No rows affected (0.968 seconds)
0: jdbc:hive2://localhost:10000> create table db1.test (col1 int);
No rows affected (1.758 seconds)
0: jdbc:hive2://localhost:10000> create index idx1 on table db1.test(col1) as
'compact' with deferred rebuild;
No rows affected (0.287 seconds)
0: jdbc:hive2://localhost:10000> alter index idx1 on db1.test rebuild;
INFO : Tez session hasn't been created yet. Opening session
INFO :
INFO : Status: Running (Executing on YARN cluster with App id
application_1449025977131_0007)
INFO : Map 1: -/- Reducer 2: 0/1
INFO : Map 1: -/- Reducer 2: 0(+1)/1
INFO : Map 1: -/- Reducer 2: 0/1
INFO : Map 1: -/- Reducer 2: 1/1
INFO : Loading data to table db1.db1__test_idx1__ from
hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/db1.db/b1__test_idx1__/.hive-staging_hive_2015-12-04_02-02-47_278_3621654884902999047-10/-ext-10000
INFO : Table db1.db1__test_idx1__ stats: [numFiles=1, numRows=0, totalSize=0,
rawDataSize=0]
No rows affected (7.792 seconds)
0: jdbc:hive2://localhost:10000> alter table db1.test rename to db2.test;
No rows affected (0.261 seconds)
0: jdbc:hive2://localhost:10000> drop table db2.test;
Error: Error while processing statement: FAILED: Execution Error, return code 1
from org.apache.hadoop.hive.ql.exec.DDLask.
MetaException(message:db2.db1__test_idx1__ table not found) (state=08S01,code=1)
{noformat}
Basically it looks like the rename to a different database left the index table
in the old database.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
