Amazon Athena
User Guide  | API Reference

May 19, 2017

Published on 2017-05-18

Added an Amazon Athena API and AWS CLI support for Athena; updated JDBC driver to version 1.1.0; fixed various issues.

Features#

Important Guidance for Customer-Managed and Inline IAM Policy Users#

Actions specific to policy statements in earlier versions of Athena have been deprecated. If you upgrade to JDBC driver version 1.1.0 and have customer-managed or inline IAM policies attached to JDBC users, you must update the IAM policies. In contrast, earlier versions of the JDBC driver do not support the Athena API, so you can specify only deprecated actions in policies attached to earlier version JDBC users. For this reason, you shouldn't need to update customer-managed or inline IAM policies.

Deprecated Policy-Specific Actions for JDBC Driver Versions Prior to 1.1.0#

These policy-specific actions were used in Athena before the release of the Athena API. Use these deprecated actions in policies only with JDBC drivers earlier than version 1.1.0. If you are upgrading the JDBC driver, replace policy statements that allow or deny deprecated actions with the appropriate API actions as listed or errors will occur:

Deprecated Policy-Specific Action Corresponding Athena API Action
athena:RunQuery athena:StartQueryExecution
athena:CancelQueryExecution athena:StopQueryExecution
athena:GetQueryExecutions athena:ListQueryExecutions

Policy-Specific Actions for All JDBC Driver Users, Regardless of Version#

Regardless of JDBC Driver version, you must allow JDBC users to perform a set of policy-specific actions. These actions are not part of the Athena API. If the following actions are not allowed, users will be unable to see databases and tables:

  • athena:GetCatalogs
  • athena:GetExecutionEngine
  • athena:GetExecutionEngines
  • athena:GetNamespace
  • athena:GetNamespaces
  • athena:GetTable
  • athena:GetTables

Improvements#

  • Increased the query string length limit to 256 KB.

Bug Fixes#

  • Fixed an issue that caused query results to look malformed when scrolling through results in the console.
  • Fixed an issue where \u0000 character string in Amazon S3 data files would cause errors.
  • Fixed an issue that caused requests to cancel a query made through the JDBC driver to fail.
  • Fixed an issue that caused the Amazon CloudTrail SerDe to fail with Amazon S3 data in us-east-2.
  • Fixed an issue that caused DROP TABLE to fail on a partitioned table.

On this page: