Menu
Amazon Athena
User Guide

Document History

This documentation is associated with the May, 18, 2017 version of Amazon Athena.

Latest documentation update: April 19, 2018.

Change Description Release Date
Released the JDBC driver version 2.0.2.

Released the new version of the JDBC driver (version 2.0.2). For information, see Using Athena with the JDBC Driver.

April 19, 2018

Added auto-complete for typing queries in the Athena console.

Added auto-complete for typing queries in the Athena console.

April 6, 2018

Added an ability to create Athena tables for CloudTrail log files directly from the CloudTrail console.

Added an ability to automatically create Athena tables for CloudTrail log files directly from the CloudTrail console. For information, see Creating a Table for CloudTrail Logs in the CloudTrail Console.

March 15, 2018
Added support for securely offloading intermediate data to disk for queries with GROUP BY. Added an ability to securely offload intermediate data to disk for memory-intensive queries that use the GROUP BY clause. This improves the reliability of such queries, preventing "Query resource exhausted" errors. For more information, see the release note for February 2, 2018. February 2, 2018
Added support for Presto version 0.172. Upgraded the underlying engine in Amazon Athena to a version based on Presto version 0.172. For more information, see the release note for January 19, 2018. January 19, 2018
Added support for the ODBC Driver. Added support for connecting Athena to the ODBC Driver. For information, see Connecting to Amazon Athena with ODBC. November 13, 2017
Added support for Asia Pacific (Seoul), Asia Pacific (Mumbai), and EU (London) regions. Added support for querying geospatial data. Added support for querying geospatial data, and for Asia Pacific (Seoul), Asia Pacific (Mumbai), EU (London) regions. For information, see Querying Geospatial Data and AWS Regions and Endpoints. November 1, 2017
Added support for EU (Frankfurt). Added support for EU (Frankfurt). For a list of supported regions, see AWS Regions and Endpoints. October 19, 2017
Added support for named Athena queries with AWS CloudFormation. Added support for creating named Athena queries with AWS CloudFormation. For more information, see AWS::Athena::NamedQuery in the AWS CloudFormation User Guide. October 3, 2017
Added support for Asia Pacific (Sydney). Added support for Asia Pacific (Sydney). For a list of supported regions, see AWS Regions and Endpoints. September 25, 2017
Added a section to this guide for querying AWS Service logs and different types of data, including maps, arrays, nested data, and data containing JSON. Added examples for Querying AWS Service Logs and for querying different types of data in Athena. For information, see Querying Data in Amazon Athena Tables. September 5, 2017
Added support for AWS Glue Data Catalog. Added integration with the AWS Glue Data Catalog and a migration wizard for updating from the Athena managed data catalog to the AWS Glue Data Catalog. For more information, see Integration with AWS Glue and AWS Glue. August 14, 2017
Added support for Grok SerDe. Added support for Grok SerDe, which provides easier pattern matching for records in unstructured text files such as logs. For more information, see Grok SerDe. Added keyboard shortcuts to scroll through query history using the console (CTRL + ⇧/⇩ using Windows, CMD + ⇧/⇩ using Mac). August 4, 2017
Added support for Asia Pacific (Tokyo). Added support for Asia Pacific (Tokyo) and Asia Pacific (Singapore). For a list of supported regions, see AWS Regions and Endpoints. June 22, 2017
Added support for EU (Ireland). Added support for EU (Ireland). For more information, see AWS Regions and Endpoints. June 8, 2017
Added an Amazon Athena API and AWS CLI support. Added an Amazon Athena API and AWS CLI support for Athena. Updated JDBC driver to version 1.1.0. May 19, 2017
Added support for Amazon S3 data encryption. Added support for Amazon S3 data encryption and released a JDBC driver update (version 1.0.1) with encryption support, improvements, and bug fixes. For more information, see Configuring Encryption Options. April 4, 2017
Added the AWS CloudTrail SerDe. Added the AWS CloudTrail SerDe, improved performance, fixed partition issues. For more information, see CloudTrail SerDe.
  • Improved performance when scanning a large number of partitions.

  • Improved performance on MSCK Repair Table operation.

  • Added ability to query Amazon S3 data stored in regions other than your primary region. Standard inter-region data transfer rates for Amazon S3 apply in addition to standard Athena charges.

March 24, 2017
Added support for US East (Ohio). Added support for Avro SerDe and OpenCSVSerDe for Processing CSV, US East (Ohio), and bulk editing columns in the console wizard. Improved performance on large Parquet tables. February 20, 2017
The initial release of the Amazon Athena User Guide. November, 2016