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.

• 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

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.

• 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