Functions in Amazon Athena - Amazon Athena

Functions in Amazon Athena

Athena supports some, but not all, Presto and Trino functions and features. 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 2

Athena engine version 2 is based on Presto 0.217. For information about related functions, operators, and expressions, see Presto 0.217 Functions and Operators and the following specific sections from the Presto documentation. For the geospatial functions in Athena engine version 2, see Geospatial Functions in Athena engine version 2.

Athena engine version 1

Athena engine version 1 is based on Presto 0.172. For information about related functions, operators, and expressions, see Presto 0.172 Functions and Operators and the following specific sections from the Presto documentation. For the geospatial functions in Athena engine version 1, see Geospatial Functions in Athena engine version 1.