ALTER LIBRARY

Replaces the library file (C++ .so file, Java JAR file, or R source file) associated with a UDx library defined in the Vertica catalog. Vertica automatically distributes the new file throughout the cluster. See Developing User-Defined Extensions (UDxs) in Extending Vertica for details. The UDxs defined in the catalog that reference the library automatically begin using the new library file.

Syntax

ALTER LIBRARY [schema.]library‑name  [DEPENDS 'support‑path'] AS 'library‑path';

Parameters

schema

Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example:

myschema.thisDbObject
library‑name

The library to alter. You can only alter an existing library.

[DEPENDS 'support‑path']

Indicates that the UDx library depends on one or more support libraries. Valid values: One or more absolute paths to the support libraries files, located in the initiator node's filesystem. Separate multiple paths with colons (:). Specify a directory containing multiple libraries using an asterisk wildcard (*). For example: '/home/mydir/mylibs/*'.

library‑path

The absolute path in the initiator node's filesystem to the replacement library file.

Privileges

Superuser

Usage Considerations

Examples

This example shows how to update an already-defined library myFunctions with a new file.

=> ALTER LIBRARY myFunctions AS '/home/dbadmin/my_new_functions.so';