Search
K
Links

Compound Attribute Whitelisted Functions

Aggregated functions are not supported in compound attributes.
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,