CREATE_SCHEMA_ON_SOURCE¶

Description

The stored procedure CREATE_SCHEMA_ON_SOURCE creates a new schema on the specified data source.

If you want to drop a created schema, check the procedure DROP_SCHEMA_ON_SOURCE.

Syntax

CREATE_SCHEMA_ON_SOURCE (
      database_name : varchar
    , datasource_name : varchar
    , catalog : varchar
    , schema : varchar
    , location : varchar
)

Note

Currently, this feature is only supported for the Denodo Embedded MPP data source and PrestoDB data sources.

The procedure returns this field:

procedure_status: Success if the procedure executed correctly, Failure otherwise.

Privileges Required

The user that executes this procedure must have at least WRITE and EXECUTE privileges on the targeted data source.

Example

CALL CREATE_SCHEMA_ON_SOURCE('admin_denodo_mpp', 'admin_denodo_mpp', 'hive', 'test',
'hdfs://hdfshost:8020/user/hive/warehouse/target.db/');

Creates the schema test on the catalog hive of the data source admin_denodo_mpp pointing to the provided HDFS uri.

USER MANUALS

CREATE_SCHEMA_ON_SOURCE¶