内建函数(字母排序)
- 内建函数概述
- ABS
- ACOS
- ADD_MONTHS
- ADD_KEY_TO_KEYSET
- ALL_MATCH
- ANY_MATCH
- ANY_VALUE
- ATAN2
- APPROX_DISTINCT
- ARG_MAX
- ARG_MIN
- ARRAY
- ARRAY_CONTAINS
- ARRAY_DISTINCT
- ARRAY_EXCEPT
- ARRAY_INTERSECT
- ARRAY_JOIN
- ARRAY_MAX
- ARRAY_MIN
- ARRAY_NORMALIZE
- ARRAY_POSITION
- ARRAY_REDUCE
- ARRAY_REMOVE
- ARRAY_REPEAT
- ARRAY_SORT
- ARRAY_UNION
- ARRAYS_OVERLAP
- ARRAYS_ZIP
- ASCII
- ASIN
- ATAN
- AVG
- BASE64
- BETWEEN AND
- BIN
- BITWISE_AND_AGG
- BITWISE_OR_AGG
- CASE WHEN
- CAST
- CBRT
- CEIL
- CHAR_MATCHCOUNT
- CHR
- CLUSTER_SAMPLE
- COALESCE
- COLLECT_LIST
- COLLECT_SET
- COMBINATIONS
- COMPRESS
- CONCAT
- CONCAT_WS
- CONV
- CORR
- COS
- COSH
- COT
- COUNT
- COUNT_IF
- COVAR_POP
- COVAR_SAMP
- CRC32
- CUME_DIST
- CURRENT_TIMESTAMP
- CURRENT_TIMEZONE
- DATE_ADD
- DATE_FORMAT
- DATE_SUB
- DATEADD
- DATEDIFF
- DATEPART
- DATETRUNC
- DAY
- DAYOFMONTH
- DAYOFWEEK
- DAYOFYEAR
- DECODE
- DECOMPRESS
- DEGREES
- DENSE_RANK
- E
- ENCODE
- ENHANCED_SYM_DECRYPT
- ENHANCED_SYM_ENCRYPT
- EXP
- EXPLODE
- EXTRACT
- FACTORIAL
- FIELD
- FILTER
- FIRST_VALUE
- FIND_IN_SET
- FLATTEN
- FLOOR
- FORMAT_NUMBER
- FROM_CHARSET
- FROM_JSON
- FROM_UNIXTIME
- FROM_UTC_TIMESTAMP
- GET_IDCARD_AGE
- GET_IDCARD_BIRTHDAY
- GET_IDCARD_SEX
- GET_JSON_OBJECT
- GET_USER_ID
- GETDATE
- GREATEST
- HASH
- HEX
- HISTOGRAM
- HOUR
- IF
- INDEX
- INLINE
- INITCAP
- INSTR
- IS_ENCODING
- ISDATE
- ISNAN
- JSON_INSERT
- JSON_OBJECT
- JSON_ARRAY
- JSON_EXPLODE
- JSON_EXTRACT
- JSON_EXISTS
- JSON_PRETTY
- JSON_TYPE
- JSON_FORMAT
- JSON_PARSE
- JSON_SET
- JSON_VALID
- JSON_TUPLE
- KEYVALUE
- KEYVALUE_TUPLE
- KEYSET_FROM_JSON
- KEYSET_TO_JSON
- LAG
- LAST_DAY
- LASTDAY
- LAST_VALUE
- LEAD
- LEAST
- LENGTH
- LENGTHB
- LN
- LOCATE
- LOG
- LOG10
- LOG2
- LPAD
- LTRIM
- MAP
- MAP_AGG
- MAP_CONCAT
- MAP_ENTRIES
- MAP_FILTER
- MAP_FROM_ARRAYS
- MAP_FROM_ENTRIES
- MAP_KEYS
- MAP_UNION
- MAP_UNION_SUM
- MAP_VALUES
- MAP_ZIP_WITH
- MASK_HASH
- MAX
- MAX_BY
- MAX_PT
- MD5
- MEDIAN
- MIN
- MIN_BY
- MINUTE
- MONTH
- MONTHS_BETWEEN
- MULTIMAP_AGG
- MULTIMAP_FROM_ENTRIES
- NAMED_STRUCT
- NEGATIVE
- NEXT_DAY
- NEW_KEYSET
- NEW_WRAPPED_KEYSET
- NGRAMS
- NOW
- NTILE
- NTH_VALUE
- NULLIF
- NUMERIC_HISTOGRAM
- NVL
- ORDINAL
- PARSE_URL
- PARSE_URL_TUPLE
- PARTITION_EXISTS
- PERCENT_RANK
- PERCENTILE
- PERCENTILE_APPROX
- PI
- POSEXPLODE
- POSITIVE
- POW
- QUARTER
- RADIANS
- RAND
- RANK
- REGEXP_COUNT
- REGEXP_EXTRACT
- REGEXP_EXTRACT_ALL
- REGEXP_INSTR
- REGEXP_REPLACE
- REGEXP_SUBSTR
- REPEAT
- REPLACE
- REVERSE
- REWRAP_KEYSET
- ROUND
- ROTATE_KEYSET
- ROTATE_WRAPPED_KEYSET
- ROW_NUMBER
- RPAD
- RTRIM
- SAMPLE
- SECOND
- SEQUENCE
- SHA
- SHA1
- SHA2
- SHIFTLEFT
- SHIFTRIGHT
- SHIFTRIGHTUNSIGNED
- SHUFFLE
- SIGN
- SIN
- SINH
- SIZE
- SLICE
- SORT_ARRAY
- SOUNDEX
- SPACE
- SPLIT
- SPLIT_PART
- SQRT
- STACK
- STDDEV
- STDDEV_SAMP
- STR_TO_MAP
- STRUCT
- SUBSTR
- SUBSTRING
- SUBSTRING_INDEX
- SUM
- SYM_DECRYPT
- SYM_ENCRYPT
- TABLE_EXISTS
- TAN
- TANH
- TO_CHAR
- TO_DATE
- TO_JSON
- TO_MILLIS
- TOLOWER
- TOUPPER
- TRANS_ARRAY
- TRANS_COLS
- TRANSFORM
- TRANSFORM_KEYS
- TRANSFORM_VALUES
- TRANSLATE
- TRIM
- TRUNC
- UNBASE64
- UNHEX
- UNIQUE_ID
- UNIX_TIMESTAMP
- URL_DECODE
- URL_ENCODE
- USE_WRAPPED_KEYSET
- UUID
- VAR_SAMP
- VARIANCE/VAR_POP
- WEEKDAY
- WEEKOFYEAR
- WIDTH_BUCKET
- WM_CONCAT
- YEAR
- ZIP_WITH
- FAILIF