# Amazon EMR plus Athena on Iceberg, Spark and SQL engines on AWS: the published facts

Platform profile, read 10 Nov 2026

**The short answer.** Amazon EMR runs open-source Spark on EC2, EKS or Serverless, and Athena queries Iceberg tables in the AWS Glue Data Catalog. AWS describes the EMR runtime as 100% API-compatible with open-source Spark. EMR 7.x lists Spark 3.5.x builds, and S3 Tables compaction is on by default with a 512 MB target file size.

- **Kind:** Spark and SQL engines on AWS
- **Website:** [aws.amazon.com/emr](https://aws.amazon.com/emr/)
- **Name checked:** Amazon EMR, Amazon Athena, AWS Glue and Amazon S3 Tables all still exist under these names; EMR 7.x lists Spark 3.5.x and the EMR Spark page lists Spark 4.0 and Iceberg v3 support.
- **Read:** 10 Nov 2026

## What it does well

- Per AWS documentation, the EMR runtime for Spark is 100% API-compatible with open-source Spark, so existing jobs need no rewrite (read 2026-11-10).
- AWS publishes the setup for its TPC-DS 3 TB Iceberg benchmark in GitHub repositories, so a reader can repeat the run (read 2026-11-10).

## Where it is limited

- Per AWS documentation, Athena compaction is manual (you run OPTIMIZE ... REWRITE DATA USING BIN_PACK and VACUUM), and Glue Iceberg compaction is off by default for new tables.
- Every service in this entry runs only on AWS, and Athena supports Iceberg 1.4.2 only for tables in the Glue Data Catalog (read 2026-11-10).

## Published speed results

| Fact | Source type | Source, read |
| --- | --- | --- |
| AWS states its runtime executes up to 4.5x faster than open-source Spark and gives 2.7x faster Iceberg write performance; the page gives no workload, scale or configuration. | vendor | [aws.amazon.com/emr/features/spark](https://aws.amazon.com/emr/features/spark/), 10 Nov 2026 |

## Published prices and cost results

| Fact | Source type | Source, read |
| --- | --- | --- |
| EMR on EC2 adds a per-instance uplift in addition to EC2: the AWS price list shows $0.048 per hour for EMR m5.xlarge in us-east-1 (publication 2026-11-10). | cloud provider docs | [pricing.us-east-1.amazonaws.com/offers/v1.0/aws/ElasticMapReduce/current](https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/ElasticMapReduce/current/index.json), 10 Nov 2026 |
| EMR on EKS uplift in us-east-1 is $0.007084 per vCPU-hour and $0.000777875 per GB-hour, in addition to the EC2 or Fargate cost. | cloud provider docs | [pricing.us-east-1.amazonaws.com/offers/v1.0/aws/ElasticMapReduce/current](https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/ElasticMapReduce/current/index.json), 10 Nov 2026 |
| The EMR pricing page worked example for EMR Serverless uses $0.052624 per vCPU-hour and $0.0057785 per GB-hour; a job with 100 vCPU for 30 minutes plus 200 more vCPU for 15 minutes costs $9.596275 in that example. | cloud provider docs | [aws.amazon.com/emr/pricing](https://aws.amazon.com/emr/pricing/), 10 Nov 2026 |
| Athena SQL costs $5.00 per TB scanned in us-east-1; Athena for Apache Spark costs $0.35 per DPU-hour; provisioned capacity costs $0.30 per DPU-hour. | cloud provider docs | [pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonAthena/current/ind](https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonAthena/current/index.json), 10 Nov 2026 |
| Glue Iceberg compaction costs $0.44 per DPU-hour in us-east-1; Glue 6.0+ ETL jobs cost $0.308 per DPU-hour and older Glue ETL $0.44. | cloud provider docs | [pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AWSGlue/current/index.js](https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AWSGlue/current/index.json), 10 Nov 2026 |
| S3 Tables in us-east-1: compaction is $0.005 per GB processed plus $0.002 per 1,000 objects compacted; sort or Z-order compaction is $0.01 per GB plus $0.002 per 1,000 objects; storage is $0.0265 per GB-month for the first 50 TB. | cloud provider docs | [pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonS3/current/index.j](https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonS3/current/index.json), 10 Nov 2026 |

## Code changes and migration

| Fact | Source type | Source, read |
| --- | --- | --- |
| The EMR runtime for Spark is described as 100% API-compatible with open-source Spark, so existing Spark jobs need no rewrite; EMR is native Spark on EC2, EKS or Serverless. | cloud provider docs | [aws.amazon.com/emr/features/spark](https://aws.amazon.com/emr/features/spark/), 10 Nov 2026 |
| Athena for Apache Spark (version 3.5) accepts Spark code from SageMaker Unified Studio notebooks or any Spark Connect compatible client; PySpark engine version 3 offers the console notebook experience. | cloud provider docs | [docs.aws.amazon.com/athena/latest/ug/notebooks-spark.html](https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark.html), 10 Nov 2026 |

## Tuning and table upkeep

| Fact | Source type | Source, read |
| --- | --- | --- |
| EMR enables adaptive query execution, dynamic partition pruning, bloom filter join and optimized join reorder; docs say AQE adaptive join conversion is on by default and can be switched off with a Spark setting. | cloud provider docs | [docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-spark-performance.html](https://docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-spark-performance.html), 10 Nov 2026 |
| Athena compaction is manual: run OPTIMIZE ... REWRITE DATA USING BIN_PACK and VACUUM yourself on Iceberg tables. | cloud provider docs | [docs.aws.amazon.com/athena/latest/ug/querying-iceberg-data-optimization.](https://docs.aws.amazon.com/athena/latest/ug/querying-iceberg-data-optimization.html), 10 Nov 2026 |
| Glue Data Catalog Iceberg compaction is disabled by default for new tables and must be enabled per table with an IAM role. | cloud provider docs | [docs.aws.amazon.com/glue/latest/dg/enable-compaction.html](https://docs.aws.amazon.com/glue/latest/dg/enable-compaction.html), 10 Nov 2026 |
| S3 Tables compaction is on by default for all tables with a 512 MB default target file size (configurable 64 to 512 MB) and also applies row-level deletes. | cloud provider docs | [docs.aws.amazon.com/AmazonS3/latest/userguide/s3-tables-maintenance.html](https://docs.aws.amazon.com/AmazonS3/latest/userguide/s3-tables-maintenance.html), 10 Nov 2026 |

## Spark versions and table formats

| Fact | Source type | Source, read |
| --- | --- | --- |
| EMR 7.x release table lists Spark 3.5.x builds (up to 3.5.8-amzn-0); the EMR Spark feature page says EMR supports Apache Iceberg v3 and Spark 4.0. | cloud provider docs | [docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-release-app-versions-7.x](https://docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-release-app-versions-7.x.html), 10 Nov 2026 |
| Athena supports Apache Iceberg 1.4.2 for read, time travel, write and DDL, only with tables in the AWS Glue Data Catalog and Glue optimistic locking; DDL is not supported on tables registered with Lake Formation. | cloud provider docs | [docs.aws.amazon.com/athena/latest/ug/querying-iceberg.html](https://docs.aws.amazon.com/athena/latest/ug/querying-iceberg.html), 10 Nov 2026 |

## Where it runs

| Fact | Source type | Source, read |
| --- | --- | --- |
| All of these are AWS services, so they run only on AWS; EMR, Athena, Glue and S3 are priced in us-east-1 on the AWS price list. | cloud provider docs | [aws.amazon.com/emr/features/spark](https://aws.amazon.com/emr/features/spark/), 10 Nov 2026 |

## On the Compute Bill

| Line | How it is billed | Formula | Stated cost | What is in and out |
| --- | --- | --- | --- | --- |
| [Amazon EMR on EKS (EC2 nodes)](/platforms/aws-emr-athena-iceberg/) | EC2 instance-hours for the nodes, plus an EMR charge per vCPU-hour and per GB-hour of the pods. AWS also charges $0.10 per hour for each EKS cluster; that fee is excluded from this line. | EC2: 20 node-hours x $1.008 = $20.16. EMR vCPU: 160 vCPU x 2 hours = 320 vCPU-hours x $0.007084 = $2.26688. EMR memory: 1,280 GB x 2 hours = 2,560 GB-hours x $0.000777875 = $1.99136. Total $20.16 + $2.26688 + $1.99136 = $24.41824, which rounds to $24.42. | $24.42 | Includes EC2 and the EMR uplift for pods that request the full vCPU and memory of all ten nodes. Excludes the EKS cluster fee ($0.10 per hour per cluster, as on the open stack line), because it depends on how long the cluster stays up, not on the two-hour job; and it excludes the driver pod, EBS, S3 requests, data transfer and public IPv4 charges. |
| [Amazon EMR on EC2](/platforms/aws-emr-athena-iceberg/) | EC2 instance-hours plus an EMR price per instance-hour, each billed per second with a one-minute minimum. | 20 node-hours x ($1.008 EC2 + $0.252 EMR) = 20 x $1.26 = $25.20. | $25.20 | Includes EC2 and the EMR price for ten r6i.4xlarge workers. Excludes the primary (driver) node, EBS volumes, S3 requests, data transfer and public IPv4 charges. |
| [Amazon EMR Serverless](/platforms/aws-emr-athena-iceberg/) | Per vCPU-hour and per GB-hour of the workers while they run, plus storage beyond the free ephemeral amount. No instances to manage. | vCPU: 160 x 2 = 320 vCPU-hours x $0.052624 = $16.83968. Memory: 1,280 GB x 2 = 2,560 GB-hours x $0.0057785 = $14.79296. Total $16.83968 + $14.79296 = $31.63264, which rounds to $31.63. | $31.63 | Includes vCPU and memory charges for workers that total 160 vCPU and 1,280 GB for two hours. Excludes extra ephemeral storage (the $0.000111 per GB-hour rate applies only beyond the free amount), the driver, S3 requests and data transfer. Workers are billed only while they run, so a job that scales in and out would be billed for less than the full two hours; that is not modeled. |

## Searched for and none found on 10 Nov 2026

- AWS blog post with TPC-DS method, scale, instance types and total runtime for EMR vs OSS Spark (the guessed blog URL returned 404) (searched: aws.amazon.com/emr/features/spark, docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-spark-performance.html, docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-spark-performance-benchm)
- Published scripts for AWS benchmarks (searched: aws.amazon.com/emr/features/spark)

## Amazon EMR plus Athena on Iceberg side by side with each other entry

- [Amazon EMR plus Athena on Iceberg and Databricks](/compare/aws-emr-athena-iceberg-vs-databricks/)
- [Amazon EMR plus Athena on Iceberg and Dremio](/compare/aws-emr-athena-iceberg-vs-dremio/)
- [Amazon EMR plus Athena on Iceberg and DualBird](/compare/aws-emr-athena-iceberg-vs-dualbird/)
- [Amazon EMR plus Athena on Iceberg and Google BigQuery and BigLake](/compare/aws-emr-athena-iceberg-vs-bigquery-biglake/)
- [Amazon EMR plus Athena on Iceberg and Microsoft Fabric](/compare/aws-emr-athena-iceberg-vs-microsoft-fabric/)
- [Amazon EMR plus Athena on Iceberg and Onehouse](/compare/aws-emr-athena-iceberg-vs-onehouse/)
- [Amazon EMR plus Athena on Iceberg and Open stack on EMR and EKS](/compare/aws-emr-athena-iceberg-vs-open-stack-emr-eks/)
- [Amazon EMR plus Athena on Iceberg and Snowflake](/compare/aws-emr-athena-iceberg-vs-snowflake/)
- [Amazon EMR plus Athena on Iceberg and Starburst](/compare/aws-emr-athena-iceberg-vs-starburst/)

## Sources

- Amazon EMR plus Athena on Iceberg: aws.amazon.com/emr/features/spark: https://aws.amazon.com/emr/features/spark/ (read 10 Nov 2026)
- Amazon EMR plus Athena on Iceberg: docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-release-app-versions-7.x: https://docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-release-app-versions-7.x.html (read 10 Nov 2026)
- Amazon EMR plus Athena on Iceberg: docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-spark-performance.html: https://docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-spark-performance.html (read 10 Nov 2026)
- Amazon EMR plus Athena on Iceberg: pricing.us-east-1.amazonaws.com/offers/v1.0/aws/ElasticMapReduce/current: https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/ElasticMapReduce/current/index.json (read 10 Nov 2026)
- Amazon EMR plus Athena on Iceberg: aws.amazon.com/emr/pricing: https://aws.amazon.com/emr/pricing/ (read 10 Nov 2026)
- Amazon EMR plus Athena on Iceberg: pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonAthena/current/ind: https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonAthena/current/index.json (read 10 Nov 2026)
- Amazon EMR plus Athena on Iceberg: docs.aws.amazon.com/athena/latest/ug/notebooks-spark.html: https://docs.aws.amazon.com/athena/latest/ug/notebooks-spark.html (read 10 Nov 2026)
- Amazon EMR plus Athena on Iceberg: docs.aws.amazon.com/athena/latest/ug/querying-iceberg.html: https://docs.aws.amazon.com/athena/latest/ug/querying-iceberg.html (read 10 Nov 2026)
- Amazon EMR plus Athena on Iceberg: docs.aws.amazon.com/athena/latest/ug/querying-iceberg-data-optimization.: https://docs.aws.amazon.com/athena/latest/ug/querying-iceberg-data-optimization.html (read 10 Nov 2026)
- Amazon EMR plus Athena on Iceberg: docs.aws.amazon.com/glue/latest/dg/enable-compaction.html: https://docs.aws.amazon.com/glue/latest/dg/enable-compaction.html (read 10 Nov 2026)
- Amazon EMR plus Athena on Iceberg: pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AWSGlue/current/index.js: https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AWSGlue/current/index.json (read 10 Nov 2026)
- Amazon EMR plus Athena on Iceberg: docs.aws.amazon.com/AmazonS3/latest/userguide/s3-tables-maintenance.html: https://docs.aws.amazon.com/AmazonS3/latest/userguide/s3-tables-maintenance.html (read 10 Nov 2026)
- Amazon EMR plus Athena on Iceberg: pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonS3/current/index.j: https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonS3/current/index.json (read 10 Nov 2026)
- AWS Price List API, Amazon EC2, us-east-1 (published 2026-11-10): https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonEC2/current/us-east-1/index.json (read 10 Nov 2026)
- AWS Price List API, Amazon EMR, us-east-1 (published 2026-11-10): https://pricing.us-east-1.amazonaws.com/offers/v1.0/aws/ElasticMapReduce/current/us-east-1/index.json (read 10 Nov 2026)
- Amazon EKS pricing page: https://aws.amazon.com/eks/pricing/ (read 10 Nov 2026)

Last reviewed 10 Nov 2026. Canonical: https://datalakehousecompare.com/platforms/aws-emr-athena-iceberg/
