Functions, aggregates, and user types
Query system_schema functions, aggregates, and types tables to get information about user-defined functions, user-defined aggregates, and user-defined 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).
Procedure
-
Show all user-defined functions in the
system.schema_functions table.
SELECT * FROM system_schema.functions;
The following shows the first record using cqlsh EXPAND ON option.@ Row 1 ----------------------+--------------------------------------------------------------- keyspace_name | cycling function_name | avgfinal argument_types | ['frozen<tuple<int, bigint>>'] argument_names | ['state'] body | double r = 0;\n if (state.getInt(0) == 0) return null;\n r = state.getLong(1);\n r/= state.getInt(0);\n return Double.valueOf(r); called_on_null_input | True deterministic | False language | java monotonic | False monotonic_on | [] return_type | double ...
-
List the schema settings for all user-defined aggregates.
SELECT * FROM system_schema.aggregates;
@ Row 1 ----------------+---------------------------- keyspace_name | cycling aggregate_name | average argument_types | ['int'] deterministic | False final_func | avgfinal initcond | (0, 0) return_type | double state_func | avgstate state_type | frozen<tuple<int, bigint>> (1 rows)
-
Show the schema settings for all the user-defined types.
SELECT * FROM system_schema.types;
@ Row 1 ---------------+------------------------------------------------- keyspace_name | cycling type_name | basic_info field_names | ['birthday', 'nationality', 'weight', 'height'] field_types | ['timestamp', 'text', 'text', 'text'] ...