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

Topics

SELECT
INSERT INTO
Using the EXPLAIN Statement in Athena
Presto Functions in Amazon Athena
Supported Time Zones

Warning Javascript is disabled or is unavailable in your browser.

To use the AWS Documentation, Javascript must be enabled. Please refer to your browser's Help pages for instructions.

Document Conventions

Data Types in Athena

SELECT