Athena can now write query results in Parquet, Avro, ORC and JSON formats

Amazon Athena now lets you store results in the format that best fits your analytics use case. Using Athena’s new UNLOAD statement, you can format results in your choice of Parquet, Avro, ORC, JSON or delimited text. Athena’s SQL-based interface and support for open formats are well suited for creating extract, transform, and load (ETL) pipelines that prepare your data for downstream analytics processing.

Source:: Amazon AWS