Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

SHOW CREATE AGGREGATE

The SHOW CREATE AGGREGATE command shows the function definition and other attributes for a user-defined aggregate function (UDAF).

Syntax

SHOW CREATE AGGREGATE function_name

Remarks

Example

The following example demonstrates how to execute a SHOW CREATE AGGREGATE statement for the avg_udaf UDAF defined in CREATE AGGREGATE.

SHOW CREATE AGGREGATE avg_udaf \G
*** 1. row ***
           Aggregate: avg_udaf
    Create Aggregate: CREATE OR REPLACE AGGREGATE `avg_udaf` (bigint(20) NULL) RETURNS bigint(20) NULL WITH STATE record(`s` bigint(20) NULL, `c` bigint(20) NULL) INITIALIZE WITH avg_init ITERATE WITH avg_iter MERGE WITH avg_merge TERMINATE WITH avg_terminate DEFINER = 'root'@'%';
character_set_client: utf8mb4
collation_connection: utf8mb4_bin
1 row in set (0.00 sec)

Related Topics

Last modified:

Was this article helpful?