DROP AGGREGATE

Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

Syntax

DROP AGGREGATE [IF EXISTS] { function_name | database_name.function_name }

Remarks

Only one function can be removed using the DROP AGGREGATE command.

If DROP AGGREGATE is executed for a function that does not exist, the following error will occur:

SQL

DROP AGGREGATE myaggregate;

ERROR 2219 (HY000): Function 'db1.myaggregate' doesn't exist

However, if the IF EXISTS clause is used and the function does not exist, no error will occur:

SQL

DROP AGGREGATE IF EXISTS myaggregate;

Query OK, 0 rows affected (0.00 sec)

This command causes implicit commits. Refer to COMMIT for more information.

Examples

Dropping a Function in the Current Database

The following example removes an existing function from the current database.

SQL

SHOW AGGREGATES;

+-------------------+
| Aggregates_in_db1 |
+-------------------+
| multiply_hundred  |
| myaggregate       |
+-------------------+
2 rows in set (0.00 sec)

SQL

DROP AGGREGATE myaggregate;

Query OK, 0 rows affected (0.05 sec)

SQL

SHOW AGGREGATES;

+-------------------+
| Aggregates_in_db1 |
+-------------------+
| multiply_hundred  |
+-------------------+
1 row in set (0.00 sec)

Dropping a Function in Another Database

The following example removes an existing function while connected to another database in your SingleStore cluster.

SQL

USE db1;

SHOW AGGREGATES;

+-------------------+
| Aggregates_in_db1 |
+-------------------+
| multiply_hundred  |
| myaggregate       |
+-------------------+
2 rows in set (0.00 sec)

SQL

USE db2;

DROP AGGREGATE db1.myaggregate;

Query OK, 0 rows affected (0.05 sec)

SQL

USE db1;

SHOW AGGREGATES;

+-------------------+
| Aggregates_in_db1 |
+-------------------+
| multiply_hundred  |
+-------------------+
1 row in set (0.00 sec)