- 创建数据库
CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name
[COMMENT database_comment]
[LOCATION hdfs_path]
[WITH DBPROPERTIES (property_name=property_value, ...)];
--案例
create database if not exists test
comment 'test'
location '/hive/test'
with dbproperties ('date'='20180514','creator'='hadoop');
- 删除数据库
DROP (DATABASE|SCHEMA