Hive Data Definition Language

Create/Drop/Alter Database

Create Database

CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name
  [COMMENT database_comment]
  [LOCATION hdfs_path]
  [WITH DBPROPERTIES (property_name=property_value, ...)];

...

The use of SCHEMA and DATABASE are interchangeable – they mean the same thing.

Alter Database

ALTER (DATABASE|SCHEMA) database_name SET DBPROPERTIES (property_name=property_value, ...);

No other metadata about a database can be changed.

Create/Drop/Truncate Table

...