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

syntax

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

<database_name>

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


Output

This SQL command does not return anything.