Create Database

CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] db_name
  [COMMENT comment_text]
  [LOCATION path]
  [WITH DBPROPERTIES (key=val, ...)]

Create a database. If a database with the same name already exists, an exception will be thrown.

IF NOT EXISTS

If a database with the same name already exists, nothing will happen.

LOCATION

If the specified path does not already exist in the underlying file system, this command tries to create a directory with the path.

WITH DBPROPERTIES

Specify a property named key for the database and establish the value for the property respectively as val. If key already exists, the old value is overwritten with val.