Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Functions list

The following table lists all available XQL functions:

Function
Description

Calculate the inverse cosine (arccosine) of a numerical expression

Calculate the inverse hyperbolic cosine of a numeric value

Calculate the sum of two numbers

Return an approximate count of distinct values

Return approximate quantile boundaries

Return the approximate top values

Calculate the inverse sine (arcsine) of a numerical expression

Calculate the inverse hyperbolic sine of a numeric value

Calculate the inverse tangent of a numeric value

Calculate the angle from two numeric coordinates

Calculate the inverse hyperbolic tangent of a numeric value

Check if all elements in an array match a condition

Check if any element in an array matches a condition

Return the number of elements in an array

Concatenate two arrays

Create an array from a list of values

Return an array with duplicate values removed

Filter elements of an array based on a condition

Return the element at a specified index in an array

Return the index of a value in an array

Apply a function to each element of an array

Merge multiple arrays into one

Create an array of sequential integers

Convert an array to a string

Calculate the average value using the comp stage

Calculate the average value using the windowcomp stage

Perform a bitwise AND operation between two integer values

Perform a bitwise OR operation between two integer values

Perform a bitwise left shift operation on an integer value

Perform a bitwise right shift operation on an integer value

Perform a bitwise exclusive OR (XOR) operation between two integer values

Calculate the cube root of a numeric value

Round a number up to the nearest integer

Return the first non-null value from a list

Concatenate two or more strings

Decode a Base64-encoded string

Encode a string to Base64

Calculate the cosine of a numeric value specified in radians

Calculate the hyperbolic cosine of a numeric value

Calculate the cosine distance between two numeric vectors

Calculate the cotangent of a numeric value specified in radians

Calculate the hyperbolic cotangent of a numeric value

Count values using the comp stage

Count values using the windowcomp stage

Count distinct values

Calculate the cosecant of a numeric value specified in radians

Calculate the hyperbolic cosecant of a numeric value

Return the current timestamp

Round a timestamp down to a specified time unit

Divide one number by another

Return the earliest timestamp value

Calculate the Euclidean distance between two numeric vectors

Calculate the value of e raised to the power of a numeric value

Extract a time component from a timestamp

Extract the host from a URL

Extract the public suffix from a URL

Extract the registered domain from a URL

Return the first value in a group

Return the first value in a window

Round a number down to the nearest integer

Format a string using a template

Format a timestamp as a string

Return the largest value from a list of expressions

Check whether an asset belongs to an organizational hierarchy node

Return one of two values based on a condition

Check if an IPv4 address is within a CIDR range

Check if an IPv6 address is within a CIDR range

Check if an IP address is within a list of CIDR ranges

Convert an integer to an IP address string

Convert an IP address string to an integer

Check if a value is a valid IPv4 address

Check if a value is a valid IPv6 address

Check if an IPv4 address is a known private address

Check if an IPv6 address is a known private address

Return whether an SLA has breached its goal

Extract a value from a JSON string

Extract an array from a JSON string

Extract a scalar value from a JSON string

Extract a scalar array from a JSON string

Extract a value from a JSON string using a JSONPath expression

json_functions_reference

Decide which JSON functions to use

Return the value of a field from a previous row in a window

Return the last value in a group

Return the last value in a window

Return the latest timestamp value

Return the smallest value from a list of expressions

Return the length of a string or array

Collect all values of a field and return them as an array within the comp stage

Calculate the natural logarithm (base e) of a numeric value

Calculate the logarithm of a numeric value with a specified base

Calculate the base-10 logarithm of a numeric value

Convert a string to lowercase

Remove leading whitespace from a string

Return the maximum value of a field within the comp stage

Compute the maximum value of a field over a window of rows within the windowcomp stage

Return the value associated with the maximum value in a group

Calculate the MD5 hash of a string

Return the median value of a numeric field within the comp stage

Compute the median value of a numeric field over a window of rows within the windowcomp stage

Return the minimum value of a field within the comp stage

Compute the minimum value of a field over a window of rows within the windowcomp stage

Return the value associated with the minimum value in a group

Calculate the remainder (modulus) of the division of two numeric values

Multiply two numbers

Create a JSON object from key-value pairs

Merge two JSON objects

Parse an epoch timestamp

Parse a timestamp string

Raise a number to a power

Raise a number to the power of another number (alias for pow)

Generate a pseudo-random floating-point number between 0 and 1

Determine which bucket a numeric value falls into given an array of boundaries

Assign a rank to each row within a partition in the windowcomp stage

Extract substrings using a regular expression

Extract a substring from a field value using a regular expression pattern

Replace occurrences of a substring

Replace substrings using a regular expression

Round a number to a specified number of decimal places

Assign a unique sequential integer to each row within a partition in the windowcomp stage

Remove trailing whitespace from a string

Perform addition with overflow protection, returning null on overflow

Perform division with error protection, returning null on division by zero

Perform multiplication with overflow protection, returning null on overflow

Negate a numeric value with overflow protection, returning null on overflow

Perform subtraction with overflow protection, returning null on overflow

Calculate the secant of a numeric value specified in radians

Calculate the hyperbolic secant of a numeric value

Calculate the SHA-1 hash of a string

Calculate the SHA-256 hash of a string

Calculate the SHA-512 hash of a string

Determine the sign of a numeric value (-1, 0, or 1)

Calculate the sine of a numeric value specified in radians

Calculate the hyperbolic sine of a numeric value

Return the seconds remaining until an SLA breaches

Split a string into an array

Calculate the square root of a numeric value

Compute the population standard deviation of a numeric field within the comp stage

Compute the population standard deviation of a numeric field over a window of rows within the windowcomp stage

Compute the sample standard deviation of a numeric field within the comp stage

Compute the sample standard deviation of a numeric field over a window of rows within the windowcomp stage

Count occurrences of a substring in a string

Subtract one number from another

Compute the sum of a numeric field within the comp stage

Compute the sum of a numeric field over a window of rows within the windowcomp stage

Calculate the tangent of a numeric value specified in radians

Calculate the hyperbolic tangent of a numeric value

Return the end of a time frame

Calculate the difference between two timestamps

Convert a timestamp to seconds

Convert a value to a boolean

Convert a timestamp to an epoch value

Convert a value to a float

Convert a value to an integer

Convert a value to a JSON string

Convert a value to a number

Convert a value to a string

Convert a value to a timestamp

Remove leading and trailing whitespace from a string

Truncate a numeric value to a specified number of decimal places

Convert a string to uppercase

Collect all distinct values of a field and return them as an array within the comp stage

Compute the variance of a numeric field within the comp stage

Check if a string matches a wildcard pattern

Last updated

Was this helpful?