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

Side by side, read 10 Nov 2026

**The short answer.** Amazon EMR plus Athena on Iceberg and Dremio are set out here in the same rows: published speed and cost results, code changes and migration, table upkeep, Spark versions and table formats, and where each runs. Each cell carries its source and read date, and the Compute Bill line for each is in the table.

## The same rows for both

| Row | Amazon EMR plus Athena on Iceberg | Dremio |
| --- | --- | --- |
| Kind | Spark and SQL engines on AWS | Lakehouse with its own SQL engine |
| 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). | Per Dremio documentation, Iceberg tables in the Open Catalog get automatic optimization: data file compaction, row-level delete handling, clustering, partition evolution and manifest rewriting (read 2026-11-10). Dremio publishes DCU rates by engine size, from 16 DCUs per hour for 2XSmall to 2048 for 3XLarge, with a 60-second minimum (read 2026-11-10). |
| 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). | Per Dremio documentation, queries run on its own columnar engine, not on Spark, and the pages read describe no mode that runs existing Spark jobs. Dremio Cloud documentation lists Iceberg and Delta Lake as table formats; Hudi support: none found on 2026-11-10. |
| Published speed results | 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. | Dremio's founder reported a full 1 TB TPC-DS run (all 99 queries) in 22 seconds on an 8-node m7gd.4xlarge cluster, with no caching, and attributes it to Autonomous Reflections and automatic Iceberg clustering. This is a BI query benchmark run by the vendor, not a Spark batch ETL or compaction test. |
| Published prices and cost results | 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). 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. | Dremio Cloud is priced at $0.20 per DCU (Dremio Compute Unit). Dremio Enterprise (self-managed) pricing is 'contact sales'. The free trial for Dremio Cloud is a $400 credit for 30 days. DCUs are consumed only while engines run. Usage equals engine and replica uptime in seconds (60-second minimum) times the DCU rate for the engine size. Published rates per hour: 2XSmall 16, XSmall 32, Small 64, Medium 128, Large 256, XLarge 512, 2XLarge 1024, 3XLarge 2048. Storage billed in TB-months only for Dremio-hosted storage; LLM tokens billed separately. Billable usage is DCUs (compute), LLM tokens (AI features) and storage. Compute is billed in DCUs only while engines are running. |
| Code changes and migration | 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. 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. | Dremio runs queries on its own columnar execution engine built on Apache Arrow, not on Spark. Docs describe Spark and Flink only as external engines that can use the Open Catalog (Iceberg REST) alongside Dremio. The pages read describe no mode that runs existing Spark jobs, so Spark ETL would stay on Spark or be rewritten as Dremio SQL. |
| Tuning and table upkeep | 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. 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. | For Iceberg tables in the Open Catalog, Dremio runs automatic optimization on a dedicated engine it configures: data file compaction, row-level delete handling (position deletes on v2, deletion vectors on v3), clustering, partition evolution and manifest rewriting. The same operations can be run by hand with OPTIMIZE TABLE. Optimization works in batches sized to engine resources. Engines have settings the admin chooses: size (executors per replica), min and max replicas, last-replica auto-stop (default 2 hours), enqueued time limit (default 5 minutes) and query runtime limit. Default concurrency per replica ranges from 2 (2XSmall) to 20 (3XLarge). |
| Spark versions and table formats | 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. 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. | The Dremio Cloud data formats page lists Apache Iceberg and Delta Lake as table formats (plus Parquet and text formats). Hudi is not listed on that page. The Open Catalog is built on Apache Polaris and supports the Iceberg REST Catalog API; the docs list AWS Glue Data Catalog as a connectable catalog. |
| Where it runs | 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. | Dremio Cloud runs on AWS (Azure listed as coming soon). Supported regions: us-east-1, us-east-2, us-west-2, eu-west-1 and eu-central-1. Dremio Enterprise can be deployed on Kubernetes, on premises, or in AWS, Azure or GCP. |
| How open its benchmarks are | None found on 10 Nov 2026. | Dremio published a 2020 TPC-DS methodology post (SF1000 and SF10000, Parquet on S3, Apache JMeter test plans, 58 of 99 queries that ran unmodified on Dremio and Presto distributions). The 2025 22-second TPC-DS post pages read give cluster type but no scripts, scale-factor files or configuration repository. |
| Compute Bill | Amazon EMR on EKS (EC2 nodes): $24.42; Amazon EMR on EC2: $25.20; Amazon EMR Serverless: $31.63 | Dremio Cloud (Large engine): $102.40 |

Alphabetical order. Vendor statements are the vendor's own. Read 10 Nov 2026.

## 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](/compute-bill/method/) explains the cost lines.

## Sources

- Amazon EMR plus Amazon Athena on Apache Iceberg: aws.amazon.com/emr/features/spark: https://aws.amazon.com/emr/features/spark/ (read 10 Nov 2026)
- Amazon EMR plus Amazon Athena on Apache 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 Amazon Athena on Apache 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 Amazon Athena on Apache 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 Amazon Athena on Apache Iceberg: aws.amazon.com/emr/pricing: https://aws.amazon.com/emr/pricing/ (read 10 Nov 2026)
- Amazon EMR plus Amazon Athena on Apache 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 Amazon Athena on Apache 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 Amazon Athena on Apache 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 Amazon Athena on Apache 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 Amazon Athena on Apache 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 Amazon Athena on Apache 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 Amazon Athena on Apache 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 Amazon Athena on Apache 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)
- Dremio: dremio.com/pricing: https://www.dremio.com/pricing (read 10 Nov 2026)
- Dremio: docs.dremio.com/dremio-cloud/admin/engines: https://docs.dremio.com/dremio-cloud/admin/engines/ (read 10 Nov 2026)
- Dremio: docs.dremio.com/dremio-cloud/admin/subscription/usage: https://docs.dremio.com/dremio-cloud/admin/subscription/usage (read 10 Nov 2026)
- Dremio: docs.dremio.com/current/what-is-dremio/architecture: https://docs.dremio.com/current/what-is-dremio/architecture (read 10 Nov 2026)
- Dremio: docs.dremio.com/dremio-cloud/developer/data-formats: https://docs.dremio.com/dremio-cloud/developer/data-formats/ (read 10 Nov 2026)
- Dremio: docs.dremio.com/dremio-cloud/manage-govern/optimization: https://docs.dremio.com/dremio-cloud/manage-govern/optimization (read 10 Nov 2026)
- Dremio: docs.dremio.com/dremio-cloud/about/regions: https://docs.dremio.com/dremio-cloud/about/regions (read 10 Nov 2026)
- Dremio: dremio.com/blog/breakthrough-announcement-dremio-is-the: https://www.dremio.com/blog/breakthrough-announcement-dremio-is-the-fastest-lakehouse-20x-faster-on-tpc-ds/ (read 10 Nov 2026)
- Dremio: dremio.com/blog/dremio-benchmarking-methodology: https://www.dremio.com/blog/dremio-benchmarking-methodology/ (read 10 Nov 2026)

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