CREATE DATABASE/SCHEMA allows you to creates a new database.
In Indexima, a database is both:
- A logical construct used to group related tables and views together, within their own namespace. You might want to use a separate database for each application, set of related tables, or run a round of experimentation.
- A physical construct represented by a directory tree in the warehouse. Tables are all located under this directory. You can perform HDFS-level operations such as backing up your database, measuring space usage, or remove you database with a DROP DATABASE statement.
CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name;
The full name of the database/schema you want to create
This SQL command does not return anything.