Amazon Athena
User Guide

Compression Formats

Athena supports the following compression formats:

Note

The compression formats listed in this section are used for CREATE TABLE queries. For CTAS queries, Athena supports GZIP and SNAPPY (for data stored in Parquet and ORC). If you omit a format, GZIP is used by default. For more information, see CREATE TABLE AS.

  • SNAPPY. This is the default compression format for files in the Parquet data storage format.

  • ZLIB. This is the default compression format for files in the ORC data storage format.

  • LZO

  • GZIP. Use the GZIP compression in Athena for querying Amazon Kinesis Data Firehose logs. Athena and Amazon Kinesis Data Firehose each support different versions of SNAPPY, so GZIP is the only compatible format.