Skip to main content

functions

Contains information about normal and aggregate functions.

Columns:

  • name (String) – The name of the function.
  • is_aggregate (UInt8) — Whether the function is an aggregate function.
  • is_deterministic (Nullable(UInt8)) - Whether the function is deterministic.
  • case_insensitive, (UInt8) - Whether the function name can be used case-insensitively.
  • alias_to, (String) - The original function name, if the function name is an alias.
  • create_query, (String) - Unused.
  • origin, (Enum8) - Unused.
  • description, (String) - A high-level description what the function does.
  • syntax, (String) - Signature of the function.
  • arguments, (String) - What arguments does the function take.
  • returned_value, (String) - What does the function return.
  • examples, (String) - Example usage of the function.
  • categories, (String) - The category of the function.

Example

 SELECT name, is_aggregate, is_deterministic, case_insensitive, alias_to FROM system.functions LIMIT 5;
┌─name─────────────────────┬─is_aggregate─┬─is_deterministic─┬─case_insensitive─┬─alias_to─┐
│ BLAKE3 │ 0 │ 1 │ 0 │ │
│ sipHash128Reference │ 0 │ 1 │ 0 │ │
│ mapExtractKeyLike │ 0 │ 1 │ 0 │ │
│ sipHash128ReferenceKeyed │ 0 │ 1 │ 0 │ │
│ mapPartialSort │ 0 │ 1 │ 0 │ │
└──────────────────────────┴──────────────┴──────────────────┴──────────────────┴──────────┘

5 rows in set. Elapsed: 0.002 sec.