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.

  • Refer to 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

Last modified: May 22, 2023

Was this article helpful?