USER_LIBRARIES
Lists the user libraries that are currently loaded.
Lists the user libraries that are currently loaded. These libraries contain user-defined extensions (UDxs) that provide additional analytic functions.
Column Name | Data Type | Description |
---|---|---|
SCHEMA_NAME |
VARCHAR(8192) | The name of the schema containing the library. |
LIB_NAME |
VARCHAR(8192) | The name of the library. |
LIB_OID |
INTEGER | The object ID of the library. |
AUTHOR |
VARCHAR(8192) | The creator of the library file. |
OWNER_ID |
INTEGER | The object ID of the library's owner. |
LIB_FILE_NAME |
VARCHAR(8192) | The name of the shared library file. |
MD5_SUM |
VARCHAR(8192) |
The MD5 checksum of the library file, used to verify that the file was correctly copied to each node. NoteThis use of MD5 is not for cryptographic or authentication purposes. For information on authenticating with MD5 see Hash authentication. |
SDK_VERSION |
VARCHAR(8192) | The version of the Vertica SDK used to compile the library. |
REVISION |
VARCHAR(8192) | The revision of the Vertica SDK used to compile the library. |
LIB_BUILD_TAG |
VARCHAR(8192) | Internal information set by library developer to track the when the library was compiled. |
LIB_VERSION |
VARCHAR(8192) | The version of the library. |
LIB_SDK_VERSION |
VARCHAR(8192) | The version of the Vertica SDK intended for use with the library. The developer sets this value manually. This value may differ from the values in the SDK_VERSION and REVISION, which are set automatically during compilation. |
SOURCE_URL |
VARCHAR(8192) | A URL that contains information about the library. |
DESCRIPTION |
VARCHAR(8192) | A description of the library. |
LICENSES_REQUIRED |
VARCHAR(8192) | The licenses required to use the library. |
SIGNATURE |
VARCHAR(8192) | The signature used to sign the library for validation. |
DEPENDENCIES |
VARCHAR (8192) | External libraries on which this library depends. These libraries are maintained by Vertica, just like the user libraries themselves. |