Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # dev >> Review Request 14996: HIVE-5664: Drop cascade database fails when the db has any tables with indexes


Copy link to this message
-
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