Checking a user-defined aggregate (UDA)
In cqlsh, the DESCRIBE AGGREGATE
command outputs the full details of a user-defined aggregate.
Use the output from the DESCRIBE command to recreate the UDA.
This command requires a keyspace. Ideally you have also created an aggregate, but it isn’t required.
Verify that a UDA exists:
DESCRIBE AGGREGATE cycling.average;The response is the CREATE FUNCTION command that was used to create the function if it exists.
Otherwise, the response indicates that the function doesn’t exist.
CREATE AGGREGATE cycling.average(int)
SFUNC average_state
STYPE tuple<int, bigint>
FINALFUNC average_final
INITCOND (0, 0);
CREATE AGGREGATE cycling.average(int)
SFUNC average_state
STYPE tuple<int, bigint>
FINALFUNC average_final
INITCOND (0, 0);