Kaspersky Unified Monitoring and Analysis Platform

Supported ClickHouse functions

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.