whichdb
vs

Apache Cloudberry vs Apache Doris

Apache Cloudberry: Open-source MPP warehouse forked from Greenplum and rebased on a newer PostgreSQL kernel. Apache Doris: Real-time MPP analytical database with MySQL compatibility, search indexes and lakehouse access.

key differences

  • Apache Cloudberry is primarily a relational database; Apache Doris is columnar / OLAP.
  • Transactions: Apache Cloudberry offers full ACID; Apache Doris offers limited.
  • Only Apache Cloudberry has transactions, stored procedures.
  • Only Apache Doris has vector search, ttl / expiry, online schema changes, streaming ingest.

choose apache-cloudberry for

  • +Migrating off closed-source Greenplum
  • +On-prem Postgres-compatible MPP warehouse
  • +Open-source alternative to commercial MPP appliances

best at · Warehouse, OLAP, Lakehouse

choose apache-doris for

  • +Real-time reporting and dashboards
  • +Log and observability analytics
  • +Lakehouse query acceleration
  • +User behavior and ad analytics

best at · Real-time analytics, OLAP, Lakehouse

Apache CloudberryOpen-source MPP warehouse forked from Greenplum and rebased on a newer PostgreSQL kernel.
Apache DorisReal-time MPP analytical database with MySQL compatibility, search indexes and lakehouse access.
overview
Primary model
Relational
Columnar / OLAP
Also supports
Columnar / OLAP, Spatial, Document
Relational, Document, Search Engine, Vector
Type
Database engine
Database engine
Status
Active
Active
Developer
Apache Software Foundation (Incubator)
Apache Software Foundation
First release
2023
2017
Latest version
2.1.0-incubating (Apr 15, 2026)
4.1.5 (Oct 15, 2026)
License
Open source (permissive)Apache License 2.0
Open source (permissive)Apache License 2.0
Free tier
✓
✓
popularity
WhichDB Score
6.8
15.9
Rank
#350
#201
GitHub stars
1.4K
16.1K
Stack Overflow questions
–
32
scale & guarantees
Comfortable data size
Large (≤ 1 PB)
Large (≤ 1 PB)
Horizontal scaling
Native
Native
Multi-region
None
None
ACID
Full
Limited
Consistency
Strong
Strong
Schema
Strict
Flexible
Architecture
Distributed, Client server
Distributed, Shared storage
deployment
Self-hosted
✓
✓
Vendor-managed cloud
—
—
Serverless
—
—
Embedded
—
—
Edge
—
—
Clouds
–
–
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, PL/pgSQL, PL/Python
SQL (MySQL dialect)
Client languages
C, Java, Python, Go, JavaScript
Java, Python, Go, JavaScript, C++
Best for
Warehouse, OLAP, Lakehouse
Real-time analytics, OLAP, Lakehouse, Observability
Add more to this comparisonNot sure either fits? Try smart match

Apache Cloudberry vs Apache Doris: FAQ

What is the difference between Apache Cloudberry and Apache Doris?

Apache Cloudberry: Open-source MPP warehouse forked from Greenplum and rebased on a newer PostgreSQL kernel. Apache Doris: Real-time MPP analytical database with MySQL compatibility, search indexes and lakehouse access. Apache Cloudberry is primarily a relational database; Apache Doris is columnar / OLAP. Transactions: Apache Cloudberry offers full ACID; Apache Doris offers limited. Only Apache Cloudberry has transactions, stored procedures.

When should I choose Apache Cloudberry over Apache Doris?

Choose Apache Cloudberry for migrating off closed-source Greenplum, on-prem Postgres-compatible MPP warehouse and open-source alternative to commercial MPP appliances. Choose Apache Doris for real-time reporting and dashboards; log and observability analytics; and lakehouse query acceleration.

Is Apache Cloudberry or Apache Doris more popular?

Apache Doris ranks #201 on the WhichDB Score (15.9/100) and Apache Cloudberry ranks #350 (6.8/100). Popularity is not fit: check the requirements that matter for your project.

Are Apache Cloudberry and Apache Doris open source?

Yes. Apache Cloudberry is open source. License: Apache License 2.0. Yes. Apache Doris is open source. License: Apache License 2.0.