system.functions

Contains information about normal and aggregate functions.

Columns:

  • name(String) – The name of the function.
  • is_aggregate(UInt8) — Whether the function is aggregate.

Example

  1. SELECT * FROM system.functions LIMIT 10;
  1. ┌─name─────────────────────┬─is_aggregate─┬─case_insensitive─┬─alias_to─┐
  2. sumburConsistentHash 0 0
  3. yandexConsistentHash 0 0
  4. demangle 0 0
  5. addressToLine 0 0
  6. JSONExtractRaw 0 0
  7. JSONExtractKeysAndValues 0 0
  8. JSONExtract 0 0
  9. JSONExtractString 0 0
  10. JSONExtractFloat 0 0
  11. JSONExtractInt 0 0
  12. └──────────────────────────┴──────────────┴──────────────────┴──────────┘
  13. 10 rows in set. Elapsed: 0.002 sec.