LICENSES

For all licenses, provides information on license types, the dates for which licenses are valid, and the limits the licenses impose.

Column Name Data Type Description
LICENSE_ID

INTEGER

Unique numeric ID assigned by the Vertica catalog, which identifies the license.

NAME

VARCHAR

The license’s name. (The license name in this column could be represented by a long license key.)

LICENSEE

VARCHAR

The entity to which the product is licensed.

START_DATE

VARCHAR

The start date for which the license is valid.

END_DATE

VARCHAR

The end date until which the license is valid (or "Perpetual" if the license has no expiration).

LICENSETYPE

VARCHAR

The type of the license (for example, Premium Edition).

PARENT

VARCHAR

The parent license (field is blank if there is no parent).

SIZE

VARCHAR

The size limit for data on the license.

IS_SIZE_LIMIT_ENFORCED

BOOLEAN

Indicates whether the license includes enforcement of data and node limits, where t is true and f is false.

NODE_RESTRICTION

VARCHAR

The node limit the license imposes.

CONFIGURED_ID

INTEGER

A long license key.