Skip to content
Lakehouse Compare

Platform profile, read 10 Nov 2026

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

On the Compute BillCompare with another entry

Kind
Spark and SQL engines on AWS
Website
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

FactSource typeSource, 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.vendoraws.amazon.com/emr/features/spark, 10 Nov 2026

Published prices and cost results

FactSource typeSource, 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 docspricing.us-east-1.amazonaws.com/offers/v1.0/aws/ElasticMapReduce/current, 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 docspricing.us-east-1.amazonaws.com/offers/v1.0/aws/ElasticMapReduce/current, 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 docsaws.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 docspricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonAthena/current/ind, 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 docspricing.us-east-1.amazonaws.com/offers/v1.0/aws/AWSGlue/current/index.js, 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 docspricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonS3/current/index.j, 10 Nov 2026

Code changes and migration

FactSource typeSource, 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 docsaws.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 docsdocs.aws.amazon.com/athena/latest/ug/notebooks-spark.html, 10 Nov 2026

Tuning and table upkeep

FactSource typeSource, 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 docsdocs.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 docsdocs.aws.amazon.com/athena/latest/ug/querying-iceberg-data-optimization., 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 docsdocs.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 docsdocs.aws.amazon.com/AmazonS3/latest/userguide/s3-tables-maintenance.html, 10 Nov 2026

Spark versions and table formats

FactSource typeSource, 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 docsdocs.aws.amazon.com/emr/latest/ReleaseGuide/emr-release-app-versions-7.x, 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 docsdocs.aws.amazon.com/athena/latest/ug/querying-iceberg.html, 10 Nov 2026

Where it runs

FactSource typeSource, 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 docsaws.amazon.com/emr/features/spark, 10 Nov 2026

On the Compute Bill

LineHow it is billedFormulaStated costWhat is in and out
Amazon EMR on EKS (EC2 nodes)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.42Includes 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 EC2EC2 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.20Includes 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 ServerlessPer 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.63Includes 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

Sources

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

Last reviewed 10 Nov 2026.