User-defined functions (UDFs) and user-defined aggregates (UDAs) overview
Users can create user-defined functions (UDFs) and user-defined aggregate functions (UDAs). Functions are used to manipulate stored data in queries. Retrieving results using standard aggregate functions are also available for queries.
- Creating a user-defined function (UDF)
-
Write custom functions using Java or JavaScript to use in SELECT, INSERT, and UPDATE statements.
- Checking a user-defined function (UDF)
-
Check existence of UDF.
- Dropping a user-defined function (UDF)
-
Use the DROP FUNCTION command to drop a UDF.
- Creating a user-defined aggregate function (UDA)
-
User-Defined Aggregates (UDAs) can be used to manipulate stored data across rows of data, returning a result that is further manipulated by a final function.
- Checking a user-defined aggregate (UDA)
-
Check existence of UDA.
- Dropping a user-defined aggregate (UDA)
-
Use the DROP AGGREGATE command to drop a UDA.