DROP AGGREGATE
Deletes a user-defined aggregate (UDA) from a keyspace.
Synopsis
DROP AGGREGATE [ IF EXISTS ] [<keyspace_name>.]<aggregate_name> [ (<argument_type> [ , ... ]) ] ;
| Syntax conventions | Description |
|---|---|
UPPERCASE |
Literal keyword. |
Lowercase |
Not literal. |
|
Variable value. Replace with a user-defined value. |
|
Optional.
Square brackets ( |
|
Group.
Parentheses ( |
|
Or.
A vertical bar ( |
|
Repeatable.
An ellipsis ( |
|
Single quotation ( |
|
Map collection.
Braces ( |
|
Set, list, map, or tuple.
Angle brackets ( |
|
End CQL statement.
A semicolon ( |
|
Separate the command line options from the command arguments with two hyphens ( |
|
Search CQL only: Single quotation marks ( |
|
Search CQL only: Identify the entity and literal value to overwrite the XML element in the schema and solrConfig files. |
Options
- IF EXISTS
-
Optional. Drop the aggregate if it exists, or silently do nothing if the named aggregate doesn’t exist in the keyspace. Otherwise, an error is returned if the aggregate doesn’t exist.
- keyspace_name
-
The name of the keyspace containing the aggregate. If not specified, the current keyspace is used.
- aggregate_name
-
The name of the aggregate to drop.
- argument_type
-
Argument type of the aggregate to drop, such as
intortext. Required if you have multiple aggregates with the same name.
Examples
Drop the average aggregate from the cycling keyspace:
DROP AGGREGATE IF EXISTS cycling.average;