Skip to content
Lakehouse Compare

Side by side, read 10 Nov 2026

Amazon EMR plus Athena on Iceberg and Starburst: the published facts in the same rows

Amazon EMR plus Athena on Iceberg profileStarburst profile

The same rows for both

Alphabetical order. Vendor statements are the vendor's own. Read 10 Nov 2026.
RowAmazon EMR plus Athena on IcebergStarburst
KindSpark and SQL engines on AWSManaged Trino service for Iceberg
Does wellPer 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).Per Starburst documentation, Galaxy creates and writes Iceberg tables (Parquet, ORC or Avro) and runs maintenance with ALTER TABLE ... EXECUTE optimize, expire_snapshots and remove_orphan_files (read 2026-11-10). Starburst publishes credit prices by AWS region, for example $0.50 (Pro) and $0.75 (Enterprise) in US East (N. Virginia) and $0.60 and $0.90 in Frankfurt (read 2026-11-10).
LimitedPer 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).Per Starburst documentation, Galaxy runs SQL on Trino, not Spark, so DataFrame code, UDFs and PySpark would be rewritten as Trino SQL or kept on Spark (read 2026-11-10). Per Starburst documentation, Hudi tables are read-only in Galaxy: it cannot create new Hudi tables or write to them.
Published speed resultsAWS 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.Starburst reported GPU-accelerated Trino results (its proprietary distribution, not open-source Trino): TPC-H up to 6x on accelerated queries and ClickBench 3.4x overall, single-node development environment. This is a SQL query test, not Spark batch work.
Published prices and cost resultsEMR 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). 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. 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. 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. 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. 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.Galaxy credit prices start at $0.50 (Pro), $0.75 (Enterprise) and $1.00 (Mission Critical) per credit. A Free tier allows up to 3 clusters. Pricing depends on compute usage, tier and the cloud provider and region. Annual commitments may get discounts. On-demand list prices per credit (Pro / Enterprise / Mission Critical) on AWS: US East N. Virginia, US East Ohio and US West Oregon $0.50 / $0.75 / $1.00; Europe Ireland $0.56 / $0.84 / $1.12; Europe Frankfurt $0.60 / $0.90 / $1.20; Asia Pacific Tokyo $0.64 / $0.97 / $1.29; Brazil (Sao Paulo) $0.80 / $1.19 / $1.59. Cluster compute credit consumption: 1 worker 6 credits per hour, 2 workers 12, 4 workers 24, 8 workers 48, 16 workers 96. Managed ingest: file ingest 0.60 credits per hour; table maintenance and data transforms 0.30 credits per hour. Billing tracks cluster compute hours, data ingestion compute and private link data transfer.
Code changes and migrationThe 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. 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.Galaxy is 'a fully-managed data lake analytics platform built in addition to Trino'. Work runs as SQL on Trino, not Spark, so Spark jobs (DataFrame code, UDFs, PySpark) would have to be rewritten as Trino SQL, or kept on Spark against the same Iceberg tables. The Galaxy docs read contain no Spark execution mode.
Tuning and table upkeepEMR 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. Athena compaction is manual: run OPTIMIZE ... REWRITE DATA USING BIN_PACK and VACUUM yourself on Iceberg tables. Glue Data Catalog Iceberg compaction is disabled by default for new tables and must be enabled per table with an IAM role. 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.Iceberg table maintenance in Galaxy is run with ALTER TABLE ... EXECUTE commands: optimize (compaction; files under file_size_threshold, default 100MB, are merged), drop_extended_stats, expire_snapshots, remove_orphan_files. Live table maintenance for ingest tables is a separate Galaxy page. For batch-style work Galaxy offers a fault tolerant execution mode that spools intermediate data and retries failed parts of a query. Docs say 'No other configuration is required' to enable it, but not to use it if most queries run under about a minute, and that it can be slightly slower than normal execution. FTE and Accelerated modes are not available on the Free cluster size and not all catalogs support FTE.
Spark versions and table formatsEMR 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. 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.Galaxy's Great Lakes connectivity lists Iceberg, Delta Lake, Hive and Hudi table format pages. Hudi tables are read-only: 'Galaxy cannot create new Hudi tables or write to them.' Iceberg tables can be created and written; the Iceberg data file format can be Parquet, ORC or Avro.
Where it runsAll 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.Galaxy prices are listed for AWS, Azure and GCP regions. AWS regions priced include us-east-1, us-east-2, us-west-1, us-west-2, ca-central, Ireland, London, Frankfurt, Zurich, Singapore, Sydney, Tokyo, Cape Town, UAE, Tel Aviv and Sao Paulo. A cluster and its catalogs are normally in the same cloud and region; cross-region querying is a private preview feature.
How open its benchmarks areNone found on 10 Nov 2026.None found on 10 Nov 2026.
Compute BillAmazon EMR on EKS (EC2 nodes): $24.42; Amazon EMR on EC2: $25.20; Amazon EMR Serverless: $31.63Starburst Galaxy (Pro tier): $60.00

How to read this page

The rows hold what each vendor or a named third party published, with no conclusion drawn. Benchmarks in the two columns ran on different hardware, data and baselines, so their numbers are not comparable across columns. The Compute Bill method explains the cost lines.

Sources

  1. Amazon EMR plus Amazon Athena on Apache Iceberg: aws.amazon.com/emr/features/spark, read 10 Nov 2026
  2. Amazon EMR plus Amazon Athena on Apache Iceberg: docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-release-app-versions-7.x, read 10 Nov 2026
  3. Amazon EMR plus Amazon Athena on Apache Iceberg: docs.aws.amazon.com/emr/latest/ReleaseGuide/emr-spark-performance.html, read 10 Nov 2026
  4. Amazon EMR plus Amazon Athena on Apache Iceberg: pricing.us-east-1.amazonaws.com/offers/v1.0/aws/ElasticMapReduce/current, read 10 Nov 2026
  5. Amazon EMR plus Amazon Athena on Apache Iceberg: aws.amazon.com/emr/pricing, read 10 Nov 2026
  6. Amazon EMR plus Amazon Athena on Apache Iceberg: pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonAthena/current/ind, read 10 Nov 2026
  7. Amazon EMR plus Amazon Athena on Apache Iceberg: docs.aws.amazon.com/athena/latest/ug/notebooks-spark.html, read 10 Nov 2026
  8. Amazon EMR plus Amazon Athena on Apache Iceberg: docs.aws.amazon.com/athena/latest/ug/querying-iceberg.html, read 10 Nov 2026
  9. Amazon EMR plus Amazon Athena on Apache Iceberg: docs.aws.amazon.com/athena/latest/ug/querying-iceberg-data-optimization., read 10 Nov 2026
  10. Amazon EMR plus Amazon Athena on Apache Iceberg: docs.aws.amazon.com/glue/latest/dg/enable-compaction.html, read 10 Nov 2026
  11. Amazon EMR plus Amazon Athena on Apache Iceberg: pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AWSGlue/current/index.js, read 10 Nov 2026
  12. Amazon EMR plus Amazon Athena on Apache Iceberg: docs.aws.amazon.com/AmazonS3/latest/userguide/s3-tables-maintenance.html, read 10 Nov 2026
  13. Amazon EMR plus Amazon Athena on Apache Iceberg: pricing.us-east-1.amazonaws.com/offers/v1.0/aws/AmazonS3/current/index.j, read 10 Nov 2026
  14. Starburst (Starburst Galaxy, Starburst Enterprise): starburst.io/pricing, read 10 Nov 2026
  15. Starburst (Starburst Galaxy, Starburst Enterprise): starburst.io/pricing/pricing-details, read 10 Nov 2026
  16. Starburst (Starburst Galaxy, Starburst Enterprise): docs.starburst.io/starburst-galaxy/index.html, read 10 Nov 2026
  17. Starburst (Starburst Galaxy, Starburst Enterprise): docs.starburst.io/starburst-galaxy/data-engineering/working-with-data-la, read 10 Nov 2026
  18. Starburst (Starburst Galaxy, Starburst Enterprise): docs.starburst.io/starburst-galaxy/data-engineering/working-with-data-la, read 10 Nov 2026
  19. Starburst (Starburst Galaxy, Starburst Enterprise): docs.starburst.io/starburst-galaxy/data-engineering/optimization-perform, read 10 Nov 2026
  20. Starburst (Starburst Galaxy, Starburst Enterprise): starburst.io/blog/gpu-accelerated-sql-analytics-how-starburst-and-nvidia, read 10 Nov 2026

Last reviewed 10 Nov 2026.