CREATE DATABASE/SCHEMA ​

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.

Syntax ​

bash
CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name;

<database_name> ​

The full name of the database/schema you want to create

Output ​

This SQL command does not return anything.