# AGGREGATE\_FUNCTIONS

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

See further information about how to define aggregate functions in [CREATE AGGREGATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/create-aggregate.md).

| 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.                                                                                |

***

Modified at: August 29, 2022

Source: [/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/aggregate-functions/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/aggregate-functions/)

(An index of the documentation is available at /llms.txt)