MIN(variable v) | typeof v | Returns the smallest value in a set of data. |
MAX(variable v) | typeof v | Returns the maximum value across all input values. |
COUNT(any a) | numeric | Returns the number of input values that are not null. |
SUM(numeric n) | numeric | Returns the summation across all input values. |
AVG(numeric n) | numeric | Returns the average value (arithmetic mean) across all input values. |
CEIL(numeric n) | numeric | Returns the value rounded up to the nearest integer. |
FLOOR(numeric n) | numeric | Returns the value rounded down to the nearest integer. |
ROUND(numeric n) | numeric | Returns the value rounded to the nearest integer. |
LOWER(string s) | string | Returns the string as lowercase. |
UPPER(string s) | string | Returns the string as uppercase. |
ABS(numeric n) | numeric | Returns the absolute value. |
COALESCE(args a) | typeof first non-null a OR null | Returns the first non-null value or null if all are null. |
CAST(value AS type) | type | Converts the given value to the specified data type. |
LENGTH(string s) | integer | Returns the number of characters in the string. |
TRIM(string s) | string | Removes leading and trailing whitespace from the string. |
REPLACE(string s, string from, string to) | string | Replaces occurrences of a substring within a string with another substring. |
SUBSTRING(string s, int start, int length) | string | Extracts a substring from a string, starting at a given position and for a specified length. |
STRPOS(string s, string substring) | integer | Returns the first index position of the substring in a given string, or 0 if there is no match. |
SPLIT_PART(string s, string delimiter, integer index) | string | Splits the string on the given delimiter and returns the string at the given position counting from one. |
EXTRACT(unit from timestamp/interval) | numeric | Extracts a part of a date or time field (such as year or month) from a timestamp or interval. |
TO_TIMESTAMP(string timestamp, string format) | timestamp | Converts a string to a timestamp according to the given format. |
TO_CHAR(timestamp t, string format) | string | Converts a timestamp to a string according to the given format. |
DATE_TRUNC(string unit, timestamp t) | timestamp | Truncates a timestamp to a specified precision based on the provided unit. |
REGEXP_LIKE(string s, pattern p) | boolean | Evaluates whether a string matches a regular expression pattern. |
CARDINALITY(array a) | integer | Returns the number of elements in the array. |
ARRAY_POSITION(array a, typeof_array value) | integer | Returns the index of the first occurrence of the value found in the array, or null if value is not found. |
STRING_TO_ARRAY(string s, string delimiter) | array of strings | Splits the given string into an array of strings using the given delimiter. |
ARRAY_AGG(expression e) | array of input type | Creates an array by collecting all the input values. |
UNNEST(array a [, array b...]) | rows of a [, b…] | Expands arrays into a set of rows. This form is only allowed in a FROM clause. |