

# Choose a SerDe for your data
<a name="supported-serdes"></a>

The following table lists the data formats supported in Athena and their corresponding SerDe libraries.


**Supported data formats and SerDes**  

| Data format | Description | SerDe types supported in Athena | 
| --- | --- | --- | 
| Amazon Ion | Amazon Ion is a richly-typed, self-describing data format that is a superset of JSON, developed and open-sourced by Amazon. | Use the [Amazon Ion Hive SerDe](ion-serde.md). | 
| Apache Avro | A format for storing data in Hadoop that uses JSON-based schemas for record values. | Use the [Avro SerDe](avro-serde.md). | 
| Apache Parquet | A format for columnar storage of data in Hadoop. | Use the [Parquet SerDe](parquet-serde.md) and SNAPPY compression. | 
| Apache WebServer logs | A format for storing logs in Apache WebServer. | Use the [Grok SerDe](grok-serde.md) or [Regex SerDe](regex-serde.md). | 
| CloudTrail logs | A format for storing logs in CloudTrail. |  [See the AWS documentation website for more details](http://docs.aws.amazon.com/athena/latest/ug/supported-serdes.html)  | 
| CSV (Comma-Separated Values) | For data in CSV, each line represents a data record, and each record consists of one or more fields, separated by commas. |  [See the AWS documentation website for more details](http://docs.aws.amazon.com/athena/latest/ug/supported-serdes.html)  | 
| Custom-Delimited | For data in this format, each line represents a data record, and records are separated by a custom single-character delimiter. | Use the [Lazy Simple SerDe for CSV, TSV, and custom-delimited files](lazy-simple-serde.md) and specify a custom single-character delimiter. | 
| JSON (JavaScript Object Notation) | For JSON data, each line represents a data record, and each record consists of attribute-value pairs and arrays, separated by commas. |  [See the AWS documentation website for more details](http://docs.aws.amazon.com/athena/latest/ug/supported-serdes.html)  | 
| Logstash logs | A format for storing logs in Logstash. | Use the [Grok SerDe](grok-serde.md). | 
| ORC (Optimized Row Columnar) | A format for optimized columnar storage of Hive data. | Use the [ORC SerDe](orc-serde.md) and ZLIB compression. | 
| TSV (Tab-Separated Values) | For data in TSV, each line represents a data record, and each record consists of one or more fields, separated by tabs. | Use the [Lazy Simple SerDe for CSV, TSV, and custom-delimited files](lazy-simple-serde.md) and specify the separator character as `FIELDS TERMINATED BY '\t'`. | 