Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Lists any existing user-defined aggregate functions (UDAF) in the specified database.
SHOW AGGREGATES [EXTENDED] [{FROM | IN} database_name] [LIKE pattern]
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.
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