#1
An open-source column-oriented database management system built for real-time analytical reports, available to self-host or as the managed ClickHouse Cloud service.
- GitHub stars
- 51k
- Last commit
- today
- Latest release
- v26.10.2.103-stable
- Licence
- Apache-2.0
- Self-hosted
- Yes
- Hosted version
- Available
clickhouse.com
ClickHouse is an open-source database management system built to generate analytical reports in real time. Its column-oriented storage makes scans and aggregations over very large tables efficient, which is why it is widely used for event data, logs, metrics and product analytics. It is written in C++ and queried with SQL.
The project's topics describe it as an OLAP, massively parallel and distributed system, and it is used for big data workloads where query latency matters. You can install it on Linux, macOS or FreeBSD, follow a tutorial that sets up a small cluster, or skip installation by trying ClickHouse Cloud, a managed service built by its creators. Releases arrive monthly, with a community call for each one, and there are Slack and Telegram channels for help.
ClickHouse is Apache-2.0 licensed. It is a good fit for analytics engineers and platform teams who need fast aggregations over billions of rows and are comfortable operating a database, or who prefer to hand that operation to the vendor's cloud.
Key features
- Column-oriented storage for analytics
- SQL queries over large datasets
- Distributed, massively parallel processing
- Real-time analytical reporting
- Install on Linux, macOS or FreeBSD
- Managed ClickHouse Cloud option
Pricing: The open-source distribution is free. ClickHouse Cloud is usage-based, with plans from $53 (Basic), $437 (Scale) and $571 (Enterprise) per month and a 30-day trial with $300 in credits.
#2
An analytics engine for processing large datasets, with APIs in Scala, Java, Python and R and libraries for SQL, machine learning, graphs and streaming.
- GitHub stars
- 44k
- Last commit
- yesterday
- Licence
- Apache-2.0
- Self-hosted
- Yes
spark.apache.org
Apache Spark is an analytics engine that brings batch, SQL, machine learning, graph and streaming workloads together for processing data at scale. It is maintained by the Apache Software Foundation under the Apache-2.0 license. It is written mainly in Scala and offers high-level APIs in Scala, Java and Python, with an R API that is now deprecated, on top of an engine optimized to execute general computation graphs.
A set of higher-level tools is included: Spark SQL for queries and DataFrames, MLlib for machine learning, GraphX for graphs, Structured Streaming for streams, and a pandas-style API for existing pandas workloads. Together they let teams run batch analytics, machine learning and streaming jobs on a single engine and share code between them.
The README points to the project website for full documentation and programming guides, and it contains only basic setup and build instructions. Spark suits data engineers and data scientists who process datasets too large for a single machine, and organizations that want one framework for ETL, analytics and machine learning on clusters.
Key features
- High-level APIs in Scala, Java and Python
- Optimized engine for computation graphs
- Spark SQL and DataFrames
- MLlib for machine learning
- GraphX for graph analytics
- Structured Streaming for stream processing
- Pandas API on Spark
Pricing: Free and open source under the Apache-2.0 license.
#3
A distributed SQL query engine for big data analytics that runs fast queries across many data sources, formerly known as PrestoSQL.
- GitHub stars
- 14k
- Last commit
- today
- Latest release
- 484
- Licence
- Apache-2.0
- Self-hosted
- Yes
trino.io
Trino is a distributed SQL query engine built for analytics on large data sets. It was formerly called PrestoSQL, and it lets analysts and engineers run interactive SQL against data wherever it lives rather than first moving it into a single warehouse.
The project's topics point to its role in the data lake ecosystem, with connectors and integrations for systems such as Hive, Hadoop, Iceberg and Delta Lake, and a JDBC driver for applications. Trino is a Maven project written in Java, and its repository covers development guidelines, plugin implementors, a security policy and reproducible builds. It runs as a cluster of servers and has a web UI.
Trino is released under the Apache-2.0 licence and is deployed and operated by the user, with deployment instructions and end-user documentation in the project's user manual. It is a fit for data platform teams that need fast, standards-based SQL over many sources, rather than for individual analysts looking for a point-and-click tool.
Key features
- Distributed SQL query engine
- Fast analytics on big data
- Connectors for data lake formats like Iceberg
- JDBC access for applications
- Plugin architecture for custom connectors
- Reproducible builds since version 449
Pricing: Free and open source under the Apache-2.0 licence.
#4
Apache Doris is an open-source, MPP real-time analytics and hybrid search database for fast SQL, lakehouse query acceleration and vector and text search.
- GitHub stars
- 16k
- Last commit
- yesterday
- Latest release
- 4.1.5-release
- Licence
- Apache-2.0
- Self-hosted
- Yes
doris.apache.org
Apache Doris is an open-source analytics database built on a massively parallel processing architecture. It offers fast SQL analytics, acceleration of queries over lakehouse data, and hybrid search spanning structured, text and vector data, and it presents itself as a real-time analytics and search engine suitable for AI agents. It is written in Java.
The README lists use cases that include customer-facing analytics with sub-second interactive queries for external users, data warehousing across business domains, observability for high-throughput logs, events and metrics analyzed with SQL, and AI use where vector, text, JSON and structured search run in one SQL engine. Topics mention lakehouse formats Hudi, Iceberg and Delta Lake and comparisons with warehouses such as BigQuery, Redshift and Snowflake.
Doris is a project of the Apache Software Foundation and Apache-2.0 licensed. You can deploy it on your own clusters, and the website provides release notes, use cases and user stories, with documentation in a large number of languages. It suits data engineering teams that want an open-source, high-concurrency analytical database.
Key features
- MPP architecture for fast SQL analytics
- Lakehouse query acceleration
- Hybrid search across structured, text and vector data
- Real-time ingestion and analysis
- Support for Iceberg, Hudi and Delta Lake
- Apache Software Foundation project
Pricing: Free and open source under the Apache-2.0 license.
#5
A Linux Foundation project: an analytical SQL engine for real-time and ad-hoc queries, running on its own storage or directly over data lakehouse tables.
- GitHub stars
- 12k
- Last commit
- today
- Latest release
- 4.1.7
- Licence
- Apache-2.0
- Self-hosted
- Yes
starrocks.io
StarRocks is a query engine for analytics that returns answers quickly to multi-dimensional, real-time and ad-hoc queries. It is a Linux Foundation project written in Java, and can be used both on its own tables and over data that sits in a data lake or lakehouse without first moving it.
It uses a vectorized SQL engine that takes advantage of CPU parallelism, supports standard ANSI SQL and the MySQL protocol so existing clients and BI tools can connect, and applies a cost-based optimizer to complex queries. Primary-key tables support upserts and deletes with efficient querying during concurrent updates, and materialized views refresh during data import and are chosen automatically at query time.
Data in Hive, Iceberg, Delta Lake and Hudi tables can be queried in place, and its topics point to star-schema, MPP and distributed-database designs. The software is licensed under Apache-2.0 and can be downloaded and run yourself, with documentation, benchmarks and a demo linked from the README. It suits data teams that want fast dashboards and lakehouse analytics without heavy denormalization.
Key features
- Vectorized SQL engine for fast analytics
- ANSI SQL with MySQL protocol compatibility
- Cost-based query optimizer
- Real-time upserts and deletes by primary key
- Automatically maintained materialized views
- Direct queries over Hive, Iceberg, Delta Lake and Hudi
Pricing: Free and open source under the Apache-2.0 licence.
#6
Delta Lake is an open-source storage layer that adds ACID transactions to data lakes and supports lakehouse architectures with Spark, Flink, Trino and other engines.
- GitHub stars
- 9.1k
- Last commit
- today
- Latest release
- v4.4.1
- Licence
- Apache-2.0
delta.io
Delta Lake is an open-source storage framework for building a lakehouse architecture on top of data lake storage. It works with compute engines including Apache Spark, PrestoDB, Flink, Trino and Hive, and offers APIs for Scala, Java, Rust, Ruby and Python. Its topics reference ACID transactions, big data and analytics.
The repository documents a transaction protocol, requirements for the underlying storage systems and concurrency control, and ships a quick start for Scala, Java and Python. A set of integrations connects the format to other tools: Spark can read and write Delta tables, Flink can write to them, PrestoDB and Hive can read them, Trino can read and write, Delta Standalone serves JVM projects and the Delta Rust API gives low-level access to tables with Python and Ruby bindings.
This repository is one of several in the Delta Lake organization, alongside delta-rs, delta-sharing and kafka-delta-ingest. The code is written in Scala and licensed under Apache-2.0. It is used by data engineering teams that want reliable tables on object storage, and it is a library and format rather than a hosted product.
Key features
- ACID transactions on data lake storage
- Works with Spark, Flink, Trino and Hive
- APIs for Scala, Java, Rust, Ruby and Python
- Open transaction protocol specification
- Delta Standalone for JVM projects
- Delta Rust API with Python bindings
Pricing: Free and open source under the Apache-2.0 licence.
#7
Apache Hudi is an open source data lakehouse platform that brings database functionality to data lakes, supporting upserts, deletes, and incremental processing.
- GitHub stars
- 6.4k
- Last commit
- yesterday
- Latest release
- release-1.2.1
- Licence
- Apache-2.0
- Self-hosted
- Yes
hudi.apache.org
Apache Hudi is an open data lakehouse platform built on a high-performance open table format. It aims to bring database functionality to data lakes, enabling features like upserts, deletes, and incremental processing.
The platform is designed to replace traditional batch processing with an incremental processing framework for low-latency, minute-level analytics. It supports various integrations with streaming systems, databases, file formats, lake storage, data catalogs, data warehouses, and processing engines.
Key features
- Supports updates and deletes with fast, pluggable indexing, including database CDC and high-scale streaming data.
- Handles out-of-order records, bursty traffic, and data deduplication.
- Provides incremental processing to replace batch pipelines, enabling faster ingestion and lower processing times.
- Offers ACID transactional guarantees with atomic writes, snapshot isolation, and non-blocking concurrency controls.
- Allows analysis of historical data with time travel.
- Integrates with Apache Spark, Apache Flink, Kafka, Pulsar, and various cloud storage and catalogs.
#8
Apache Hive is data warehouse software that lets you read, write and manage large datasets in distributed storage using SQL on top of Hadoop.
- GitHub stars
- 6k
- Last commit
- today
- Licence
- Apache-2.0
- Self-hosted
- Yes
hive.apache.org
Apache Hive is data warehouse software built on Apache Hadoop. It makes it possible to read, write and manage very large datasets in distributed storage using SQL, so analysts can run extract-transform-load jobs, reports and data analysis without writing low-level processing code.
Hive provides tools for accessing data through SQL, a way of imposing structure on a variety of data formats, and access to files stored in Apache HDFS or other systems such as Apache HBase. Queries can run on the Apache Tez framework, which is designed for interactive queries and has far lower overhead than MapReduce. It supports much standard SQL functionality, including many analytics features from the 2003 and 2011 SQL standards.
Hive is an Apache Software Foundation project written in Java and licensed under Apache-2.0. You deploy it on your own Hadoop-based clusters, though hosted big data platforms from cloud providers also bundle it. It suits data engineering teams maintaining batch analytics on large distributed data.
Key features
- SQL access to distributed datasets
- Built on Apache Hadoop
- Reads data from HDFS and HBase
- Query execution on Apache Tez
- ETL, reporting and analysis workloads
- Standard SQL analytics functions
Pricing: Free and open source under the Apache-2.0 license.
#9
Alluxio is a distributed caching layer that sits between compute and cloud storage to speed up data access for AI and analytics workloads.
- GitHub stars
- 7.3k
- Last commit
- 2 mo ago
- Latest release
- v2.9.4
- Licence
- Apache-2.0
alluxio.io
Alluxio places a high-throughput, low-latency cache between compute and persistent storage such as cloud object storage. The pitch is that AI training and inference jobs stall on slow remote reads, and a cache close to the GPUs removes that bottleneck without moving the source data.
Applications reach the cache through an S3 API, a POSIX client or a Python SDK, and a global namespace sits in front of the underlying storage. The site says this works with an existing stack without rewrites, workflow changes or replatforming, and that data stays where it already lives instead of being copied by hand.
The project is open source under Apache 2.0. A Community Edition is based on that project and comes with community forum support, while Enterprise Edition subscriptions add SLA-based technical support. The company also sells Alluxio AI and Alluxio DA product lines.
Key features
- Distributed cache between compute and storage
- S3 API, POSIX and Python access
- On-demand access without copying data
- Aims to cut data movement, egress and access fees
- Covers data prep, training and inference
Pricing: Community Edition, based on the open source project, is always free with community forum support. Enterprise Edition subscriptions include software and SLA-based technical support, with custom terms, volume pricing and quotes on request.
#10
Dremio OSS is a free, Apache-licensed, open-source data lakehouse platform in Java that provides fast SQL analytics directly on data stored in warehouses and lakes.
- GitHub stars
- 1.5k
- Last commit
- 1 yr ago
- Licence
- Apache-2.0
- Self-hosted
- Yes
dremio.com
Dremio is a data analytics platform aimed at organizations that want to query and analyze large volumes of data without first moving or copying it into a separate, dedicated analytics database. It positions itself as filling a gap between raw data storage and the tools people need to get value out of that data.
The open-source edition can be built and run locally, exposing a web UI at localhost:9047 once started, or installed as a production tarball for server deployment, with an embedded mode also available. Building it requires a specific combination of JDK versions (21 as default, with 17 and 11 configured in the Maven toolchain for certain tests) plus Maven, reflecting a substantial, enterprise-grade Java codebase.
The README notes that to provide the best possible experience, the build includes some dependencies distributed under non-open-source licenses, so the fully open-source experience may differ slightly depending on build configuration. Dremio is written in Java and the open-source edition is released under the Apache-2.0 license, with full documentation hosted separately.
Key features
- SQL analytics directly on lake and warehouse data
- Web-based query interface
- Local and production deployment modes
- Built on a Java codebase with Maven tooling
- No data duplication required for analytics
Pricing: Dremio Cloud is pay-as-you-go at $0.20 per compute unit, with a 30-day trial that includes $400 in credit. Dremio Enterprise, which can be self-hosted, is priced through sales.
Starburst alternatives: questions
- What is the best open-source alternative to Starburst?
- ClickHouse is the top-ranked open-source alternative to Starburst on Enlisted: An open-source column-oriented database management system built for real-time analytical reports, available to self-host or as the managed ClickHouse Cloud service. Other strong options are Apache Spark, Trino, Apache Doris and StarRocks.
- What are the best commercial alternatives to Starburst?
- Amazon Athena, Denodo, Cloudera, Teradata and Amazon EMR are among the hosted, closed-source alternatives to Starburst listed on Enlisted, which lists 16 in total. Compare their pricing and features on each tool page.
- Are these Starburst alternatives free?
- All 10 are open source, so the code is free to use under its licence, and all of them can be self-hosted on your own server or computer. 1 also offers a paid or managed cloud version if you'd rather not host it yourself.
- How is this list of Starburst alternatives ranked?
- By a score built from GitHub stars, star growth over the last 30 days and how recently the code changed. 8 of these projects shipped code in the last 30 days. Data is refreshed daily, and nobody can pay to move up.