Amazon Athena

User Guide

What is Amazon Athena?
Release Notes
- October 15, 2018
- October 10, 2018
- September 6, 2018
- August 23, 2018
- August 16, 2018
- August 7, 2018
- June 5, 2018
- May 17, 2018
- April 19, 2018
- April 6, 2018
- March 15, 2018
- February 2, 2018
- January 19, 2018
- November 13, 2017
- November 1, 2017
- October 19, 2017
- October 3, 2017
- September 25, 2017
- August 14, 2017
- August 4, 2017
- June 22, 2017
- June 8, 2017
- May 19, 2017
- April 4, 2017
- March 24, 2017
- February 20, 2017
Setting Up
Getting Started
Accessing Amazon Athena
Integration with AWS Glue
- Upgrading to the AWS Glue Data Catalog Step-by-Step
- FAQ: Upgrading to the AWS Glue Data Catalog
- Best Practices When Using Athena with AWS Glue
Connecting to Amazon Athena with ODBC and JDBC Drivers
- Using Athena with the JDBC Driver
- Connecting to Amazon Athena with ODBC
Security
- Access Control Policies
- Configuring Encryption Options
Working with Source Data
- Tables and Databases Creation Process in Athena
- Names for Tables, Databases, and Columns
- Reserved Keywords
- Table Location in Amazon S3
- Partitioning Data
- Columnar Storage Formats
- Converting to Columnar Formats
Querying Data in Amazon Athena Tables
- Query Results
- Viewing Query History
- Views
- Creating a Table from Query Results (CTAS)
- Querying Arrays
- Querying Arrays with Complex Types and Nested Structures
- Querying Arrays with Maps
- Querying JSON
Querying Geospatial Data
- What is a Geospatial Query?
- Input Data Formats and Geometry Data Types
- List of Supported Geospatial Functions
- Examples: Geospatial Queries
Querying AWS Service Logs
- Querying AWS CloudTrail Logs
- Querying Amazon CloudFront Logs
- Querying Classic Load Balancer Logs
- Querying Application Load Balancer Logs
- Querying Amazon VPC Flow Logs
Handling Schema Updates
- Types of Updates
- Updates in Tables with Partitions
Monitoring Logs and Troubleshooting
- Logging Amazon Athena API Calls with AWS CloudTrail
- Troubleshooting
SerDe Reference
- Using a SerDe
- Supported SerDes and Data Formats
- Compression Formats
DDL and SQL Reference
- Data Types
- DDL Statements
- SQL Queries, Functions, and Operators
  - SELECT
- Unsupported DDL
- Limitations
Code Samples, Service Limits, and Previous JDBC Driver
- Code Samples
- Using the Previous Version of the JDBC Driver
- Service Limits
Document History
AWS Glossary

Troubleshooting

Use these resources to troubleshoot problems with Amazon Athena.

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

« Previous Next »

© 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved.