ClickHouse (ClickHouse/ClickHouse): A highly performant, open-source columnar database management system for OLAP. It allows developers to generate analytical reports in real-time using SQL queries on petabyte-scale datasets. 👉 ClickHouse GitHub Repository [1, 2]
DuckDB (duckdb/duckdb): Often called the “SQLite for analytics,” DuckDB is an embedded, serverless columnar analytical database. It is highly optimized for local data science workflows, allowing you to run fast SQL queries directly on top of Parquet, CSV, or Pandas data structures. 👉 DuckDB GitHub Repository [1, 2, 3, 4, 5]
Trino (trinodb/trino): Formerly known as PrestoSQL, Trino is a fast distributed SQL query engine designed to run large-scale analytical queries against diverse data sources (like Hive, Cassandra, or relational databases) without moving the underlying data. 👉 Trino GitHub Repository [1, 2, 3, 4]
StarRocks (StarRocks/starrocks): A next-generation distributed OLAP platform that excels at multi-table joins and real-time streaming data ingestion. It leverages a fully vectorized engine and cost-based query optimizer. 👉 StarRocks GitHub Repository [1, 2, 3]