CREATE SCHEMA
CREATE SCHEMA adds a namespace for tables to a datastore.
Example
Section titled “Example”CREATE SCHEMA analytics;CREATE TABLE analytics.events (id BIGINT, region VARCHAR);Syntax
Section titled “Syntax”CREATE SCHEMA [IF NOT EXISTS] [datastore.]schema;Parameters
Section titled “Parameters”schema is the new namespace. Qualify it with a configured datastore name to
create it there; otherwise Pivot uses the default datastore.
IF NOT EXISTS leaves an existing schema in place.
Additional example
Section titled “Additional example”Given a datastore named lake:
CREATE SCHEMA IF NOT EXISTS lake.analytics;Limitations
Section titled “Limitations”CREATE OR REPLACE SCHEMA is not supported.