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: