Notes on Individual UDx Types

Some UDx types have special considerations or restrictions.

Analytic Functions

UDAnFs do not support framing windows using ROWS.

As with Vertica's built-in analytic functions, UDAnFs cannot be used with Pattern Matching Functions.

Transform Functions

A query that includes a UDTF cannot contain:

Load

Installing an untrusted UDL function can compromise the security of the server. UDx's can contain arbitrary code. In particular, UD Source functions can read data from any arbitrary location. It is up to the developer of the function to enforce proper security limitations. Superusers must not grant access to UDxs to untrusted users.

You cannot ALTER UDL functions.