DML queries, functions, and operators

Athena DML query statements are based on Presto 0.217 for Athena engine version 2. For information about Athena engine versions, see Athena engine versioning.

For links to subsections of the Presto function documentation, see Functions.

Athena does not support all Presto and Trino features, and there are some significant differences. For more information, see the topics for specific statements in this section and Considerations and limitations.

For information about DDL statements, see DDL statements. For a list of unsupported DDL statements, see Unsupported DDL.

Topics

• SELECT
• INSERT INTO
• PREPARE
• UNLOAD
• Using EXPLAIN and EXPLAIN ANALYZE in Athena
• Functions in Amazon Athena
• Supported time zones