You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by Venki Korukanti <ve...@gmail.com> on 2013/10/28 19:42:28 UTC

Review Request 14996: HIVE-5664: Drop cascade database fails when the db has any tables with indexes

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/14996/
-----------------------------------------------------------

Review request for hive and Prasad Mujumdar.


Repository: hive-git


Description
-------

Repro steps:
CREATE DATABASE db2; 
USE db2; 
CREATE TABLE tab1 (id int, name string); 
CREATE INDEX idx1 ON TABLE tab1(id) as 'COMPACT' with DEFERRED REBUILD IN TABLE tab1_indx; 
DROP DATABASE db2 CASCADE;

Last DDL fails with following error:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Database does not exist: db2

See JIRA for details on the exception.


Diffs
-----

  metastore/src/java/org/apache/hadoop/hive/metastore/HiveMetaStoreClient.java 65406d9 
  ql/src/test/queries/clientpositive/database_drop.q 4e17c7a 
  ql/src/test/results/clientpositive/database_drop.q.out 6c4440f 

Diff: https://reviews.apache.org/r/14996/diff/


Testing
-------

Added this particular index to database_drop.q unittest.


Thanks,

Venki Korukanti