whichdb
vs

Dremio vs Trino

Dremio: Iceberg-native lakehouse query engine with reflections for acceleration, owned by SAP since 2026. Trino: Fast distributed SQL query engine for federated analytics across lakes and databases.

key differences

  • Licensing: Dremio is proprietary (Proprietary (legacy Community Edition under Apache-2.0)); Trino is open source (permissive) (Apache License 2.0).
  • Trino is built for larger datasets (Multi-PB) than Dremio (≤ 1 PB).
  • Only Dremio has durable persistence, compression, encryption at rest.
  • Only Trino has geospatial.

choose dremio for

  • +Iceberg lakehouse BI acceleration
  • +Semantic layer over a data lake
  • +SAP-centric data platforms
  • +Warehouse offload

best at · Lakehouse, OLAP, Warehouse

choose trino for

  • +Open lakehouse SQL on Iceberg/Delta
  • +Federated analytics across databases
  • +Interactive BI on object storage
  • +Data mesh query layer

best at · OLAP, Lakehouse, Warehouse

DremioIceberg-native lakehouse query engine with reflections for acceleration, owned by SAP since 2026.
TrinoFast distributed SQL query engine for federated analytics across lakes and databases.
overview
Primary model
Relational
Relational
Also supports
Columnar / OLAP
Columnar / OLAP
Type
Database engine
Database engine
Status
Active
Active
Developer
Dremio (SAP)
Trino Software Foundation
First release
2017
2019
Latest version
–
484 (Oct 16, 2026)
License
ProprietaryProprietary (legacy Community Edition under Apache-2.0)
Open source (permissive)Apache License 2.0
Free tier
—
✓
popularity
WhichDB Score
12.7
49.9
Rank
#262
#27
GitHub stars
1.5K
13.4K
Stack Overflow questions
74
893
scale & guarantees
Comfortable data size
Large (≤ 1 PB)
Massive (Multi-PB)
Horizontal scaling
Native
Native
Multi-region
None
None
ACID
Limited
Limited
Consistency
Strong
Strong
Schema
Strict
Strict
Architecture
Distributed, Shared storage, Client server
Distributed, Client server
deployment
Self-hosted
✓
✓
Vendor-managed cloud
✓
—
Serverless
—
—
Embedded
—
—
Edge
—
—
Clouds
AWS, Azure
–
capabilities
Transactions
—
—
Joins
✓
✓
Secondary indexes
—
—
Full-text search
—
—
Vector search
—
—
Geospatial
—
✓
JSON
✓
✓
Change data capture
—
—
Triggers
—
—
Stored procedures
—
—
Materialized views
✓
✓
TTL / expiry
—
—
Pub/Sub
—
—
Columnar storage
—
—
In-memory
—
—
Durable persistence
✓
—
Compression
✓
—
Encryption at rest
✓
—
Role-based access
✓
✓
Time travel
✓
✓
Branching
—
—
Online schema changes
—
—
Streaming ingest
—
—
Offline sync
—
—
Runs in WebAssembly
—
—
interfaces
Query languages
SQL
SQL (ANSI)
Client languages
Python, Java, Go, JavaScript
Java, Python, Go, JavaScript, Rust, C#
Best for
Lakehouse, OLAP, Warehouse
OLAP, Lakehouse, Warehouse
Add more to this comparisonNot sure either fits? Try smart match

Dremio vs Trino: FAQ

What is the difference between Dremio and Trino?

Dremio: Iceberg-native lakehouse query engine with reflections for acceleration, owned by SAP since 2026. Trino: Fast distributed SQL query engine for federated analytics across lakes and databases. Licensing: Dremio is proprietary (Proprietary (legacy Community Edition under Apache-2.0)); Trino is open source (permissive) (Apache License 2.0). Trino is built for larger datasets (Multi-PB) than Dremio (≤ 1 PB). Only Dremio has durable persistence, compression, encryption at rest.

When should I choose Dremio over Trino?

Choose Dremio for iceberg lakehouse BI acceleration, semantic layer over a data lake and SAP-centric data platforms. Choose Trino for open lakehouse SQL on Iceberg/Delta, federated analytics across databases and interactive BI on object storage.

Is Dremio or Trino more popular?

Trino ranks #27 on the WhichDB Score (49.9/100) and Dremio ranks #262 (12.7/100). Popularity is not fit: check the requirements that matter for your project.

Are Dremio and Trino open source?

No. Dremio is proprietary, closed-source software. Yes. Trino is open source. License: Apache License 2.0.