Which columnar storage format is best for Amazon Athena?
💡 Model Answer
Amazon Athena performs best with columnar storage formats because they allow the engine to read only the columns needed for a query, reducing I/O and cost. Parquet is the most widely used columnar format on Athena. It stores data in a binary, column-oriented format that supports efficient compression and encoding schemes such as dictionary encoding and bit packing. These features dramatically reduce storage size and improve query performance. Parquet also integrates seamlessly with the AWS Glue Data Catalog, enabling Athena to discover schemas automatically. While other formats like Avro, JSON, and CSV can be queried, they are row-oriented or lack the compression and schema evolution benefits that Parquet provides, making Parquet the optimal choice for Athena workloads.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.
Get Assisting AI — Starts at ₹500