Use Amazon Athena with Spark SQL for your open-source transactional table formats
Big Data Blog
This article provides a guide on using Apache Spark SQL in Amazon Athena to work with open-source transactional table formats like Apache Iceberg, Apache Hudi, and Linux Foundation Delta Lake.
Specifically, the article covers:
- Prerequisites for setting up the environment
- Working with Apache Iceberg tables (creating, inserting, querying, updating, compacting, and managing snapshots)
- Working with Apache Hudi tables (creating, inserting, querying, updating, time travel queries, clustering, and compacting)
- Working with Delta Lake tables (creating, inserting, querying, updating, compacting, and removing unreferenced files)
- Conclusion highlighting the benefits of using these open table formats with Amazon Athena
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Aug 15
2025
2025
Transform your data to Amazon S3 Tables with Amazon Athena
Feb 20
2024
2024
Reference guide to analyze transactional data in near-real time on AWS
Nov 22
2025
2025
Amazon Athena for Apache Spark is now available in Amazon SageMaker notebooks
Aug 15
2025
2025
Amazon Athena now supports CREATE TABLE AS SELECT with Amazon S3 Tables
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.