VALIDATE_MPP_LICENSE¶

Description

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 Embedded MPP Guide.

The Denodo Embedded MPP requires the subscription bundle Enterprise Plus. In addition, 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: If the license is Enterprise Plus it returns the maximum number of MPP processors allowed. Otherwise it returns -1.

• 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: