USER MANUALS

VALIDATE_MPP_LICENSE

Description

Since the update 8.0u20230301, Denodo includes embedded Massively Parallel Processing (MPP) capabilities to improve performance on environments containing data in an object storage. For this purpose Denodo now embeds a customized version of Presto, which is an open source parallel SQL query engine that excels in accessing data lake content. The Denodo Embedded MPP cluster can be deployed following the instructions in the Presto cluster on Kubernetes user manual.

The number of CPU cores for the MPP cluster can be limited by the Denodo license (see Denodo Platform - Subscription Bundles for more information).

The stored procedure VALIDATE_MPP_LICENSE returns information about the validation of the mpp license.

Syntax

VALIDATE_MPP_LICENSE()

The procedure returns one row per license, with the following fields:

  • max_processors: max mpp processors allowed.

  • current_processors: number of mpp processors found. Returns -1 if there was an error.

  • status: an integer corresponding to a status.

    • 0: the validation was successful and the number of processors of the MPP are under the limit.

    • -1: the validation was successful and the number of processors of the MPP is over the limit.

    • -2: Unknown error.

    • -3: the validation was not successful because there is no MPP configured.

    • -4: the validation was not successful because some necessary metadata is missing.

    • -5: the validation was not successful because it could not connect to the MPP.

  • details: a string with a message providing more information.

Privileges Required

No privileges are required to execute this procedure.

Example

CALL VALIDATE_MPP_LICENSE()

Let us say that the validation was successful and the number of processors of the MPP are under the limit. The result will be this:

max_processors

current_processors

status

details

16

8

0

the validation was successful and the number of processors of the MPP are under the limit.

Add feedback