THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
Hive Data Definition Language
Table of Contents |
---|
Create/Drop/Alter Database
Create Database
Code Block |
---|
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
Code Block |
---|
ALTER (DATABASE|SCHEMA) database_name SET DBPROPERTIES (property_name=property_value, ...);
|
No other metadata about a database can be changed.
Create/Drop/Truncate Table
...