Functions in Amazon Athena

Athena supports some, but not all, Trino and Presto functions. For information, see Considerations and limitations. For a list of the time zones that can be used with the AT TIME ZONE operator, see Supported time zones.

Athena engine version 3

Functions in Athena engine version 3 are based on Trino. For information about Trino functions, operators, and expressions, see Functions and operators and the following subsections from the Trino documentation.

• Aggregate

• Array

• Binary

• Bitwise

• Color

• Comparison

• Conditional

• Conversion

• Date and time

• Decimal

• Geospatial

• HyperLogLog

• IP Address

• JSON

• Lambda

• Logical

• Machine learning

• Map

• Math

• Quantile digest

• Regular expression

• Session

• Set Digest

• String

• System

• Table

• Teradata

• T-Digest

• URL

• UUID

• Window

Athena engine version 2

Functions in Athena engine version 2 are based on Presto 0.217. For the geospatial functions in Athena engine version 2, see Geospatial functions in Athena engine version 2.

Note

Version-specific documentation for Presto 0.217 functions is no longer available. For information about current Presto functions, operators, and expressions, see Presto functions and operators, or visit the subcategory links in this section.

• Logical operators

• Comparison functions and operators

• Conditional expressions

• Conversion functions

• Mathematical functions and operators

• Bitwise functions

• Decimal functions and operators

• String functions and operators

• Binary functions

• Date and time functions and operators

• Regular expression functions

• JSON functions and operators

• URL functions

• Aggregate functions

• Window functions

• Color functions

• Array functions and operators

• Map functions and operators

• Lambda expressions and functions

• Teradata functions