CREATE SCHEMA¶

Create a schema from a schema template.

Syntax¶

Parameters¶

pathToSchema: The fully-qualified path to the SCHEMA in a DATABASE
schemaTemplateName: The name of the schema template to be used to create this schema

Example¶

-- Create a schema template
CREATE SCHEMA TEMPLATE TEMP
    CREATE TABLE T (A BIGINT NULL, B DOUBLE NOT NULL, C STRING, PRIMARY KEY(A, B))

-- Create database in domain '/FRL/'
CREATE DATABASE '/FRL/DEMO_DB'

-- Create a schema in the database from TEMP
CREATE SCHEMA 'FRL/DEMO_DB/DEMO_SCHEMA' WITH TEMP