Skip to main content
Skip table of contents

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

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.