HPL/SQL is included to Apache Hive since version 2.0
DROP DATABASE statement allows you to drop a database.
DROP DATABASE | SCHEMA [IF EXISTS] dbname_expr
Drop a database named testYYYYMMDD (current date):
drop database if exists 'test' || replace(current_date, '-', '');
Version: HPL/SQL 0.3.17