10 open-source alternatives ranked by real activity

Open-source Starburst alternatives

A curated, ranked list of the 10 best open-source alternatives to Starburst.

The best open-source alternative to Starburst is ClickHouse. If that doesn't suit you, other good options are Apache Spark, Trino, Apache Doris and StarRocks.

Commercial alternatives to Starburst include Amazon Athena, Denodo, Cloudera and Teradata. See all 16.

Starburst alternatives are mainly databases, but some are also data pipeline & ETL tools and analytics tools. 8 of them shipped code in the last 30 days, 10 can be self-hosted, and 10 use a permissive licence.

Last updated November 13, 2026 · ranked by GitHub stars, growth and recent commits

ClickHouse

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.comClickHouse homepage screenshot

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.

Apache Spark

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.orgApache Spark homepage screenshot

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.

Trino

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.ioTrino homepage screenshot

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.

Read more about TrinoWebsiteGitHub#3 Starburst alternative

Apache Doris

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.orgApache Doris homepage screenshot

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.

StarRocks

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.ioStarRocks homepage screenshot

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.

Delta Lake

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.ioDelta Lake homepage screenshot

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.

Hudi

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.orgHudi homepage screenshot

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.
Read more about HudiWebsiteGitHub#7 Starburst alternative

Apache Hive

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.orgApache Hive homepage screenshot

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.

Alluxio

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.ioAlluxio homepage screenshot

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.

Read more about AlluxioWebsiteGitHub#9 Starburst alternative

Dremio OSS

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.comDremio OSS homepage screenshot

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.

Commercial Starburst alternatives

Hosted, closed-source products that compete with Starburst. Showing 12 of 16.

See every Starburst alternative on its tool page

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.

People also look for alternatives to…

View all