REGISTER_EMBEDDED_MPP¶

Description

The stored procedure REGISTER_EMBEDDED_MPP executes all required commands to register and load the Denodo Embedded MPP metadata in Denodo Virtual DataPort.

Syntax

REGISTER_EMBEDDED_MPP (
    num_workers : numeric,
    cpus_per_node : numeric,
    user_denodo_connector : text,
    password_denodo_connector : text,
    encrypted_password_denodo_connector : text,
    use_role : boolean
    role_denodo_connector : text,
    presto_password : text,
    encrypted_presto_password : text,
    presto_host : text,
    presto_port : numeric,
    presto_catalog : text,
    infrastructure_provider : text,
    infrastructure_region : text,
    keep_existing_storage_configuration : boolean
)

• num_workers: (optional) number of Presto workers in the cluster. The value must be a positive integer. Otherwise, the procedure will return an error. Default value: 4

• cpus_per_node: (optional) number of cores assigned to each worker. The value must be a positive integer. Otherwise, the procedure will return an error. Default value: 16

• user_denodo_connector: (optional) Denodo user. Default value: denodo_mpp_user

• password_denodo_connector: (optional) Denodo password, must be compliant with Denodo password policies.

• encrypted_password_denodo_connector: (optional) Denodo encrypted password.

• use_role: (optional) property to enable using ROLE during registration instead of creating a new USER. If you are using AGORA you must set this property to true. Default value: false

• role_denodo_connector: (optional) Denodo role. Default value: embedded_mpp_role

• presto_password: (optional) Presto password for the connection user.

• encrypted_presto_password: (optional) Presto encrypted password for the connection user.

• presto_host: host where Presto server is located.

• presto_port: (optional) Presto coordinator HTTPS endpoint port. Some environments do not require value for this parameter, like i.e. in deployments with Kubernetes Ingress.

• presto_catalog: (optional) Catalog used when connecting to Presto. Default value: hive

• infrastructure_provider: (optional) name of the infrastructure provider (On-premises, AWS, Azure, Google Cloud, Alibaba, etc.) where the client and Virtual DataPort server is running.

• infrastructure_region: (optional) name of the infrastructure provider region where the client and Virtual DataPort server are running.

• keep_existing_storage_configuration: (optional) if true, preserves the current external data configuration of the embedded mpp datasource. Default value: true.

This stored procedure returns one row for each command executed, with the following schema:

• command: VQL query executed.

• status: the status of the query executed, OK if finished correctly or ERROR if the operation failed.

• details: message explaining the error if there is any, null otherwise.

Privileges Required

Only administrator users with assignprivileges role are able to execute this procedure.

Example

select * from register_embedded_mpp()
where
num_workers = 4 and
cpus_per_node = 16 and
user_denodo_connector = 'denodo_mpp_user' and
password_denodo_connector = null and
encrypted_password_denodo_connector = null and
use_role = true and
role_denodo_connector = 'embedded_mpp_role' and
presto_password = 'presto_local_password' and
encrypted_presto_password = null and
presto_host = 'localhost' and
presto_port = 8080 and
presto_catalog = 'hive' and
infrastructure_provider = null and
infrastructure_region = null and
keep_existing_storage_configuration = true;