AWS Documentation » Amazon Athena » User Guide » DDL and SQL Reference » SQL Queries, Functions, and Operators

SQL Queries, Functions, and Operators

Use the following functions directly in Athena.

Amazon Athena query engine is based on Presto 0.172. For more information about these functions, see Presto 0.172 Functions and Operators.

Athena does not support all of Presto's features. For information, see Limitations.

• SELECT

• 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