SHOW AGGREGATES
Lists any existing user-defined aggregate functions (UDAF) in the specified database.
Syntax
SHOW AGGREGATES [EXTENDED] [{FROM | IN} database_name] [LIKE pattern]
Remarks
You can use
SHOW AGGREGATES EXTENDED
to see detailed information about each UDAF in the specified database, including each of the UDFs that are executed for each step in the UDAF function body.See the Permission Matrix for the required permission.
Examples
SHOW AGGREGATES in a Database
The following example lists each UDAF function in the target database.
SHOW AGGREGATES in db1; **** +-------------------+ | Aggregates_in_db1 | +-------------------+ | myaggregate | +-------------------+ 1 row in set (0.00 sec)
SHOW AGGREGATES EXTENDED
The following example shows detailed information about each UDAF in the current database.
SHOW AGGREGATES EXTENDED \G; **** *************************** 1. row *************************** Aggregates_in_db1: multiply_hundred Definer: root@localhost Argument type(s): bigint(20) NULL State type: bigint(20) NULL Return type: bigint(20) NULL Initialize with: multiply_hundred_init Iterate with: multiply_hundred_iter Merge with: multiply_hundred_merge Terminate with: multiply_hundred_terminate 1 row in set (0.00 sec)
SHOW AGGREGATES LIKE
The following example demonstrates how to find a specific UDAF in the target database.
SHOW AGGREGATES LIKE 'multiply%'; **** +-------------------------------+ | Aggregates_in_db1 (multiply%) | +-------------------------------+ | multiply_hundred | +-------------------------------+ 1 row in set (0.00 sec)
Related Topics