PREHOOK: query: SHOW DATABASES PREHOOK: type: SHOWDATABASES POSTHOOK: query: SHOW DATABASES POSTHOOK: type: SHOWDATABASES default PREHOOK: query: -- Try to drop a non-empty database in restrict mode CREATE DATABASE db_drop_non_empty_restrict PREHOOK: type: CREATEDATABASE PREHOOK: Output: database:db_drop_non_empty_restrict POSTHOOK: query: -- Try to drop a non-empty database in restrict mode CREATE DATABASE db_drop_non_empty_restrict POSTHOOK: type: CREATEDATABASE POSTHOOK: Output: database:db_drop_non_empty_restrict PREHOOK: query: USE db_drop_non_empty_restrict PREHOOK: type: SWITCHDATABASE PREHOOK: Input: database:db_drop_non_empty_restrict POSTHOOK: query: USE db_drop_non_empty_restrict POSTHOOK: type: SWITCHDATABASE POSTHOOK: Input: database:db_drop_non_empty_restrict PREHOOK: query: CREATE TABLE t(a INT) PREHOOK: type: CREATETABLE PREHOOK: Output: database:db_drop_non_empty_restrict PREHOOK: Output: db_drop_non_empty_restrict@t POSTHOOK: query: CREATE TABLE t(a INT) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:db_drop_non_empty_restrict POSTHOOK: Output: db_drop_non_empty_restrict@t PREHOOK: query: USE default PREHOOK: type: SWITCHDATABASE PREHOOK: Input: database:default POSTHOOK: query: USE default POSTHOOK: type: SWITCHDATABASE POSTHOOK: Input: database:default PREHOOK: query: DROP DATABASE db_drop_non_empty_restrict PREHOOK: type: DROPDATABASE PREHOOK: Input: database:db_drop_non_empty_restrict PREHOOK: Output: database:db_drop_non_empty_restrict FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. InvalidOperationException(message:Database db_drop_non_empty_restrict is not empty. One or more tables exist.)