统一函数概览

最近更新时间:2023-12-08 15:00:22

我的收藏
数据湖计算 DLC 支持通过统一函数在不同内核使用,同时兼容 Spark、Presto,具体函数及支持的内核可参见下表。 数据湖计算 DLC 同时支持 Presto 的内置函数,支持列表及开启方式可参见 Presto 内置函数
函数
Spark
Presto
ABS
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:与入参一致
出参: double
ACOS
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
ACOSH
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
ADD_MONTHS
入参:date|timestamp|string, int
入参:date|timestamp|string, int
出参:date
出参:date
AES_DECRYPT
-
入参:(binary, string|binary)
出参: binary
AES_ENCRYPT
-
入参:(string|binary, string|binary)
出参: binary
AND
入参:boolean AND boolean
boolean AND boolean
出参:boolean
出参:boolean
ANY
入参:boolean
入参:boolean
出参:boolean
出参:boolean
ANY_MATCH
入参:(array<T>, lambda function)
-
出参:boolean
APPROX_COUNT_DISTINCT
入参:(bigint|double|decimal|date|timestamp,
-
double|array<double>[, bigint])
出参:与第二个输入参数相同
APPROX_PERCENTILE
入参:(bigint|double|decimal|, array<double>|double[, int])
入参:(bigint|double|decimal, double[, int])
出参:double|array
出参:double|array
ARG_MAX
入参:(col1, col2 | expr(col2))
-
出参:col2或expr(col2)的类型
ARG_MIN
入参:(col1, col2 | expr(col2))

出参:col2或expr(col2)的类型
ARRAY
入参:(T, ...)
入参:(T, ...)
出参:array<T>
出参:array<T>
ARRAYS_OVERLAP
入参:(array<T>, array<T>)
入参:(array<T>, array<T>)
出参:boolean
出参:boolean
ARRAYS_ZIP
入参:(array<T>, array< U> , ...)
-
出参:array<struct<T, U, ...>>
ARRAY_CONTAINS
入参:(array<T>, T)
入参:(array<T>, T)
出参:boolean
出参:boolean
ARRAY_DISTINCT
入参:array<T>
入参:array<T>
出参:array<T>
出参:array<T>
ARRAY_EXCEPT
入参:(array<T>, array<T>)
入参:(array<T>, array<T>)
出参:array<T>
出参:array<T>
ARRAY_INTERSECT
入参:(array<T>, array<T>)
入参:(array<T>, array<T>)
出参:array<T>
出参:array<T>
ARRAY_JOIN
入参:(array<T>, string[, string])
入参:(array<T>, string[, string])
出参:string
出参:string
ARRAY_MAX
入参:array<bigint|double|decimal>
入参:array<bigint|double|decimal>
出参:bigint|double|decimal
出参:bigint|double|decimal
ARRAY_MIN
入参:array<bigint|double|decimal>
入参:array<bigint|double|decimal>
出参:bigint|double|decimal
出参:bigint|double|decimal
ARRAY_POSITION
入参:(array<T>, bigint)
入参:(array<T>, bigint)
出参:bigint
出参:bigint
ARRAY_REMOVE
入参:(array<T>, T)
入参:(array<T>, T)
出参:array<T>
出参:array<T>
ARRAY_REPEAT
入参:(array<T>, bigint)
入参:(array<T>, bigint)
出参:array<T>
出参:array<T>
ARRAY_SORT
入参:(array<T>, function(T, T)->integer)
入参:(array<T>)
出参:array<T>
出参:array<T>
ARRAY_UNION
入参:(array<T>, array<T>)
入参:(array<T>, array<T>)
出参:array<T>
出参:array<T>
ASCII
入参:string
入参:string
出参:int
出参:int
ASIN
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
ASINH
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
ASSERT_TRUE
入参:boolean
入参:boolean
出参:null|抛出异常
出参:null|抛出异常
ATAN
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
ATAN2
入参:(bigint|double|decimal, bigint|double|decimal)
入参:(bigint|double|decimal, bigint|double|decimal)
出参:double
出参:double
ATANH
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
AVG
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参: double
BASE64
入参:string|binary
入参:binary
出参:string
出参: string
BIGINT
强制类型转换为bigint
强制类型转换为bigint
BIN
入参:bigint
入参:bigint
出参:string
出参: string
BINARY
强制类型转换为 binary
强制类型转换为 binary
BIT_AND
入参:int
入参:int
出参:int
出参:int
BIT_COUNT
入参:int|boolean
入参:int|boolean
出参:int
出参:int
BIT_GET
入参:(int, int)
入参:(int, int)
出参:int
出参:int
BIT_LENGTH
入参:string
入参:string
出参:int
出参:int
BIT_OR
入参:int
入参:int
出参:int
出参:int
BIT_XOR
入参:int
入参:int
出参:int
出参:int
BOOLEAN
强制类型转换为 boolean
强制类型转换为 boolean
BOOL_AND
入参:boolean
入参:boolean
出参:boolean
出参:boolean
BOOL_OR
入参:boolean
入参:boolean
出参:boolean
出参:boolean
BROUND
入参:(bigint|double|decimal, int)
入参:(bigint|double|decimal, int)
出参:int
出参:int
BTRIM
入参:(string[, string])
入参:(string[, string])
出参:string
出参:string
CARDINALITY
入参:(array|map)
入参:(array|map)
出参:int
出参:int
CAST
入参:(<expr> AS T)
入参:(<expr> AS T)
出参:T
出参:T
CBRT
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
CEIL
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:bigint
出参:bigint
CEILING
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:bigint
出参:bigint
CHAR
入参:int
入参:int
出参:string
出参:string
CHARACTER_LENGTH
入参:string|binary
入参:string
出参:int
出参:int
CHAR_LENGTH
入参:string|binary
入参:string
出参:int
出参:int
CHR
入参:int|double
入参:int|double
出参:string
出参: string
CLUSTER_SAMPLE
入参:(bigint [, bigint])
-
出参:boolean
COALESCE
入参:(T, T, ...)
入参:(T, T, ...)
出参:T
出参:T
COLLECT_LIST
入参:T
入参:T
出参:array<T>
出参: array<T>
COLLECT_SET
入参:T
入参:T
出参:array<T>
出参: array<T>
CONCAT
入参:string|array
入参(string|binary, string|binary, ...)
出参:与输入参数一致
出参:string
CONCAT_WS
入参:(string, [string | array<string>]+)
入参:(string, [string | array<string>]+)
出参:string
出参:string
CONTEXT_NGRAMS
-
入参:(array<array<string>>, array<string>, int, int)
出参:array<struct<string, double>>
CONV
入参:(bigint|double|decimal|string, int, int)
入参:(bigint|double|decimal|string, int, int)
出参:string
出参: string
CORR
入参:bigint|double|decimal,
入参:bigint|double|decimal
出参:double
出参: double
出参:double

COS
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
COSH
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
COT
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
COUNT
入参:T
入参:T
出参:bigint
出参: bigint
COUNT_IF
入参:boolean
-
出参:int
COUNT_MIN_SKETCH
入参:(int|binary|string, double, double, int)
-
出参:binary
COVAR_POP
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参: double
COVAR_SAMP
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参: double
CRC32
入参:string|binary
入参:string|binary
出参:bigint
出参:bigint
CUME_DIST
入参:无
入参:无
出参:double
出参:double
CURRENT_CATALOG
入参:无
-
出参:string
CURRENT_DATABASE
入参:无
-
出参:string
CURRENT_DATE
入参:无
入参:无
出参:date
出参:date
CURRENT_TIMESTAMP
入参:无
入参:无
出参:timestamp
出参:timestamp
CURRENT_TIMEZONE
入参:无
入参:无
出参:string
出参:string
CURRENT_USER
入参:无
入参:无
出参:string
出参:string
DATE
入参:string
入参:string
出参:date
出参:date
DATEDIFF
入参:(string|timestamp|date, string|timestamp|date)
入参:(string|timestamp|date, string|timestamp|date)
出参:int
出参:int
DATE_ADD
入参:(string|date|timestamp, int)
入参:(string|date|timestamp, int)
出参:date
出参: date
DATEADD
入参:(date/timestamp, int, string)
-
出参:timestamp
DATE_FORMAT
入参:(string|date|timestamp, string)
入参:(string|date|timestamp, string)
出参:string
出参:string
DATE_FROM_UNIX_DATE
入参:int
入参:int
出参:date
出参:date
DATE_PART
入参:(string, string|date|timestamp)
入参:(string, string|date|timestamp)
出参:bigint|double|decimal
出参:bigint|double|decimal
DATE_SUB
入参:(string|date|timestamp)
入参:(string|date|timestamp)
出参:date
出参:date
DATE_TRUNC
入参:(string, string)
入参:(string, string)
出参:timestamp
出参:timestamp
DAY
入参:string|timestamp|date
入参:string|timestamp|date
出参:int
出参:int
DAYOFMONTH
入参:string|timestamp|date
入参:string|timestamp|date
出参:int
出参:int
DAYOFWEEK
入参:string|timestamp|date
string|timestamp|date
出参:int
出参:int
DAYOFYEAR
入参:string|timestamp|date
string|timestamp|date
出参:int
出参:int
DECIMAL
cast as decimal
cast as decimal
DECODE
入参:(binary, string) | (int, int, string[, int, string]...[, default])
入参:(binary, string)
出参:
出参: string
DEGREES
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
DENSE_RANK
入参:无
入参:无
出参:int
出参:int
DIV
入参:bigint|double|decimal
-
出参:int
DOUBLE
cast as double
cast as double
E
入参:无
入参:无
出参:double
出参:double
ELEMENT_AT
入参:(array|map, int)
入参:(array, int)
出参:与array元素|map value一致
出参:与array元素一致
ELT
入参:(int, T, U,...)
入参:(int, string, string, ...)
出参:依输入而定
出参: string
ENCODE
入参:(string|binary, string)
入参:(string, string)
出参:binary
出参: binary
EVERY
入参:T
入参:T
出参:boolean
出参:boolean
EXP
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
EXPLODE
入参:array<T>
-
出参:T
EXPLODE_OUTER
入参:array<T>
-
出参:T
EXPM1
入参:bigint|double|decimal
-
出参:double
FACTORIAL
入参:int
入参:int
出参:bigint
出参: bigint
FIELD
-
入参:(T, T, T, ...)
出参:int
FIND_IN_SET
入参:(string, string)
入参:(string, string)
出参:int
出参:int
FIRST_VALUE
入参:(T[, boolean])
-
出参:T
FLATTEN
入参:array<array<T>>
入参:array<array<T>>
出参:array<T>
出参:array<T>
FLOAT
cast as float
cast as float
FLOOR
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:bigint
出参:bigint
FORMAT_NUMBER
入参:(bigint|double|decimal, int|string)
入参:(bigint|double|decimal, int)
出参:string
出参:string
FORMAT_STRING
入参:(string, T, ...)
入参:(string, T, ...)
出参:string
出参:string
FROM_CSV
入参:(string, string[, map])
-
出参:struct
FROM_JSON
入参:(string, string[, map])
-
出参:struct
FROM_UNIXTIME
入参:(bigint[, string])
入参:(bigint[, string])
出参:string
出参:string
FROM_UTC_TIMESTAMP
入参:(string, string)
入参:(bigint|double|decimal|timestamp|date|string, string)
出参:timestamp
出参: timestamp
GETBIT
入参:(int, int)
入参:(int, int)
出参:int
出参:int
GET_IDCARD_AGE
入参:string
-
出参:int
GET_IDCARD_BIRTHDAY
入参:string
-
出参:date
GET_IDCARD_SEX
入参:string
-
出参:string
GREATEST
入参:(bigint|double|decimal, bigint|double|decimal, ...)
入参:(bigint|double|decimal, bigint|double|decimal, ...)
出参:与输入一致
出参:与输入一致
GROUPING
入参:T
T
出参:int
出参:int
GROUPING_ID
入参:[T[, T...]]
-
出参:int
HASH
入参:(T, T,...)
入参:(T, T,...)
出参:int
出参:int
HEX
入参:int|string|binary
入参:int|string|binary
出参:string
出参:string
HISTOGRAM_NUMERIC
-
入参:bigint|double|decimal
出参:array<struct<'x', 'y'>>
HOUR
入参:string|timestamp
入参:string|timestamp
出参:int
出参:int
HYPOT
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
IF
入参:(boolean, T, T)
入参:(boolean, T, T)
出参:T
出参:T
IFNULL
入参:(T, U)
-
出参:T|U
IN
入参:(T, T,...)
入参:(T, T,...)
出参:boolean
出参:boolean
INITCAP
入参:string
入参:string
出参:string
出参:string
INLINE
入参:array
-
出参:table
INLINE_OUTER
入参:array
-
出参:table
INPUT_FILE_BLOCK_LENGTH
入参:无
-
出参:int
INPUT_FILE_BLOCK_START
入参:无
-
出参:int
INPUT_FILE_NAME
入参:无
-
出参:string
INSTR
入参:(string, string)
入参:(string, string)
出参:int
出参:int
INT
强制类型转换为 int
强制类型转换为 int
ISNAN
入参:T
入参:T
出参:boolean
出参:boolean
ISNOTNULL
入参:T
入参:T
出参:boolean
出参:boolean
ISNULL
入参:T
入参:T
出参:boolean
出参:boolean
JSON_ARRAY_LENGTH
入参:string
入参:string
出参:int
出参:int
JSON_OBJECT_KEYS
入参:string
入参:string
出参:array
出参:array
JSON_TUPLE
入参:(string, ..., string)
-
出参:string...string
KEYVALUE
入参:(string [, string, string], string)

出参:string
KURTOSIS
入参:bigint|double|decimal
-
出参:double
LAG
入参:(T[, int[, string]])
入参:(T[, int[, string]])
出参: T
出参:T
LAST_DAY
入参:string|date|timestamp
入参:string|date|timestamp
出参:string
出参:string
LAST_VALUE
入参:(T[, boolean])
-
出参:T
LCASE
入参:string
入参:string
出参:string
出参:string
LEAD
入参:(T[, int[, string]])
入参:(T[, int[, string]])
出参:T
出参:T
LEAST
入参:(bigint|double|decimal, bigint|double|decimal, ...)
(bigint|double|decimal, bigint|double|decimal, ...)
出参:与输入一致
出参:与输入一致
LEFT
入参:(string, int)
入参:(string, int)
出参:string
出参:string
LENGTH
入参:string
入参:string
出参:int
出参:int
LEVENSHTEIN
入参:(string, string)
入参:(string, string)
出参:int
出参:int
LIKE
入参:(string, string) | string LIKE string ESCAPE string
入参:(string, string)
出参:boolean
出参:boolean
LN
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
LOCATE
入参:(string, string[, int])
入参:(string, string[, int])
出参:int
出参:int
LOG
入参:(bigint|double|decimal, bigint|double|decimal)
入参:(bigint|double|decimal, bigint|double|decimal)
出参:double
出参:double
LOG10
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
LOG1P
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
LOG2
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
LOWER
入参:string
入参:string
出参:string
出参:string
LPAD
入参:(string, int[, string])
入参:(string, int, string)
出参:string
出参:string
LTRIM
入参:string
入参:string
出参:string
出参:string
MAKE_DATE
入参:(int, int, int)
入参:(int, int, int)
出参:date
出参:date
MAKE_TIMESTAMP
入参:(int, int, int, int, int, int[, string])
入参:(int, int, int, int, int, int[, string])
出参:timestamp
出参:timestamp
MAP
入参:(K1, V1, K2, V2,...)
入参:(array<K>, array<V>)
出参:map
出参:map
MAP_CONCAT
入参:(map, ...)
入参:(map, ...)
出参:map
出参:map
MAP_ENTRIES
入参:map
入参:map
出参:array
出参:array
MAP_FROM_ARRAYS
入参:(array, array)
入参:(array, array)
出参:map
出参:map
MAP_FROM_ENTRIES
入参:array
入参:array
出参:map
出参:map
MAP_KEYS
入参:map
入参:map
出参:array
出参:array
MAP_UINON_SUM
入参:map
-
出参:map
MAP_VALUES
入参:map
入参:map
出参:array
出参:array
MAX
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:与入参一致
出参: double
MAX_BY
入参:T, bigint|double|decimal
入参:T, bigint|double|decimal
出参:T
出参:T
MAX_PT
入参:const string
-
出参: string
MD5
入参:string|binary
入参:string|binary
出参:string
出参: string
MEAN
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
MIN
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:与入参一致
出参: double
MINUTE
入参:(stirng|timestamp)
入参:(stirng|timestamp)
出参:int
出参:int
MIN_BY
入参:(T, bigint|double|decimal)
入参:(T, bigint|double|decimal)
出参:T
出参:T
MOD
入参:(bigint|double|decimal, bigint|double|decimal) | bigint|double|decimal MOD bigint|double|decimal
入参:(bigint|double|decimal, bigint|double|decimal)
出参:int|double
出参:int|double
MONOTONICALLY_INCREASING_ID
入参:无
-
出参:bigint
MONTH
入参:date|timestamp|string
入参:date|timestamp|string
出参:int
出参:int
MONTHS_BETWEEN
入参:(date|timestamp|string, date|timestamp|string[, boolean])
入参:(date|timestamp|string, date|timestamp|string)
出参:double
出参:double
NAMED_STRUCT
入参:(K1, V1, K2, V2, ...)
-
出参:struct
NANVL
入参:(bigint|double|decimal, bigint|double|decimal)
入参:(bigint|double|decimal, bigint|double|decimal)
出参:double
出参:double
NEGATIVE
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:bigint|double|decimal
出参: int | double
NEXT_DAY
入参:(string|date|timestamp, string)
入参:(string|date|timestamp, string)
出参:date
出参:string
NGRAMS
-
入参:(array<array<string>>, int, int, int)
出参:array<struct<string, double>>
NOW
入参:无
入参:无
出参:timestamp
出参:timestamp
NTH_VALUE
入参:(T[, int])
入参:(T[, int])
出参:T
出参:T
NTILE
入参:int
入参:int
出参:int
出参: int
NULLIF
入参:(T, T)
入参:(T, T)
出参:T
出参:T
NVL
入参:(T, T)
入参:(T, T)
出参:T
出参:T
NVL2
入参:(T, T, T)
入参:(T, T, T)
出参:T
出参:T
OCTET_LENGTH
入参:string
入参:string
出参:int
出参:int
OR
入参:expr1 OR expr2
入参:expr1 OR expr2
出参:boolean
出参:boolean
OVERLAY
入参:(string PLACING string FROM int[ FOR int])
-
出参:
PARSE_URL
入参:(string, string[, string])
入参:(string, string[, string])
出参:string
出参: string
PERCENTILE
入参:(bigint|double|decimal, bigint|double|decimal|array, int)
入参:(bigint|double|decimal, bigint|double|decimal|array, int)
出参:bigint|double|decimal|array
出参:double|array
PERCENTILE_APPROX
入参:(bigint|double|decimal, bigint|double|decimal | array[, int])
入参:(bigint|double|decimal, bigint|double|decimal[, int])
出参:double|array
出参:double|array
PERCENT_RANK
入参:无
入参:无
出参:double
出参:double
PI
入参:无
入参:无
出参:double
出参:double
PMOD
入参:(bigint|double|decimal, bigint|double|decimal)
入参:(bigint|double|decimal, bigint|double|decimal)
出参:与入参一致
出参:与入参一致
POSITION
入参:(string, string[, int]) | (string IN string)
入参:(string, string[, int]) | (string IN string)
出参:int
出参:int
POSITIVE
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:与入参一致
出参:与入参一致
POSEXPLODE
入参:array
-
出参:table
POSEXPLODE_OUTER
入参:array
-
出参:table
POW
入参:(bigint|double|decimal, bigint|double|decimal)
入参:(bigint|double|decimal, bigint|double|decimal)
出参:double
出参:double
POWER
入参:(bigint|double|decimal, bigint|double|decimal)
入参:(bigint|double|decimal, bigint|double|decimal)
出参:double
出参:double
PRINTF
入参:(string, T, ...)
入参:(string, T, ...)
出参:string
出参:string
QUARTER
入参:string|date|timestamp
入参:string|date|timestamp
出参:int
出参:int
RADIANS
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
RAISE_ERROR
入参:string
入参:string
出参:抛出异常
出参:抛出异常
RAND
入参:[int]
入参:[int]
出参:double
出参:double
RANDN
入参:[int]
入参:[long]
出参:double
出参:double
RANDOM
入参:[int]
入参:[int]
出参:double
出参:double
RANK
入参:无
入参:无
出参:int
出参:int
REGEXP
入参:(string, string)
入参:(string, string)
出参:boolean
出参:boolean
REGEXP_COUNT
入参:(string, string)
-
出参:int
REGEXP_EXTRACT
入参:(string, string[, int])
入参:(string, string, int)
出参:int
出参:int
REGEXP_EXTRACT_ALL
入参:(string, string[, int])
入参:(string, string[, int])
出参:array
出参:array
REGEXP_LIKE
入参:(string, string)
入参:(string, string)
出参:boolean
出参:boolean
REGEXP_REPLACE
入参:(string, string, string[, int])
入参:(string, string, string)
出参:string
出参:string
REGEXP_SUBSTR
入参:(string, string)
-
出参:string
REPEAT
入参:(string, int)
入参:(string, int)
出参:string
出参:string
REPLACE
入参:(string, string[, string])
入参:(string, string, string)
出参:string
出参:string
REVERSE
入参:string | array
入参:string
出参:string
出参:string
RIGHT
入参:(string, int)
入参:(string, int)
出参:string
出参:string
RINT
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
RLIKE
入参:(string, string)
入参:(string, string)
出参:boolean
出参:boolean
ROUND
入参:(double, int)
入参:(double, int)
出参:double
出参:double
ROW_NUMBER
入参:无
入参:无
出参:int
出参:int
RPAD
入参:(string, int[, string])
入参:(string, int, string)
出参:string
出参:string
RTRIM
入参:string
入参:string
出参:string
出参:string
SAMPLE
入参:(long [, long [, cols...]])
-
出参:boolean
SCHEMA_OF_CSV
入参:(string[, map])

出参:struct
SCHEMA_OF_JSON
入参:(string[, map])
-
出参:
SECOND
入参:string|timestamp
入参:string|timestamp
出参:int
出参:int
SENTENCES
(string[, string, string])
入参:(string[, string, string])
出参:array<array<string>>
出参:array<array<string>>
SEQUENCE
入参:(int|bigint|date|timestamp, int|bigint|date|timestamp, int)
入参:(int|bigint|date|timestamp, int|bigint|date|timestamp, int)
出参:与入参一致
出参:与入参一致
SHA
入参:string|binary
入参:string|binary
出参:string
出参:string
SHA1
入参:string|binary
入参:string|binary
出参:string
出参:string
SHA2
入参:(string, int)
入参:(string, int)
出参:string
出参:string
SHIFTLEFT
入参:(int|bigint, int)
入参:(int|biging, int)
出参:int|bigint
出参:int|bigint
SHIFTRIGHT
入参:(int|bigint, int)
入参:(int|bigint, int)
出参:int|bigint
出参:int|bigint
SHIFTRIGHTUNSIGNED
入参:(int|bigint, int)
入参:(int|bigint, int)
出参:int|bigint
出参:int|bigint
SHUFFLE
入参:array
入参:array
出参:array
出参:array
SIGN
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
SIGNUM
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
SIN
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
SINH
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
SIZE
入参:array | map
入参:array | map
出参:int
出参:int
SKEWNESS
入参:bigint|double|decimal
-
出参:double
SLICE
入参:(array, int, int)
入参:(array, int, int)
出参:array
出参:array
SMALLINT
cast as smallint
cast as smallint
SOME
入参:boolean
入参:boolean
出参:boolean
出参:boolean
SORT_ARRAY
入参:(array[, boolean])
入参:array
出参:array
出参:array
SOUNDEX
入参:string
入参:string
出参:string
出参:string
SPACE
入参:string
入参:string
出参:string
出参:string
SPARK_PARTITION_ID
入参:无
-
出参:int
SPLIT
入参:(string, string, int)
入参:(string, string)
出参:string
出参:string
SQRT
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
STACK
入参:(T, U, ...)
-
出参:table
STD
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
STDDEV
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参: double
STDDEV_POP
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参: double
STDDEV_SAMP
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参: double
STRING
cast as string
cast as string
STRUCT
入参:(T, U, ...)
入参:(T, U, ...)
出参:struct
出参:struct
STR_TO_MAP
入参:(string[, string[, string]])
入参:(string[, string, string])
出参:map
出参:map
SUBSTR
入参:(string, int[, int]) | (string FROM int [FOR int])
入参:(string|binary, int[, int]) | (string|binary FROM int [FOR int])
出参:string
出参: string
SUBSTRING
入参:(string, int[, int]) | (string FROM int [FOR int])
入参:(string|binary, int[, int]) | (string|binary FROM int [FOR int])
出参:string
出参: string
SUBSTRING_INDEX
入参:(string, string, int)
入参:(string, string, int)
出参:string
出参:string
SUM
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:与输入一致
出参: double
TAN
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
TANH
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参:double
TIMESTAMP
入参:string
入参:string
出参:timestamp
出参:timestamp
TIMESTAMP_ADD
入参:(date/timestamp, int, string)


出参:timestamp

TIMESTAMP_MICROS
入参:bigint
入参:bigint
出参:timestamp
出参:timestamp
TIMESTAMP_MILLIS
入参:bigint
入参:bigint
出参:timestamp
出参:timestamp
TIMESTAMP_SECONDS
入参:bigint
入参:bigint
出参:timestamp
出参:timestamp
TIMEZONE_HOUR
入参:string
-
出参:int
TIMEZONE_MINUTE
入参:string
-
出参:int
TINYINT
cast as tinyint
cast as tinyint
TO_CHAR
入参:(boolean|int|long|double|decimal [, string])


出参:string

TO_CSV
入参:(struct[, map])
-
出参:string
TO_DATE
入参:(string[, string])
入参:string
出参:date
出参: date
TO_JSON
入参:(string[, map])
-
出参:string
TO_TIMESTAMP
入参:(string[, string])
入参:(string)
出参:timestamp
出参:timestamp
TO_UNIX_TIMESTAMP
入参:(string[, string])
入参:(string[, string])
出参:timestamp
出参:timestamp
TO_UTC_TIMESTAMP
入参:(string[, string])
入参:(bigint|double|decimal|date|timestamp|string, string)
出参:timestamp
出参: timestamp
TRANS_ARRAY
入参:(int, string, cols...)
-
出参:与cols类型相同
TRANS_COLS
入参:(int, cols...)

出参:(int, cols)

TRANSLATE
入参:(string, string, string)
-
出参:string
TRIM
入参:string
入参:string
出参:string
出参: string
TRUNC
入参:(string|date|timestamp, string)
入参:(string|date|timestamp, string)
出参:string
出参: string
TRY_ADD
入参:(bigint|double|decimal|date|timestamp|, bigint|double|decimal|date|timestamp)
入参:(bigint|double|decimal, bigint|double|decimal)
出参:与入参一致
出参:与入参一致
TRY_DIVIDE
入参:(bigint|double|decimal, bigint|double|decimal)
-
出参:double
TYPEOF
入参:T
入参:T
出参:string
出参:string
UCASE
入参:string
入参:string
出参:string
出参:string
UNBASE64
入参:string
入参:string
出参:string
出参:string
UNHEX
入参:string
入参:string
出参:binary
出参:binary
UNIX_DATE
入参:string|timestamp|date
入参:string|timestamp|date
出参:int
出参:int
UNIX_MICROS
入参:timestamp
入参:timestamp
出参:bigint
出参:bigint
UNIX_MILLIS
入参:timestamp
入参:timestamp
出参:bigint
出参:bigint
UNIX_SECONDS
入参:timestamp
入参:timestamp
出参:bigint
出参:bigint
UNIX_TIMESTAMP
入参:[date|timestamp|string[, string]]
入参:(date|timestamp|string[, string])
出参:bigint
出参: bigint
UPPER
入参:string
入参:string
出参:string
出参:string
URL_DECODE
入参:string
-
出参:string
UUID
入参:无
入参:无
出参:string
出参:string
VARIANCE
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参: double
VAR_POP
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参: double
VAR_SAMP
入参:bigint|double|decimal
入参:bigint|double|decimal
出参:double
出参: double
VERSION
入参:无
入参:无
出参:string
出参:string
WEEKDAY
入参:date|timestamp|string
入参:date|timestamp|string
出参:int
出参:int
WEEKOFYEAR
入参:date|timestamp|string
入参:date|timestamp|string
出参:int
出参:int
WIDTH_BUCKET
入参:(bigint|double|decimal, bigint|double|decimal, bigint|double|decimal, int)
入参:(bigint|double|decimal, bigint|double|decimal, bigint|double|decimal, int)
出参:int
出参:int
WINDOW
入参:(date|timestamp, string[, string[, string]])
-
出参:table
XPATH
入参:(string, string)
入参:(string, string)
出参:array
出参:array
XPATH_BOOLEAN
入参:(string, string)
入参:(string, string)
出参:boolean
出参:boolean
XPATH_DOUBLE
入参:(string, string)
入参:(string, string)
出参:double
出参:double
XPATH_FLOAT
入参:(string, string)
入参:(string, string)
出参:float
出参:float
XPATH_INT
入参:(string, string)
入参:(string, string)
出参:int
出参:int
XPATH_LONG
入参:(string, string)
入参:(string, string)
出参:bigint
出参:bigint
XPATH_NUMBER
入参:(string, string)
入参:(string, string)
出参:double
出参:double
XPATH_STRING
入参:(string, string)
入参:(string, string)
出参:string
出参:string
XXHASH64
入参:(T, U, ...)
入参:(T, U, ...)
出参:bigint
出参:bigint
YEAR
入参:date|timestamp|string
入参:date|timestamp|string
出参:int
出参:int