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,
Last modified 10d ago