APPROX_COUNT_DISTINCT(X)

AVG(X)

COUNT(X)

COUNT_DISTINCT(X)

MAX(X)

MEDIAN(X)

MIN(X)

PERCENTILE(X,N)

STDDEV(X)

SUM(X)

VARAINCE(X)

ABS(X)

ACOS(X)

ASIN(X)

ATAN(X)

COS(X)

SIN(X)

TAN(X)

CEIL(X)

FLOOR(X)

LOG(X)

LOG10(X)

NARY_MAX(X,Y,Z)

NARY_MIN(X,Y,Z)

POWER(X,Y)

ROUND(X,Y)

SQRT(X)

DATE_DIFF(X,Y)

MONTH(X[Input Format])

DAY(X[Input Format])

HOUR(X[Input Format])

MINUTE(X[Input Format])

SECOND(X[Input Format])

WEEK(X)

WEEKDAY(X[Input Format])

YEAR(X[Input Format])

YEARWEEK(X)

TOCITY(X[Input Format])

TOCONTINENT(X[Input Format])

TOCOUNTRY(X[Input Format])

TOREGION(X[Input Format])

TOSUBCONTINENT(X[Input Format])

CONCAT(X,Y)

CONTAINS_TEXT(X,' text ')

REPLACE(X,Y,Z)

TRIM(X)

LENGTH(X)

LOWER(X)

UPPER(X)

LEFT_TEXT(X, length)

RIGHT_TEXT(X, length)

STARTS_WITH(X, ' text ')

ENDS_WITH(X,' text ')

SUBSTR(X, start index , length)

CASE

   WHEN condition THEN result

   ELSE result

END

CAST( field_expression AS TYPE)

HYPERLINK(URL, link label)

IMAGE(image URL, [Alternative text ])