tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Data Lake Compute
    Documentation
    Download PDF

    Overview of Unified Functions

    Last updated: 2024-08-07 17:30:42
    Download PDF
    DLC supports the use of unified functions across different kernels, compatible with both Spark and Presto. Specific functions and supported kernels are listed in the table below. DLC also supports Presto's built-in functions. For a list of supported functions and how to enable them, see Presto Built-in Functions.
    Function
    Spark
    Presto
    ABS
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: same as input parameter
    Output parameter: double
    ACOS
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    ACOSH
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    ADD_MONTHS
    Input parameters: date|timestamp|string, int
    Input parameters: date|timestamp|string, int
    Output parameter: date
    Output parameter: date
    AES_DECRYPT
    -
    Input parameters: (binary, string|binary)
    Output parameter: binary
    AES_ENCRYPT
    -
    Input parameters: (string|binary, string|binary)
    Output parameter: binary
    AND
    Input parameters: boolean AND boolean
    boolean AND boolean
    Output parameter: boolean
    Output parameter: boolean
    ANY
    Input parameter: boolean
    Input parameter: boolean
    Output parameter: boolean
    Output parameter: boolean
    ANY_MATCH
    Input parameters: (array<T>, lambda function)
    -
    Output parameter: boolean
    APPROX_COUNT_DISTINCT
    Input parameters: (bigint|double|decimal|date|timestamp,
    -
    double|array<double>[, bigint])
    Output parameter: same as the second input parameter
    APPROX_PERCENTILE
    Input parameters: (bigint|double|decimal|, array<double>|double[, int])
    Input parameters: (bigint|double|decimal, double[, int])
    Output parameter: double|array
    Output parameter: double|array
    ARG_MAX
    Input parameters: (col1, col2 | expr(col2))
    -
    Output parameters: the type of col2 or expr(col2)
    ARG_MIN
    Input parameters: (col1, col2 | expr(col2))
    
    Output parameters: the type of col2 or expr(col2)
    ARRAY
    Input parameters: (T, ...)
    Input parameters: (T, ...)
    Output parameter: array<T>
    Output parameter: array<T>
    ARRAYS_OVERLAP
    Input parameters: (array<T>, array<T>)
    Input parameters: (array<T>, array<T>)
    Output parameter: boolean
    Output parameter: boolean
    ARRAYS_ZIP
    Input parameters: (array<T>, array< U> , ...)
    -
    Output parameters: array<struct<T, U, ...>>
    ARRAY_CONTAINS
    Input parameters: (array<T>, T)
    Input parameters: (array<T>, T)
    Output parameter: boolean
    Output parameter: boolean
    ARRAY_DISTINCT
    Input parameter: array<T>
    Input parameter: array<T>
    Output parameter: array<T>
    Output parameter: array<T>
    ARRAY_EXCEPT
    Input parameters: (array<T>, array<T>)
    Input parameters: (array<T>, array<T>)
    Output parameter: array<T>
    Output parameter: array<T>
    ARRAY_INTERSECT
    Input parameters: (array<T>, array<T>)
    Input parameters: (array<T>, array<T>)
    Output parameter: array<T>
    Output parameter: array<T>
    ARRAY_JOIN
    Input parameters: (array<T>, string[, string])
    Input parameters: (array<T>, string[, string])
    Output parameter: string
    Output parameter: string
    ARRAY_MAX
    Input parameter: array<bigint|double|decimal>
    Input parameter: array<bigint|double|decimal>
    Output parameter: bigint|double|decimal
    Output parameter: bigint|double|decimal
    ARRAY_MIN
    Input parameter: array<bigint|double|decimal>
    Input parameter: array<bigint|double|decimal>
    Output parameter: bigint|double|decimal
    Output parameter: bigint|double|decimal
    ARRAY_POSITION
    Input parameters: (array<T>, bigint)
    Input parameters: (array<T>, bigint)
    Output parameter: bigint
    Output parameter: bigint
    ARRAY_REMOVE
    Input parameters: (array<T>, T)
    Input parameters: (array<T>, T)
    Output parameter: array<T>
    Output parameter: array<T>
    ARRAY_REPEAT
    Input parameters: (array<T>, bigint)
    Input parameters: (array<T>, bigint)
    Output parameter: array<T>
    Output parameter: array<T>
    ARRAY_SORT
    Input parameters: (array<T>, function(T, T)->integer)
    Input parameter: (array<T>)
    Output parameter: array<T>
    Output parameter: array<T>
    ARRAY_UNION
    Input parameters: (array<T>, array<T>)
    Input parameters: (array<T>, array<T>)
    Output parameter: array<T>
    Output parameter: array<T>
    ASCII
    Input parameter: string
    Input parameter: string
    Output parameter: int
    Output parameter: int
    ASIN
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    ASINH
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    ASSERT_TRUE
    Input parameter: boolean
    Input parameter: boolean
    Output parameter: null|throws an exception
    Output parameter: null|throws an exception
    ATAN
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    ATAN2
    Input parameters: (bigint|double|decimal, bigint|double|decimal)
    Input parameters: (bigint|double|decimal, bigint|double|decimal)
    Output parameter: double
    Output parameter: double
    ATANH
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    AVG
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    BASE64
    Input parameter: string|binary
    Input parameter: binary
    Output parameter: string
    Output parameter: string
    BIGINT
    Force the type to be converted to bigint.
    Force the type to be converted to bigint.
    BIN
    Input parameter: bigint
    Input parameter: bigint
    Output parameter: string
    Output parameter: string
    BINARY
    Force the type to be converted to binary.
    Force the type to be converted to binary.
    BIT_AND
    Input parameter: int
    Input parameter: int
    Output parameter: int
    Output parameter: int
    BIT_COUNT
    Input parameter: int|boolean
    Input parameter: int|boolean
    Output parameter: int
    Output parameter: int
    BIT_GET
    Input parameters: (int, int)
    Input parameters: (int, int)
    Output parameter: int
    Output parameter: int
    BIT_LENGTH
    Input parameter: string
    Input parameter: string
    Output parameter: int
    Output parameter: int
    BIT_OR
    Input parameter: int
    Input parameter: int
    Output parameter: int
    Output parameter: int
    BIT_XOR
    Input parameter: int
    Input parameter: int
    Output parameter: int
    Output parameter: int
    BOOLEAN
    Force the type to be converted to boolean.
    Force the type to be converted to boolean.
    BOOL_AND
    Input parameter: boolean
    Input parameter: boolean
    Output parameter: boolean
    Output parameter: boolean
    BOOL_OR
    Input parameter: boolean
    Input parameter: boolean
    Output parameter: boolean
    Output parameter: boolean
    BROUND
    Input parameters: (bigint|double|decimal, int)
    Input parameters: (bigint|double|decimal, int)
    Output parameter: int
    Output parameter: int
    BTRIM
    Input parameters: (string[, string])
    Input parameters: (string[, string])
    Output parameter: string
    Output parameter: string
    CARDINALITY
    Input parameter: (array|map)
    Input parameter: (array|map)
    Output parameter: int
    Output parameter: int
    CAST
    Input parameter: (<expr> AS T)
    Input parameter: (<expr> AS T)
    Output parameter: T
    Output parameter: T
    CBRT
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    CEIL
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: bigint
    Output parameter: bigint
    CEILING
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: bigint
    Output parameter: bigint
    CHAR
    Input parameter: int
    Input parameter: int
    Output parameter: string
    Output parameter: string
    CHARACTER_LENGTH
    Input parameter: string|binary
    Input parameter: string
    Output parameter: int
    Output parameter: int
    CHAR_LENGTH
    Input parameter: string|binary
    Input parameter: string
    Output parameter: int
    Output parameter: int
    CHR
    Input parameter: int|double
    Input parameter: int|double
    Output parameter: string
    Output parameter: string
    CLUSTER_SAMPLE
    Input parameters: (bigint [, bigint])
    -
    Output parameter: boolean
    COALESCE
    Input parameters: (T, T, ...)
    Input parameters: (T, T, ...)
    Output parameter: T
    Output parameter: T
    COLLECT_LIST
    Input parameter: T
    Input parameter: T
    Output parameter: array<T>
    Output parameter: array<T>
    COLLECT_SET
    Input parameter: T
    Input parameter: T
    Output parameter: array<T>
    Output parameter: array<T>
    CONCAT
    Input parameter: string|array
    Input parameters: (string|binary, string|binary, ...)
    Output parameters: same as input parameters
    Output parameter: string
    CONCAT_WS
    Input parameters: (string, [string | array<string>]+)
    Input parameters: (string, [string | array<string>]+)
    Output parameter: string
    Output parameter: string
    CONTEXT_NGRAMS
    -
    Input parameters: (array<array<string>>, array<string>, int, int)
    Output parameter: array<struct<string, double>>
    CONV
    Input parameters: (bigint|double|decimal|string, int, int)
    Input parameters: (bigint|double|decimal|string, int, int)
    Output parameter: string
    Output parameter: string
    CORR
    Input parameter: bigint|double|decimal,
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    Output parameter: double
    
    COS
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    COSH
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    COT
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    COUNT
    Input parameter: T
    Input parameter: T
    Output parameter: bigint
    Output parameter: bigint
    COUNT_IF
    Input parameter: boolean
    -
    Output parameter: int
    COUNT_MIN_SKETCH
    Input parameters: (int|binary|string, double, double, int)
    -
    Output parameter: binary
    COVAR_POP
    Input parameters: bigint|double|decimal
    Input parameter: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    COVAR_SAMP
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    CRC32
    Input parameter: string|binary
    Input parameter: string|binary
    Output parameter: bigint
    Output parameter: bigint
    CUME_DIST
    Input parameter: None
    Input parameter: None
    Output parameter: double
    Output parameter: double
    CURRENT_CATALOG
    Input parameter: None
    -
    Output parameter: string
    CURRENT_DATABASE
    Input parameter: None
    -
    Output parameter: string
    CURRENT_DATE
    Input parameter: None
    Input parameter: None
    Output parameter: date
    Output parameter: date
    CURRENT_TIMESTAMP
    Input parameter: None
    Input parameter: None
    Output parameter: timestamp
    Output parameter: timestamp
    CURRENT_TIMEZONE
    Input parameter: None
    Input parameter: None
    Output parameter: string
    Output parameter: string
    CURRENT_USER
    Input parameter: None
    Input parameter: None
    Output parameter: string
    Output parameter: string
    DATE
    Input parameter: string
    Input parameter: string
    Output parameter: date
    Output parameter: date
    DATEDIFF
    Input parameters: (string|timestamp|date, string|timestamp|date)
    Input parameters: (string|timestamp|date, string|timestamp|date)
    Output parameter: int
    Output parameter: int
    DATE_ADD
    Input parameters: (string|date|timestamp, int)
    Input parameters: (string|date|timestamp, int)
    Output parameter: date
    Output parameter: date
    DATEADD
    Input parameters: (date/timestamp, int, string)
    -
    Output parameter: timestamp
    DATE_FORMAT
    Input parameters: (string|date|timestamp, string)
    Input parameters: (string|date|timestamp, string)
    Output parameter: string
    Output parameter: string
    DATE_FROM_UNIX_DATE
    Input parameter: int
    Input parameter: int
    Output parameter: date
    Output parameter: date
    DATE_PART
    Input parameters: (string, string|date|timestamp)
    Input parameters: (string, string|date|timestamp)
    Output parameter: bigint|double|decimal
    Output parameter: bigint|double|decimal
    DATE_SUB
    Input parameter: (string|date|timestamp)
    Input parameter: (string|date|timestamp)
    Output parameter: date
    Output parameter: date
    DATE_TRUNC
    Input parameters: (string, string)
    Input parameters: (string, string)
    Output parameter: timestamp
    Output parameter: timestamp
    DAY
    Input parameter: string|timestamp|date
    Input parameter: string|timestamp|date
    Output parameter: int
    Output parameter: int
    DAYOFMONTH
    Input parameter: string|timestamp|date
    Input parameter: string|timestamp|date
    Output parameter: int
    Output parameter: int
    DAYOFWEEK
    Input parameter: string|timestamp|date
    string|timestamp|date
    Output parameter: int
    Output parameter: int
    DAYOFYEAR
    Input parameter: string|timestamp|date
    string|timestamp|date
    Output parameter: int
    Output parameter: int
    DECIMAL
    cast as decimal
    cast as decimal
    DECODE
    Input parameters: (binary, string) | (int, int, string[, int, string]...[, default])
    Input parameters: (binary, string)
    Output parameter:
    Output parameter: string
    DEGREES
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    DENSE_RANK
    Input parameter: None
    Input parameter: None
    Output parameter: int
    Output parameter: int
    DIV
    Input parameters: bigint|double|decimal
    -
    Output parameter: int
    DOUBLE
    cast as double
    cast as double
    E
    Input parameter: None
    Input parameter: None
    Output parameter: double
    Output parameter: double
    ELEMENT_AT
    Input parameters: (array|map, int)
    Input parameters: (array, int)
    Output parameter: same as array element|map value
    Output parameter: same as array element
    ELT
    Input parameters: (int, T, U,...)
    Input parameters: (int, string, string, ...)
    Output parameter: Depends on the input.
    Output parameter: string
    ENCODE
    Input parameters: (string|binary, string)
    Input parameters: (string, string)
    Output parameter: binary
    Output parameter: binary
    EVERY
    Input parameter: T
    Input parameter: T
    Output parameter: boolean
    Output parameter: boolean
    EXP
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    EXPLODE
    Input parameter: array<T>
    -
    Output parameter: T
    EXPLODE_OUTER
    Input parameter: array<T>
    -
    Output parameter: T
    EXPM1
    Input parameters: bigint|double|decimal
    -
    Output parameter: double
    FACTORIAL
    Input parameter: int
    Input parameter: int
    Output parameter: bigint
    Output parameter: bigint
    FIELD
    -
    Input parameters: (T, T, T, ...)
    Output parameter: int
    FIND_IN_SET
    Input parameters: (string, string)
    Input parameters: (string, string)
    Output parameter: int
    Output parameter: int
    FIRST_VALUE
    Input parameters: (T[, boolean])
    -
    Output parameter: T
    FLATTEN
    Input parameter: array<array<T>>
    Input parameter: array<array<T>>
    Output parameter: array<T>
    Output parameter: array<T>
    FLOAT
    cast as float
    cast as float
    FLOOR
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: bigint
    Output parameter: bigint
    FORMAT_NUMBER
    Input parameters: (bigint|double|decimal, int|string)
    Input parameters: (bigint|double|decimal, int)
    Output parameter: string
    Output parameter: string
    FORMAT_STRING
    Input parameters: (string, T, ...)
    Input parameters: (string, T, ...)
    Output parameter: string
    Output parameter: string
    FROM_CSV
    Input parameters: (string, string[, map])
    -
    Output parameter: struct
    FROM_JSON
    Input parameters: (string, string[, map])
    -
    Output parameter: struct
    FROM_UNIXTIME
    Input parameters: (bigint[, string])
    Input parameters: (bigint[, string])
    Output parameter: string
    Output parameter: string
    FROM_UTC_TIMESTAMP
    Input parameters: (string, string)
    Input parameters: (bigint|double|decimal|timestamp|date|string, string)
    Output parameter: timestamp
    Output parameter: timestamp
    GETBIT
    Input parameters: (int, int)
    Input parameters: (int, int)
    Output parameter: int
    Output parameter: int
    GET_IDCARD_AGE
    Input parameter: string
    -
    Output parameter: int
    GET_IDCARD_BIRTHDAY
    Input parameter: string
    -
    Output parameter: date
    GET_IDCARD_SEX
    Input parameter: string
    -
    Output parameter: string
    GREATEST
    Input parameters: (bigint|double|decimal, bigint|double|decimal, ...)
    Input parameters: (bigint|double|decimal, bigint|double|decimal, ...)
    Output parameter: same as input
    Output parameter: same as input
    GROUPING
    Input parameter: T
    T
    Output parameter: int
    Output parameter: int
    GROUPING_ID
    Input parameters: [T[, T...]]
    -
    Output parameter: int
    HASH
    Input parameters: (T, T,...)
    Input parameters: (T, T,...)
    Output parameter: int
    Output parameter: int
    HEX
    Input parameter: int|string|binary
    Input parameter: int|string|binary
    Output parameter: string
    Output parameter: string
    HISTOGRAM_NUMERIC
    -
    Input parameters: bigint|double|decimal
    Output parameter: array<struct<'x', 'y'>>
    HOUR
    Input parameter: string|timestamp
    Input parameter: string|timestamp
    Output parameter: int
    Output parameter: int
    HYPOT
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    IF
    Input parameters: (boolean, T, T)
    Input parameters: (boolean, T, T)
    Output parameter: T
    Output parameter: T
    IFNULL
    Input parameters: (T, U)
    -
    Output parameter: T|U
    IN
    Input parameters: (T, T,...)
    Input parameters: (T, T,...)
    Output parameter: boolean
    Output parameter: boolean
    INITCAP
    Input parameter: string
    Input parameter: string
    Output parameter: string
    Output parameter: string
    INLINE
    Input parameter: array
    -
    Output parameter: table
    INLINE_OUTER
    Input parameter: array
    -
    Output parameter: table
    INPUT_FILE_BLOCK_LENGTH
    Input parameter: None
    -
    Output parameter: int
    INPUT_FILE_BLOCK_START
    Input parameter: None
    -
    Output parameter: int
    INPUT_FILE_NAME
    Input parameter: None
    -
    Output parameter: string
    INSTR
    Input parameters: (string, string)
    Input parameters: (string, string)
    Output parameter: int
    Output parameter: int
    INT
    Force the type to be converted to int.
    Force the type to be converted to int.
    ISNAN
    Input parameter: T
    Input parameter: T
    Output parameter: boolean
    Output parameter: boolean
    ISNOTNULL
    Input parameter: T
    Input parameter: T
    Output parameter: boolean
    Output parameter: boolean
    ISNULL
    Input parameter: T
    Input parameter: T
    Output parameter: boolean
    Output parameter: boolean
    JSON_ARRAY_LENGTH
    Input parameter: string
    Input parameter: string
    Output parameter: int
    Output parameter: int
    JSON_OBJECT_KEYS
    Input parameter: string
    Input parameter: string
    Output parameter: array
    Output parameter: array
    JSON_TUPLE
    Input parameters: (string, ..., string)
    -
    Output parameter: string...string
    KEYVALUE
    Input parameters: (string [, string, string], string)
    
    Output parameter: string
    KURTOSIS
    Input parameters: bigint|double|decimal
    -
    Output parameter: double
    LAG
    Input parameters: (T[, int[, string]])
    Input parameters: (T[, int[, string]])
    Output parameter: T
    Output parameter: T
    LAST_DAY
    Input parameters: string|date|timestamp
    Input parameter: string|date|timestamp
    Output parameter: string
    Output parameter: string
    LAST_VALUE
    Input parameters: (T[, boolean])
    -
    Output parameter: T
    LCASE
    Input parameter: string
    Input parameter: string
    Output parameter: string
    Output parameter: string
    LEAD
    Input parameters: (T[, int[, string]])
    Input parameters: (T[, int[, string]])
    Output parameter: T
    Output parameter: T
    LEAST
    Input parameters: (bigint|double|decimal, bigint|double|decimal, ...)
    (bigint|double|decimal, bigint|double|decimal, ...)
    Output parameter: same as input
    Output parameter: same as input
    LEFT
    Input parameters: (string, int)
    Input parameters: (string, int)
    Output parameter: string
    Output parameter: string
    LENGTH
    Input parameter: string
    Input parameter: string
    Output parameter: int
    Output parameter: int
    LEVENSHTEIN
    Input parameters: (string, string)
    Input parameters: (string, string)
    Output parameter: int
    Output parameter: int
    LIKE
    Input parameters: (string, string) | string LIKE string ESCAPE string
    Input parameters: (string, string)
    Output parameter: boolean
    Output parameter: boolean
    LN
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    LOCATE
    Input parameters: (string, string[, int])
    Input parameters: (string, string[, int])
    Output parameter: int
    Output parameter: int
    LOG
    Input parameters: (bigint|double|decimal, bigint|double|decimal)
    Input parameters: (bigint|double|decimal, bigint|double|decimal)
    Output parameter: double
    Output parameter: double
    LOG10
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    LOG1P
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    LOG2
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    LOWER
    Input parameter: string
    Input parameter: string
    Output parameter: string
    Output parameter: string
    LPAD
    Input parameters: (string, int[, string])
    Input parameters: (string, int, string)
    Output parameter: string
    Output parameter: string
    LTRIM
    Input parameter: string
    Input parameter: string
    Output parameter: string
    Output parameter: string
    MAKE_DATE
    Input parameters: (int, int, int)
    Input parameters: (int, int, int)
    Output parameter: date
    Output parameter: date
    MAKE_TIMESTAMP
    Input parameters: (int, int, int, int, int, int[, string])
    Input parameters: (int, int, int, int, int, int[, string])
    Output parameter: timestamp
    Output parameter: timestamp
    MAP
    Input parameters: (K1, V1, K2, V2,...)
    Input parameters: (array<K>, array<V>)
    Output parameter: map
    Output parameter: map
    MAP_CONCAT
    Input parameters: (map, ...)
    Input parameters: (map, ...)
    Output parameter: map
    Output parameter: map
    MAP_ENTRIES
    Input parameter: map
    Input parameter: map
    Output parameter: array
    Output parameter: array
    MAP_FROM_ARRAYS
    Input parameters: (array, array)
    Input parameters: (array, array)
    Output parameter: map
    Output parameter: map
    MAP_FROM_ENTRIES
    Input parameter: array
    Input parameter: array
    Output parameter: map
    Output parameter: map
    MAP_KEYS
    Input parameter: map
    Input parameter: map
    Output parameter: array
    Output parameter: array
    MAP_UINON_SUM
    Input parameter: map
    -
    Output parameter: map
    MAP_VALUES
    Input parameter: map
    Input parameter: map
    Output parameter: array
    Output parameter: array
    MAX
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: same as input parameter
    Output parameter: double
    MAX_BY
    Input parameters: T, bigint|double|decimal
    Input parameters: T, bigint|double|decimal
    Output parameter: T
    Output parameter: T
    MAX_PT
    Input parameter: const string
    -
    Output parameter: string
    MD5
    Input parameter: string|binary
    Input parameter: string|binary
    Output parameter: string
    Output parameter: string
    MEAN
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    MIN
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: same as input parameter
    Output parameter: double
    MINUTE
    Input parameters: (stirng|timestamp)
    Input parameters: (stirng|timestamp)
    Output parameter: int
    Output parameter: int
    MIN_BY
    Input parameters: (T, bigint|double|decimal)
    Input parameters: (T, bigint|double|decimal)
    Output parameter: T
    Output parameter: T
    MOD
    Input parameters: (bigint|double|decimal, bigint|double|decimal) | bigint|double|decimal MOD bigint|double|decimal
    Input parameters: (bigint|double|decimal, bigint|double|decimal)
    Output parameters: int|double
    Output parameters: int|double
    MONOTONICALLY_INCREASING_ID
    Input parameter: None
    -
    Output parameter: bigint
    MONTH
    Input parameters: date|timestamp|string
    Input parameters: date|timestamp|string
    Output parameter: int
    Output parameter: int
    MONTHS_BETWEEN
    Input parameters: (date|timestamp|string, date|timestamp|string[, boolean])
    Input parameters: (date|timestamp|string, date|timestamp|string)
    Output parameter: double
    Output parameter: double
    NAMED_STRUCT
    Input parameters: (K1, V1, K2, V2, ...)
    -
    Output parameter: struct
    NANVL
    Input parameters: (bigint|double|decimal, bigint|double|decimal)
    Input parameters: (bigint|double|decimal, bigint|double|decimal)
    Output parameter: double
    Output parameter: double
    NEGATIVE
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: bigint|double|decimal
    Output parameter: int | double
    NEXT_DAY
    Input parameters: (string|date|timestamp, string)
    Input parameters: (string|date|timestamp, string)
    Output parameter: date
    Output parameter: string
    NGRAMS
    -
    Input parameters: (array <array<string>>, int, int, int)
    Output parameter: array<struct<string, double>>
    NOW
    Input parameter: None
    Input parameter: None
    Output parameter: timestamp
    Output parameter: timestamp
    NTH_VALUE
    Input parameters: (T[, int])
    Input parameters: (T[, int])
    Output parameter: T
    Output parameter: T
    NTILE
    Input parameter: int
    Input parameter: int
    Output parameter: int
    Output parameter: int
    NULLIF
    Input parameters: (T, T)
    Input parameters: (T, T)
    Output parameter: T
    Output parameter: T
    NVL
    Input parameters: (T, T)
    Input parameters: (T, T)
    Output parameter: T
    Output parameter: T
    NVL2
    Input parameters: (T, T, T)
    Input parameters: (T, T, T)
    Output parameter: T
    Output parameter: T
    OCTET_LENGTH
    Input parameter: string
    Input parameter: string
    Output parameter: int
    Output parameter: int
    OR
    Input parameter: expr1 OR expr2
    Input parameter: expr1 OR expr2
    Output parameter: boolean
    Output parameter: boolean
    OVERLAY
    Input parameters: (string PLACING string FROM int[ FOR int])
    -
    Output parameter:
    PARSE_URL
    Input parameters: (string, string[, string])
    Input parameters: (string, string[, string])
    Output parameter: string
    Output parameter: string
    PERCENTILE
    Input parameters: (bigint|double|decimal, bigint|double|decimal|array, int)
    Input parameters: (bigint|double|decimal, bigint|double|decimal|array, int)
    Output parameters: bigint|double|decimal|array
    Output parameters: double|array
    PERCENTILE_APPROX
    Input parameters: (bigint|double|decimal, bigint|double|decimal | array[, int])
    Input parameters: (bigint|double|decimal, bigint|double|decimal[, int])
    Output parameter: double|array
    Output parameter: double|array
    PERCENT_RANK
    Input parameter: None
    Input parameter: None
    Output parameter: double
    Output parameter: double
    PI
    Input parameter: None
    Input parameter: None
    Output parameter: double
    Output parameter: double
    PMOD
    Input parameters: (bigint|double|decimal, bigint|double|decimal)
    Input parameters: (bigint|double|decimal, bigint|double|decimal)
    Output parameter: same as input parameter
    Output parameter: same as input parameter
    POSITION
    Input parameters: (string, string[, int]) | (string IN string)
    Input parameters: (string, string[, int]) | (string IN string)
    Output parameter: int
    Output parameter: int
    POSITIVE
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: same as input parameter
    Output parameter: same as input parameter
    POSEXPLODE
    Input parameter: array
    -
    Output parameter: table
    POSEXPLODE_OUTER
    Input parameter: array
    -
    Output parameter: table
    POW
    Input parameters: (bigint|double|decimal, bigint|double|decimal)
    Input parameters: (bigint|double|decimal, bigint|double|decimal)
    Output parameter: double
    Output parameter: double
    POWER
    Input parameters: (bigint|double|decimal, bigint|double|decimal)
    Input parameters: (bigint|double|decimal, bigint|double|decimal)
    Output parameter: double
    Output parameter: double
    PRINTF
    Input parameters: (string, T, ...)
    Input parameters: (string, T, ...)
    Output parameter: string
    Output parameter: string
    QUARTER
    Input parameters: string|date|timestamp
    Input parameters: string|date|timestamp
    Output parameter: int
    Output parameter: int
    RADIANS
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    RAISE_ERROR
    Input parameter: string
    Input parameter: string
    Output parameter: throws an exception
    Output parameter: throws an exception
    RAND
    Input parameter: [int]
    Input parameter: [int]
    Output parameter: double
    Output parameter: double
    RANDN
    Input parameter: [int]
    Input parameter: [long]
    Output parameter: double
    Output parameter: double
    RANDOM
    Input parameter: [int]
    Input parameter: [int]
    Output parameter: double
    Output parameter: double
    RANK
    Input parameter: None
    Input parameter: None
    Output parameter: int
    Output parameter: int
    REGEXP
    Input parameters: (string, string)
    Input parameters: (string, string)
    Output parameter: boolean
    Output parameter: boolean
    REGEXP_COUNT
    Input parameters: (string, string)
    -
    Output parameter: int
    REGEXP_EXTRACT
    Input parameters: (string, string[, int])
    Input parameters: (string, string, int)
    Output parameter: int
    Output parameter: int
    REGEXP_EXTRACT_ALL
    Input parameters: (string, string[, int])
    Input parameters: (string, string[, int])
    Output parameter: array
    Output parameter: array
    REGEXP_LIKE
    Input parameters: (string, string)
    Input parameters: (string, string)
    Output parameter: boolean
    Output parameter: boolean
    REGEXP_REPLACE
    Input parameters: (string, string, string[, int])
    Input parameters: (string, string, string)
    Output parameter: string
    Output parameter: string
    REGEXP_SUBSTR
    Input parameters: (string, string)
    -
    Output parameter: string
    REPEAT
    Input parameters: (string, int)
    Input parameters: (string, int)
    Output parameter: string
    Output parameter: string
    REPLACE
    Input parameters: (string, string[, string])
    Input parameters: (string, string, string)
    Output parameter: string
    Output parameter: string
    REVERSE
    Input parameters: string | array
    Input parameter: string
    Output parameter: string
    Output parameter: string
    RIGHT
    Input parameters: (string, int)
    Input parameters: (string, int)
    Output parameter: string
    Output parameter: string
    RINT
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    RLIKE
    Input parameters: (string, string)
    Input parameters: (string, string)
    Output parameter: boolean
    Output parameter: boolean
    ROUND
    Input parameters: (double, int)
    Input parameters: (double, int)
    Output parameter: double
    Output parameter: double
    ROW_NUMBER
    Input parameter: None
    Input parameter: None
    Output parameter: int
    Output parameter: int
    RPAD
    Input parameters: (string, int[, string])
    Input parameters: (string, int, string)
    Output parameter: string
    Output parameter: string
    RTRIM
    Input parameter: string
    Input parameter: string
    Output parameter: string
    Output parameter: string
    SAMPLE
    Input parameters: (long [, long [, cols...]])
    -
    Output parameter: boolean
    SCHEMA_OF_CSV
    Input parameters: (string[, map])
    
    Output parameter: struct
    SCHEMA_OF_JSON
    Input parameters: (string[, map])
    -
    Output parameter:
    SECOND
    Input parameters: string|timestamp
    Input parameter: string|timestamp
    Output parameter: int
    Output parameter: int
    SENTENCES
    (string[, string, string])
    Input parameters: (string[, string, string])
    Output parameter: array<array<string>>
    Output parameter: array<array<string>>
    SEQUENCE
    Input parameters: (int|bigint|date|timestamp, int|bigint|date|timestamp, int)
    Input parameters: (int|bigint|date|timestamp, int|bigint|date|timestamp, int)
    Output parameter: same as input parameter
    Output parameter: same as input parameter
    SHA
    Input parameter: string|binary
    Input parameter: string|binary
    Output parameter: string
    Output parameter: string
    SHA1
    Input parameters: string|binary
    Input parameter: string|binary
    Output parameter: string
    Output parameter: string
    SHA2
    Input parameters: (string, int)
    Input parameters: (string, int)
    Output parameter: string
    Output parameter: string
    SHIFTLEFT
    Input parameters: (int|bigint, int)
    Input parameters: (int|biging, int)
    Output parameter: int|bigint
    Output parameter: int|bigint
    SHIFTRIGHT
    Input parameters: (int|bigint, int)
    Input parameters: (int|bigint, int)
    Output parameter: int|bigint
    Output parameter: int|bigint
    SHIFTRIGHTUNSIGNED
    Input parameters: (int|bigint, int)
    Input parameters: (int|bigint, int)
    Output parameter: int|bigint
    Output parameters: int|bigint
    SHUFFLE
    Input parameter: array
    Input parameter: array
    Output parameter: array
    Output parameter: array
    SIGN
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    SIGNUM
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    SIN
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    SINH
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    SIZE
    Input parameters: array | map
    Input parameter: array | map
    Output parameter: int
    Output parameter: int
    SKEWNESS
    Input parameters: bigint|double|decimal
    -
    Output parameter: double
    SLICE
    Input parameters: (array, int, int)
    Input parameters: (array, int, int)
    Output parameter: array
    Output parameter: array
    SMALLINT
    cast as smallint
    cast as smallint
    SOME
    Input parameter: boolean
    Input parameter: boolean
    Output parameter: boolean
    Output parameter: boolean
    SORT_ARRAY
    Input parameters: (array[, boolean])
    Input parameter: array
    Output parameter: array
    Output parameter: array
    SOUNDEX
    Input parameter: string
    Input parameter: string
    Output parameter: string
    Output parameter: string
    SPACE
    Input parameter: string
    Input parameter: string
    Output parameter: string
    Output parameter: string
    SPARK_PARTITION_ID
    Input parameter: None
    -
    Output parameter: int
    SPLIT
    Input parameters: (string, string, int)
    Input parameters: (string, string)
    Output parameter: string
    Output parameter: string
    SQRT
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    STACK
    Input parameters: (T, U, ...)
    -
    Output parameter: table
    STD
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    STDDEV
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    STDDEV_POP
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    STDDEV_SAMP
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    STRING
    cast as string
    cast as string
    STRUCT
    Input parameters: (T, U, ...)
    Input parameters: (T, U, ...)
    Output parameter: struct
    Output parameter: struct
    STR_TO_MAP
    Input parameters: (string[, string[, string]])
    Input parameters: (string[, string, string])
    Output parameter: map
    Output parameter: map
    SUBSTR
    Input parameters: (string, int[, int]) | (string FROM int [FOR int])
    Input parameters: (string|binary, int[, int]) | (string|binary FROM int [FOR int])
    Output parameter: string
    Output parameter: string
    SUBSTRING
    Input parameters: (string, int[, int]) | (string FROM int [FOR int])
    Input parameters: (string|binary, int[, int]) | (string|binary FROM int [FOR int])
    Output parameter: string
    Output parameter: string
    SUBSTRING_INDEX
    Input parameters: (string, string, int)
    Input parameters: (string, string, int)
    Output parameter: string
    Output parameter: string
    SUM
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: same as input
    Output parameter: double
    TAN
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    TANH
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    TIMESTAMP
    Input parameter: string
    Input parameter: string
    Output parameter: timestamp
    Output parameter: timestamp
    TIMESTAMP_ADD
    Input parameters: (date/timestamp, int, string)
    
    
    Output parameter: timestamp
    
    TIMESTAMP_MICROS
    Input parameter: bigint
    Input parameter: bigint
    Output parameter: timestamp
    Output parameter: timestamp
    TIMESTAMP_MILLIS
    Input parameter: bigint
    Input parameter: bigint
    Output parameter: timestamp
    Output parameter: timestamp
    TIMESTAMP_SECONDS
    Input parameter: bigint
    Input parameter: bigint
    Output parameter: timestamp
    Output parameter: timestamp
    TIMEZONE_HOUR
    Input parameter: string
    -
    Output parameter: int
    TIMEZONE_MINUTE
    Input parameter: string
    -
    Output parameter: int
    TINYINT
    cast as tinyint
    cast as tinyint
    TO_CHAR
    Input parameters: (boolean|int|long|double|decimal [, string])
    
    
    Output parameter: string
    
    TO_CSV
    Input parameters: (struct[, map])
    -
    Output parameter: string
    TO_DATE
    Input parameters: (string[, string])
    Input parameter: string
    Output parameter: date
    Output parameter: date
    TO_JSON
    Input parameters: (string[, map])
    -
    Output parameter: string
    TO_TIMESTAMP
    Input parameters: (string[, string])
    Input parameter: (string)
    Output parameter: timestamp
    Output parameter: timestamp
    TO_UNIX_TIMESTAMP
    Input parameters: (string[, string])
    Input parameters: (string[, string])
    Output parameter: timestamp
    Output parameter: timestamp
    TO_UTC_TIMESTAMP
    Input parameters: (string[, string])
    Input parameters: (bigint|double|decimal|date|timestamp|string, string)
    Output parameter: timestamp
    Output parameter: timestamp
    TRANS_ARRAY
    Input parameters: (int, string, cols...)
    -
    Output parameter: same as cols type
    TRANS_COLS
    Input parameters: (int, cols...)
    
    Output parameters: (int, cols)
    
    TRANSLATE
    Input parameters: (string, string, string)
    -
    Output parameter: string
    TRIM
    Input parameter: string
    Input parameter: string
    Output parameter: string
    Output parameter: string
    TRUNC
    Input parameters: (string|date|timestamp, string)
    Input parameters: (string|date|timestamp, string)
    Output parameter: string
    Output parameter: string
    TRY_ADD
    Input parameters: (bigint|double|decimal|date|timestamp|, bigint|double|decimal|date|timestamp)
    Input parameters: (bigint|double|decimal, bigint|double|decimal)
    Output parameter: same as input parameter
    Output parameter: same as input parameter
    TRY_DIVIDE
    Input parameters: (bigint|double|decimal, bigint|double|decimal)
    -
    Output parameter: double
    TYPEOF
    Input parameter: T
    Input parameter: T
    Output parameter: string
    Output parameter: string
    UCASE
    Input parameter: string
    Input parameter: string
    Output parameter: string
    Output parameter: string
    UNBASE64
    Input parameter: string
    Input parameter: string
    Output parameter: string
    Output parameter: string
    UNHEX
    Input parameter: string
    Input parameter: string
    Output parameter: binary
    Output parameter: binary
    UNIX_DATE
    Input parameter: string|timestamp|date
    Input parameters: string|timestamp|date
    Output parameter: int
    Output parameter: int
    UNIX_MICROS
    Input parameter: timestamp
    Input parameter: timestamp
    Output parameter: bigint
    Output parameter: bigint
    UNIX_MILLIS
    Input parameter: timestamp
    Input parameter: timestamp
    Output parameter: bigint
    Output parameter: bigint
    UNIX_SECONDS
    Input parameter: timestamp
    Input parameter: timestamp
    Output parameter: bigint
    Output parameter: bigint
    UNIX_TIMESTAMP
    Input parameters: [date|timestamp|string[, string]]
    Input parameters: (date|timestamp|string[, string])
    Output parameter: bigint
    Output parameter: bigint
    UPPER
    Input parameter: string
    Input parameter: string
    Output parameter: string
    Output parameter: string
    URL_DECODE
    Input parameter: string
    -
    Output parameter: string
    UUID
    Input parameter: none
    Input parameter: None
    Output parameter: string
    Output parameter: string
    VARIANCE
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    VAR_POP
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    VAR_SAMP
    Input parameters: bigint|double|decimal
    Input parameters: bigint|double|decimal
    Output parameter: double
    Output parameter: double
    VERSION
    Input parameter: None
    Input parameter: None
    Output parameter: string
    Output parameter: string
    WEEKDAY
    Input parameters: date|timestamp|string
    Input parameters: date|timestamp|string
    Output parameter: int
    Output parameter: int
    WEEKOFYEAR
    Input parameters: date|timestamp|string
    Input parameters: date|timestamp|string
    Output parameter: int
    Output parameter: int
    WIDTH_BUCKET
    Input parameters: (bigint|double|decimal, bigint|double|decimal, bigint|double|decimal, int)
    Input parameters: (bigint|double|decimal, bigint|double|decimal, bigint|double|decimal, int)
    Output parameter: int
    Output parameter: int
    WINDOW
    Input parameters: (date|timestamp, string[, string[, string]])
    -
    Output parameter: table
    XPATH
    Input parameters: (string, string)
    Input parameters: (string, string)
    Output parameter: array
    Output parameter: array
    XPATH_BOOLEAN
    Input parameters: (string, string)
    Input parameters: (string, string)
    Output parameter: boolean
    Output parameter: boolean
    XPATH_DOUBLE
    Input parameters: (string, string)
    Input parameters: (string, string)
    Output parameter: double
    Output parameter: double
    XPATH_FLOAT
    Input parameters: (string, string)
    Input parameters: (string, string)
    Output parameter: float
    Output parameter: float
    XPATH_INT
    Input parameters: (string, string)
    Input parameters: (string, string)
    Output parameter: int
    Output parameter: int
    XPATH_LONG
    Input parameters: (string, string)
    Input parameters: (string, string)
    Output parameter: bigint
    Output parameter: bigint
    XPATH_NUMBER
    Input parameters: (string, string)
    Input parameters: (string, string)
    Output parameter: double
    Output parameter: double
    XPATH_STRING
    Input parameters: (string, string)
    Input parameters: (string, string)
    Output parameter: string
    Output parameter: string
    XXHASH64
    Input parameters: (T, U, ...)
    Input parameters: (T, U, ...)
    Output parameter: bigint
    Output parameter: bigint
    YEAR
    Input parameters: date|timestamp|string
    Input parameter: date|timestamp|string
    Output parameter: int
    Output parameter: int
    
    
    
    Contact Us

    Contact our sales team or business advisors to help your business.

    Contact Us
    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    Submit a Ticket
    7x24 Phone Support
    Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
    Privacy PolicyLegalCookie Policy