Kaspersky Unified Monitoring and Analysis Platform

Supported ClickHouse functions

April 8, 2024

ID 235093

The following ClickHouse functions are supported in KUMA:

  • Arithmetic functions.
  • Arrays.
  • Comparison functions.
  • Logical functions.
  • Type conversion functions.
  • Date and time functions.
  • String functions.
  • String search functions.
  • Conditional functions: only the regular 'if' operator; the ternary operator is not supported.
  • Mathematical functions.
  • Rounding functions.
  • Functions for splitting and merging strings and arrays.
  • Bit functions.
  • Functions for working with UUIDs.
  • Functions for working with URLs.
  • Functions for working with IP addresses.
  • Functions for working with Nullable arguments.
  • Functions for working with geographic coordinates.

Functions from other sections are not supported.

For more details on SQL, refer to the ClickHouse documentation.

Did you find this article helpful?
What can we do better?
Thank you for your feedback! You're helping us improve.
Thank you for your feedback! You're helping us improve.