hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Toby Allsopp <toby.alls...@wherescape.com>
Subject Re: Cannot drop a table after creating an index and then renaming to a different database
Date Sun, 06 Dec 2015 20:16:41 GMT
Done: https://issues.apache.org/jira/browse/HIVE-12604

On Sat, Dec 5, 2015 at 8:14 AM, Sergey Shelukhin <sergey@hortonworks.com>
wrote:

> That looks like a bug in rename. Can you please file a JIRA?
>
> From: Toby Allsopp <toby.allsopp@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.
>

Mime
View raw message