Done: https://issues.apache.org/jira/browse/HIVE-12604
On Sat, Dec 5, 2015 at 8:14 AM, Sergey Shelukhin <ser...@hortonworks.com> wrote: > That looks like a bug in rename. Can you please file a JIRA? > > From: Toby Allsopp <toby.alls...@wherescape.com> > Reply-To: "user@hive.apache.org" <user@hive.apache.org> > Date: Thursday, December 3, 2015 at 18:24 > To: "user@hive.apache.org" <user@hive.apache.org> > Subject: Cannot drop a table after creating an index and then renaming to > a different database > > Hi, a sequence of commands should make things clearer. I'm using the > Hortonworks Sandbox VM with HDP 2.3. > > 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) > > Basically it looks like the rename to a different database left the index > table in the old database. > > Is this a known issue? Should I be dropping the indexes before renaming > tables to different databases? > > Cheers, > Toby. >
