List of Supported Functions

Below is a list of whitelisted functions:

// misc non-aggregate functions
        abs,
        coalesce,
        explode,
        explode_outer,
        greatest,
        if,
        inline,
        inline_outer,
        isnan,
        ifnull,
        isnull,
        isnotnull,
        least,
        nanvl,
        nullif,
        nvl,
        nvl2,
        posexplode,
        posexplode_outer,
        rand,
        random,
        randn,
        stack,
        when,

// math functions
        acos,
        acosh,
        asin,
        asinh,
        atan,
        atan2,
        atanh,
        bin,
        bround,
        cbrt,
        ceil,
        ceiling,
        cos,
        sec,
        cosh,
        conv,
        degrees,
        e,
        exp,
        expm1,
        floor,
        factorial,
        hex,
        hypot,
        log,
        log10,
        log1p,
        log2,
        ln,
        mod,
        negative,
        pi,
        pmod,
        positive,
        pow,
        power,
        radians,
        rint,
        round,
        shiftleft,
        shiftright,
        shiftrightunsigned,
        sign,
        signum,
        sin,
        csc,
        sinh,
        str_to_map,
        sqrt,
        tan,
        cot,
        tanh,
        width_bucket,
        try_add,
        try_divide,
        try_subtract,
        try_multiply,
        try_element_at,
        try_avg,
        try_sum,
        try_to_binary,
        
// string functions
        ascii,
        char,
        chr,
        contains,
        startswith,
        endswith,
        base64,
        bit_length,
        char_length,
        character_length,
        concat_ws,
        decode,
        elt,
        encode,
        find_in_set,
        format_number,
        format_string,
        to_number,
        try_to_number,
        get_json_object,
        initcap,
        instr,
        lcase,
        length,
        levenshtein,
        like,
        ilike,
        lower,
        octet_length,
        locate,
        lpad,
        ltrim,
        json_tuple,
        parse_url,
        position,
        printf,
        regexp_extract,
        regexp_extract_all,
        regexp_replace,
        repeat,
        replace,
        overlay,
        rlike,
        regexp_like,
        regexp,
        rpad,
        rtrim,
        sentences,
        soundex,
        space,
        split,
        split_part,
        substr,
        substring,
        left,
        right,
        substring_index,
        translate,
        trim,
        btrim,
        ucase,
        unbase64,
        unhex,
        upper,
        xpath,
        xpath_boolean,
        xpath_double,
        xpath_number,
        xpath_float,
        xpath_int,
        xpath_long,
        xpath_short,
        xpath_string,
        
// datetime functions
        add_months,
        current_date,
        current_timestamp,
        current_timezone,
        datediff,
        date_add,
        date_format,
        date_sub,
        day,
        dayofyear,
        dayofmonth,
        from_unixtime,
        from_utc_timestamp,
        hour,
        last_day,
        minute,
        month,
        months_between,
        next_day,
        now,
        quarter,
        second,
        to_timestamp,
        to_date,
        to_binary,
        to_unix_timestamp,
        to_utc_timestamp,
        trunc,
        date_trunc,
        unix_timestamp,
        dayofweek,
        weekday,
        weekofyear,
        year,
        window,
        session_window,
        make_date,
        make_timestamp,
        make_interval,
        make_dt_interval,
        make_ym_interval,
        extract,
        date_part,
        date_from_unix_date,
        unix_date,
        timestamp_seconds,
        timestamp_millis,
        timestamp_micros,
        unix_seconds,
        unix_millis,
        unix_micros,
        
// collection functions
        concat,
        
// misc functions
        assert_true,
        raise_error,
        crc32,
        md5,
        uuid,
        hash,
        xxhash64,
        sha,
        sha1,
        sha2,
        aes_encrypt,
        aes_decrypt,
        spark_partition_id,
        input_file_name,
        input_file_block_start,
        input_file_block_length,
        monotonically_increasing_id,
        current_database,
        current_catalog,
        current_user,
        reflect,
        java_method,
        version,
        typeof,
        
// bitwise
        bit_count,
        bit_and,
        bit_or,
        bit_xor,
        bit_get,
        getbit,
        
// json
        to_json,
        from_json,
        schema_of_json,
        json_array_length,
        json_object_keys,
        
// cast
        cast,
        
// Cast aliases
        boolean,
        tinyint,
        smallint,
        int,
        bigint,
        float,
        double,
        decimal,
        date,
        timestamp,
        binary,
        string,

Last updated