Presto Functions in Amazon Athena

Athena supports some, but not all, of Presto's 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.

• 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.

• 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