함수 참조

집계

• 중앙값
• APPROX_COUNT_DISTINCT
• AVG
• COUNT
• COUNT_DISTINCT
• MAX
• MIN
• PERCENTILE
• STDDEV
• SUM
• VARIANCE

연산

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

조건부

• CASE(검색)
• CASE(단순)
• COALESCE
• IF
• IFNULL
• NULLIF

날짜

• 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

지역

• TOCITY
• TOCONTINENT
• TOCOUNTRY
• TOREGION
• TOSUBCONTINENT

기타 함수

• CAST
• HYPERLINK
• IMAGE
• NATIVE_DIMENSION

텍스트 함수

• 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