AGGREGATE_FUNCTIONS

This view contains information about user defined aggregate functions (UDAF).

See further information about how to define aggregate functions in CREATE AGGREGATE.

Column Name	Description
`AGGREGATE_NAME`	The name of a given UDAF.
`AGGREGATE_SCHEMA`	The related schema for a given UDAF.
`NUM_PARAMETERS`	The number of parameters required for a given UDAF.
`STATE_TYPE`	The type of state for a given UDAF: `array`, `record`, or `scalar`.
`RETURN_TYPE`	The return type for a given UDAF.
`INITIALIZE_FUNCTION`	The name of the related user defined function (UDF) being executed as a the `INITIALIZE_FUNCTION` for a given UDAF.
`ITERATE_FUNCTION`	The name of the related user defined function (UDF) being executed as a the `ITERATE_FUNCTION` for a given UDAF.
`MERGE_FUNCTION`	The name of the related user defined function (UDF) being executed as a the `MERGE_FUNCTION` for a given UDAF.
`TERMINATE_FUNCTION`	The name of the related user defined function (UDF) being executed as a the `TERMINATE_FUNCTION` for a given UDAF.
`DEFINER`	The user who created a given UDAF.

Was this article helpful?