What file formats does Athena support?
💡 Model Answer
Amazon Athena supports a variety of columnar and row‑based file formats. The most common are CSV, JSON, Parquet, ORC, and Avro. It also accepts plain text and XML. Athena can read compressed files in GZIP, Snappy, LZO, BZIP2, and ZSTD. Parquet, ORC, and Avro are preferred for analytics because they store schema and allow predicate pushdown, which reduces scan size and improves query performance. When choosing a format, consider the trade‑off between storage cost, query speed, and compatibility with downstream tools.
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 — invisible to screen sharing.
Get Assisting AI — Starts at ₹500