Directory

6 tools

Apache Software Foundation · Data catalogs & formats

Open table format for data lakes that adds ACID snapshots, schema and partition evolution and time travel over Parquet, ORC or Avro files

Apache-2.0Open sourceFreeSelf-hostedNov 2, 2026

Apache Spark

Apache Software Foundation · Analytical engines & OLAP

Distributed data processing engine with DataFrame and SQL APIs in Python, Scala, Java and R, plus structured streaming and MLlib

Apache-2.0Open sourceFreeLocalSelf-hostedNov 2, 2026

ClickHouse

ClickHouse, Inc. · Analytical engines & OLAP

Open-source columnar OLAP database server for fast aggregations over billions of rows, with MergeTree storage, SQL and a managed ClickHouse Cloud

Apache-2.0Open sourceFreeLocalSelf-hostedNov 2, 2026

Elasticsearch

Elastic N.V. · Vector databases

Distributed search and analytics engine on Apache Lucene with full-text, aggregations, vector search and ES|QL; triple-licensed AGPL, SSPL and Elastic License

AGPL-3.0-only OR SSPL-1.0 OR Elastic-2.0Open sourceFreeSelf-hostedNov 2, 2026

OpenSearch

OpenSearch Software Foundation (Linux Foundation) · Vector databases

Apache-2.0 search and analytics suite forked from Elasticsearch and Kibana, governed by the OpenSearch Software Foundation

Apache-2.0Open sourceFreeSelf-hostedBroken

Trino

Trino Software Foundation · Analytical engines & OLAP

Distributed SQL query engine that federates queries across data lakes, warehouses and databases through connectors, formerly PrestoSQL