User Defined Functions (UDFs)

Kinetica provides support for User-Defined Function (UDF) creation and management in SQL. Unlike conventional UDFs, Kinetica UDFs are external programs that can be managed via SQL and may run in distributed fashion across the cluster. A UDF that is defined to return a specific table type is known as a User-Defined Table Function (UDTF), which can be used within a SELECT statement to return the output of the function as a query result set. Package management for Python UDFs is available via the UDF environment feature. For UDF/UDTF execute permission management, see:

GRANT Function (UDF/UDTF) Permission
REVOKE Function (UDF/UDTF) Permission

Functions

CREATE FUNCTION
Executing Functions
DROP FUNCTION
SHOW FUNCTION
SHOW FUNCTION STATUS
DESCRIBE FUNCTION

Environments

CREATE FUNCTION ENVIRONMENT
ALTER FUNCTION ENVIRONMENT
DROP FUNCTION ENVIRONMENT
SHOW FUNCTION ENVIRONMENT
DESCRIBE FUNCTION ENVIRONMENT