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.

Last modified: August 29, 2022

Was this article helpful?