Analytical (OLAP) Databases

ClickHouse

ClickHouse/ClickHouse

TrendingPopular

Blazing-fast open-source columnar OLAP database for real-time analytics, logs and observability.

DuckDB

duckdb/duckdb

TrendingPopular

In-process analytical SQL database; the SQLite of analytics, querying Parquet, CSV and Iceberg directly.

Snowflake

snowflake.com

Popular

Cloud data platform with separated storage and compute, the leading managed data warehouse.

Google BigQuery

cloud.google.com

Popular

Google Cloud's serverless, petabyte-scale data warehouse with built-in ML and Gemini integration.

StarRocks

StarRocks/starrocks

Rising

MPP OLAP database for sub-second analytics on tables and open lakehouse formats like Iceberg.

Apache Doris

apache/doris

Real-time MPP analytical database with MySQL protocol compatibility and lakehouse federation.

Apache Druid

apache/druid

Real-time analytics database for sub-second queries on streaming and batch event data.

Apache Pinot

apache/pinot

Real-time distributed OLAP store from LinkedIn for user-facing analytics at high concurrency.

MotherDuck

motherduck.com

Rising

Serverless cloud data warehouse built on DuckDB with hybrid local and cloud execution.