Enterprise docs

Athena aggregation support

Aggregation	Support
approx_distinct	Natively Supported
approx_median	Natively Supported
approx_percentile	Natively Supported
arbitrary	Natively Supported
array_agg	Natively Supported
avg	Natively Supported
bool_and	Natively Supported
bool_or	Natively Supported
checksum	Natively Supported
correlation	Natively Supported
count	Natively Supported
count(*)	Natively Supported
count_if	Natively Supported
covar_pop	Natively Supported
covar_samp	Natively Supported
group_concat	Natively Supported
kurtosis	Natively Supported
max	Natively Supported
max_by	Natively Supported
min	Natively Supported
min_by	Natively Supported
regr_avgx	Natively Supported (DISTINCT emulated)
regr_avgy	Natively Supported (DISTINCT emulated)
regr_count	Natively Supported (DISTINCT emulated)
regr_intercept	Natively Supported
regr_r2	Natively Supported (DISTINCT emulated)
regr_slope	Natively Supported
regr_sxx	Natively Supported (DISTINCT emulated)
regr_sxy	Natively Supported (DISTINCT emulated)
regr_syy	Natively Supported (DISTINCT emulated)
skewness	Natively Supported
std_pop	Natively Supported
std_samp	Natively Supported
stdev	Natively Supported
sum	Natively Supported
var_pop	Natively Supported
var_samp	Natively Supported
variance	Natively Supported

Athena function support

Function	Support
abs	Natively Supported
acos	Natively Supported
array	Natively Supported
array_append	Natively Supported
array_concat	Natively Supported
array_contains	Natively Supported
array_join	Natively Supported
array_length	Natively Supported
array_prepend	Natively Supported
asin	Natively Supported
at_time_zone	Emulated
atan	Natively Supported
atan2	Natively Supported
attr_of	Emulated
ceiling	Natively Supported
char	Emulated
coalesce	Natively Supported
concat	Natively Supported
cos	Natively Supported
cosh	Natively Supported
current_user	Emulated
date_add	Emulated
date_diff	Natively Supported
date_format	Emulated
date_parse	Emulated
date_part	Emulated
date_sub	Emulated
date_trunc	Natively Supported
day	Natively Supported
degrees	Natively Supported
element_at	Natively Supported
exp	Natively Supported
exp10	Natively Supported
floor	Natively Supported
get_path	Emulated
greatest	Natively Supported
hours	Natively Supported
iri_of	Emulated
json_extract_scalar	Natively Supported
label_of	Emulated
least	Natively Supported
left	Natively Supported
length	Natively Supported
like	Natively Supported
log	Natively Supported
log10	Natively Supported
lower	Natively Supported
lpad	Natively Supported
ltrim	Natively Supported
md5	Natively Supported
mid	Natively Supported
minutes	Natively Supported
mod	Natively Supported
month	Natively Supported
now	Natively Supported
pi	Natively Supported
position	Natively Supported
pow	Natively Supported
radians	Natively Supported
rand	Natively Supported
random	Natively Supported
regex	Emulated
regexp_extract	Natively Supported
replace	Natively Supported
right	Natively Supported
round	Natively Supported
rpad	Natively Supported
rtrim	Natively Supported
seconds	Natively Supported
sha1	Natively Supported
sha256	Natively Supported
sha384	Emulated
sha512	Natively Supported
sign	Natively Supported
sin	Natively Supported
sinh	Natively Supported
sqrt	Natively Supported
string_split	Emulated
substring	Natively Supported
tan	Natively Supported
tanh	Natively Supported
trim	Natively Supported
upper	Natively Supported
url_extract_fragment	Natively Supported
url_extract_host	Natively Supported
url_extract_parameter	Natively Supported
url_extract_path	Natively Supported
url_extract_port	Natively Supported
url_extract_protocol	Natively Supported
url_extract_query	Natively Supported
year	Natively Supported

In this section:

Was this helpful?

Would you like to provide feedback? Just click here to suggest edits.