Functions, aggregates, and user types
Query system_schema
functions,
aggregates,
and types
tables to get information about user-defined functions (UDFs), user-defined aggregates (UDAs), and user-defined types (UDTs).
-
Show one user-defined function in the
system_schema.functions
table.EXPAND ON SELECT * FROM system_schema.functions LIMIT 1; EXPAND OFF;
Results
The following output shows the first record using the cqlsh EXPAND ON option.
EXPAND set to ON keyspace_name | function_name | argument_types | argument_names | body | called_on_null_input | language | return_type ---------------+---------------+----------------+----------------+------+----------------------+----------+------------- (0 rows) EXPAND set to OFF
-
List the schema settings for one user-defined aggregate.
EXPAND ON SELECT * FROM system_schema.aggregates LIMIT 1; EXPAND OFF;
Results
EXPAND set to ON keyspace_name | aggregate_name | argument_types | final_func | initcond | return_type | state_func | state_type ---------------+----------------+----------------+------------+----------+-------------+------------+------------ (0 rows) EXPAND set to OFF
-
Show the schema settings for one user-defined type.
EXPAND ON SELECT * FROM system_schema.types LIMIT 1; EXPAND OFF;
Results
EXPAND set to ON keyspace_name | type_name | field_names | field_types ---------------+-----------+-------------+------------- (0 rows) EXPAND set to OFF