Skip to main content

Athena function support

Table 1.

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