Function references

Aggregation

• APPROX_COUNT_DISTINCT
• AVG
• COUNT
• COUNT_DISTINCT
• MAX
• MEDIAN
• MIN
• PERCENTILE
• STDDEV
• SUM
• VARIANCE

Arithmetic

• ABS
• ACOS
• ASIN
• ATAN
• CEIL
• COS
• FLOOR
• LOG
• LOG10
• NARY_MAX
• NARY_MIN
• POWER
• ROUND
• SIN
• SQRT
• TAN

Conditional

• CASE (Searched)
• CASE (simple)
• COALESCE
• IF
• IFNULL
• NULLIF

Date

• CURRENT_DATE
• CURRENT_DATETIME
• DATE
• DATE_DIFF
• DATE_FROM_UNIX_DATE
• DATETIME
• DATETIME_ADD
• DATETIME_DIFF
• DATETIME_SUB
• DATETIME_TRUNC
• DAY
• EXTRACT
• FORMAT_DATETIME
• HOUR
• MINUTE
• MONTH
• PARSE_DATE
• PARSE_DATETIME
• QUARTER
• SECOND
• TODAY
• UNIX_DATE
• WEEK
• WEEKDAY
• YEAR
• YEARWEEK

Geo

• [ARTICLE] TOCITY
• TOCONTINENT
• TOCOUNTRY
• TOREGION
• TOSUBCONTINENT

Miscellaneous

• CAST
• HYPERLINK
• IMAGE
• NATIVE_DIMENSION

Text

• CONCAT
• CONTAINS_TEXT
• ENDS_WITH
• LEFT_TEXT
• LENGTH
• LOWER
• REGEXP_CONTAINS
• REGEXP_EXTRACT
• REGEXP_MATCH
• REGEXP_REPLACE
• REPLACE
• RIGHT_TEXT
• STARTS_WITH
• SUBSTR
• TRIM
• UPPER