Hi: There are some databases named cloudera_manager_metastore_canary_test_db_hive_hivemetastore_47eeceae20c69acc3391e93ce56ee1cc_* in my hive . When I use drop databases to delete them,Some of them are deleted,but Others can't.
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. InvalidOperationException(message:Database cloudera_manager_metastore_canary_test_db_hive_hivemetastore_47eeceae20c69acc3391e93ce56ee1cc_2014_09_11_18_28_21 is not empty) So I try to drop table in this Database FAILED: SemanticException [Error 10001]: Table not found cm_test_table How to drop this Databases?