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:
- Any statements other than the SELECT statement containing the call to the UDTF and a PARTITION BY expression
- Any other analytic function
- A call to another UDTF
- A TIMESERIES clause
- A pattern matching clause
- A gap filling and interpolation clause
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.