DROP DATABASE Statement
Removes a database from the system, and deletes the corresponding *.db directory from HDFS. The database must be empty before it can be dropped, to avoid losing any data.
DROP (DATABASE|SCHEMA) [IF EXISTS] database_name;
Statement type: DDL
Before dropping a database, use a combination of DROP TABLE, DROP VIEW, ALTER TABLE, and ALTER VIEW statements, to drop all the tables and views in the database or move them to other databases.
When you drop a database in Impala, the database can no longer be used by Hive.
See CREATE DATABASE Statement for examples covering CREATE DATABASE, USE, and DROP DATABASE.
Cancellation: Cannot be cancelled.
The user ID that the impalad daemon runs under, typically the impala user, must have write permission for the directory associated with the database.