DML queries, functions, and operators

Athena DML query statements are based on Presto 0.172 for Athena engine version 1 and 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 of Presto's 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
• UNLOAD
• Using EXPLAIN and EXPLAIN ANALYZE in Athena
• Functions in Amazon Athena
• Supported time zones