Skip to main content

Athena aggregation support

Table 1.

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