Apache Druid

What Apache Druid is
Apache Druid is an open-source analytics database for real-time queries on streaming and batch data. It is designed for sub-second analytics and the project says it can execute OLAP queries in milliseconds across high-cardinality datasets with billions to trillions of rows. Native Apache Kafka and Amazon Kinesis integrations support low-latency ingestion and query-on-arrival. Ingested data is organized into compressed, indexed columns, including time indexes and dictionary and bitmap indexes. Users can query with Druid SQL or JSON-over-HTTP native queries; joins are supported during ingestion and at query time. Its web console can load data, manage datasources and tasks, show server status and segments, and run queries. Extensions connect to storage, databases, and formats including S3, HDFS, Azure, PostgreSQL, Avro, ORC, and Parquet. Druid is free under Apache License 2.0 and can be self-hosted on Linux, macOS, and other Unix-like systems; Windows is not supported. The local quickstart requires at least 6 GiB of RAM and Java 17. Security features are disabled by default, so production deployments need TLS, authentication, and authorization configured.
Who it suits
Druid suits teams building analytics workloads that need low-latency queries over streaming or batch data, including high-concurrency and ad hoc exploration use cases. It requires a supported Unix-like environment and production security configuration.
What it does well
- Free and licensed under Apache License 2.0.
- Supports streaming ingestion through Kafka and Kinesis.
- Offers Druid SQL and JSON-over-HTTP queries.
- Web console can manage data and run queries.
- Extensions cover storage, databases, and file formats.
What to know first
- Windows is not supported.
- Local quickstart requires at least 6 GiB RAM and Java 17.
- Security features are disabled by default.
- Not commonly used for full-text search over text logs.
Limits
The free plan is self-hosted software, and the local quickstart requires at least 6 GiB of RAM and Java 17. Windows is not supported. Security controls are disabled by default and must be configured for production.
Plans
| Plan | Billed and limits | Price |
|---|---|---|
| Apache Druid | Open source analytics database · Downloadable for self-hosting | Free |
As druid.apache.org lists them, read 2 Oct 2026. The maker's own page has the final word.
Getting started
- Visit the Apache Druid website
- Prepare a Linux, macOS, or other Unix-like system with at least 6 GiB of RAM and Java 17 for the local quickstart
- Download Druid for self-hosting
- Load data through the web console or a supported integration
- Use Druid SQL or JSON-over-HTTP native queries
- Configure TLS, authentication, and authorization for a production deployment
Overview
Apache Druid is an open-source database for teams that need fast analytical answers from large, changing datasets. It is strongest in user-facing analytics and interactive exploration, where fresh data and high query volume matter. Its distributed design offers room to scale, but it calls for operational planning rather than a plug-and-play database.
Druid targets millisecond OLAP queries across datasets ranging from billions to trillions of rows, and applications handling hundreds to 100,000 queries per second. Those are stated capabilities, not universal performance guarantees; deployment and workload matter. The project’s latest stable release is 37.0.0, released May 8, 2026, under the Apache License, Version 2.0.
Key features
Streaming and batch analytics
Native Apache Kafka and Amazon Kinesis integrations support low-latency ingestion and query-on-arrival, including ingestion at millions of events per second with guaranteed consistency. Druid also handles batch data, so it can serve workloads that need both incoming events and larger historical datasets. Its source coverage includes streaming systems, object stores, databases, and files.
Storage and query design
On ingestion, Druid turns data into compressed columnar storage with time indexes, dictionary encoding, and bitmap indexes. That structure is designed to accelerate analytical queries, particularly on high-cardinality data. Users can query through Druid SQL or native JSON-over-HTTP requests; joins are supported both during ingestion and at query time.
Scaling, operations, and integrations
Ingestion, query, and orchestration components are loosely coupled, with deep storage supporting scale-up and scale-out. Continuous backup, automated recovery, and multi-node replication provide a foundation for durability and availability, while extensions connect Druid to systems and formats such as S3, HDFS, Google Cloud Storage, Azure, Avro, ORC, Parquet, MySQL, and PostgreSQL.
The web console can load data, manage datasources and tasks, show server status and segments, and run SQL and native queries. That gives operators a central place for common tasks, though it does not remove the need to manage the underlying deployment.
Pricing
Apache Druid: free. The open-source analytics database is downloadable for self-hosting and includes real-time ingestion and SQL access. The project and documentation are licensed under Apache License, Version 2.0. This is a self-managed option rather than a managed service plan; deployment and infrastructure remain with the user.
Platforms
Druid supports API, Linux, macOS, self-hosted, and web environments. The quickstart supports Linux, Mac OS X, and other Unix-like systems, but not Windows. A local quickstart needs at least 6 GiB of RAM and Java 17. Druid is also designed for commodity hardware and cloud environments including AWS, GCP, and Azure.
Security features are disabled by default, so production operators need to configure TLS, authentication, and authorization. Documented authenticator extensions include HTTP Basic authentication, LDAP, and Kerberos. The project directs users to Slack and GitHub for community help and names Cloudera, Datumo, Deep.BI, Imply, and Rill Data as commercial support providers.
Who it's for
Druid is a strong fit for teams building user-facing analytics, high-concurrency low-latency query systems, or tools that need immediate visibility into streaming data. It also suits ad hoc exploration over large datasets and organizations that want to scale ingestion and queries across loosely coupled components.
It is less suitable for someone seeking a general-purpose database or full-text search over text logs. The project notes that Druid is not commonly used for full-text log search, though it can ingest and analyze semi-structured data such as JSON. Teams without the capacity to configure security and operate a distributed self-hosted system should weigh that burden before choosing it.
Pros and cons
- Low-latency analytics at scale: Druid is designed for millisecond OLAP queries on very large, high-cardinality datasets and high query concurrency.
- Fresh streaming data: Kafka and Kinesis integrations support query-on-arrival alongside batch workloads.
- Flexible data connectivity: Extensions cover major storage systems, databases, streaming sources, and file formats.
- Self-hosting demands operational work: The distributed architecture and local system requirements call for infrastructure planning and administration.
- Security needs deliberate setup: TLS, authentication, and authorization must be configured before production because security features are off by default.
- Not a typical full-text log search tool: Teams focused on text search should consider a different fit.
Alternatives
Apache Beam is another free, open-source option if you want a programming model for data processing; execution costs depend on the runner and infrastructure you select.
Apache Storm is a free, open-source alternative for readers comparing streaming-oriented projects.
Feldera may suit teams seeking a SQL-focused open-source edition with all connectors and datasets larger than memory, within its single-node, single-container setup.
Timeplus offers the free, Apache 2.0-licensed Timeplus Proton as a lightweight streaming SQL engine distributed as a single binary under 500MB.
Apache Spark is a free distributed data analytics engine if that broader engine model better matches your workload.
Confluent Cloud is worth considering if you prefer serverless, fully managed Kafka clusters and connectors, with a free Basic plan starting at $0/Month.
Materialize offers a self-managed Community License with up to 24GiB memory and 48GiB disk, or a Cloud Capacity plan priced at 1.50.
Apache Flink is a free Apache License v2 alternative for teams evaluating an open-source stream-processing project.
Browse Streaming Analytics Software, OLAP Databases, Columnar Databases, OLAP Software, and Database Software for more options.
Verdict
Choose Apache Druid when your priority is fast, concurrent analytics on fresh streaming data and large batch datasets, and you can operate a self-hosted distributed system. Its combination of real-time ingestion, SQL, indexing, and extensibility is compelling for that workload. Look elsewhere for full-text log search or when you need security configured out of the box or want to avoid deployment and operations work.
Verdict
Apache Druid is a self-hosted option for real-time analytics across streaming and batch data, with SQL access, a web console, and broad extension support. Plan for the local system requirements and configure security controls before production use.
Questions
How much does Apache Druid cost?
The Apache Druid plan is free. Apache Druid is open source under the Apache License 2.0.
Is there a free plan or trial?
Apache Druid is available as a free, downloadable plan for self-hosting. No free trial is listed.
Which operating systems can run Apache Druid?
The quickstart supports Linux, Mac OS X, and other Unix-like operating systems. Windows is not supported.
What does the local quickstart require?
It requires a machine with at least 6 GiB of RAM and Java 17.
Which query interfaces does Druid provide?
Druid supports Druid SQL and JSON-over-HTTP native queries. Its web console can also run SQL and native queries.
What security setup is available?
Documented authenticator extensions include HTTP Basic authentication, LDAP, and Kerberos. Security features are disabled by default, and production deployments must configure TLS, authentication, and authorization.
Facts from Apache Druid's own pages
- Architecture
- Loosely coupled ingestion, query, and orchestration components with deep storage support scale-up and scale-out. · druid.apache.org, 1 Oct 2026
- Authentication options
- Documented authenticator extensions include HTTP Basic authentication, LDAP, and Kerberos. · druid.apache.org, 2 Oct 2026
- Concurrency
- The project describes Druid as supporting workloads from hundreds to tens of thousands of queries per second at consistent performance. · druid.apache.org, 2 Oct 2026
- Deployment
- Druid can run on commodity hardware in *NIX environments and is designed to run in AWS, GCP, Azure, and other cloud environments. · druid.apache.org, 2 Oct 2026
- Extensions
- Core extensions add support for storage, metadata stores, formats, authentication, and other capabilities; examples include S3, HDFS, Azure, Kafka, and PostgreSQL. · druid.apache.org, 2 Oct 2026
- Ingestion
- Druid integrates natively with Apache Kafka and Amazon Kinesis for low-latency streaming ingestion and query-on-arrival. · druid.apache.org, 2 Oct 2026
- Integrations
- Core extensions support systems and formats including S3, HDFS, Google Cloud Storage, Azure, Kafka, Kinesis, Avro, ORC, Parquet, MySQL, and PostgreSQL. · druid.apache.org, 1 Oct 2026
- Intended workloads
- The FAQ recommends considering Druid for user-facing applications, low-latency high-concurrency queries, instant data visibility, ad hoc exploration, and streaming data. · druid.apache.org, 2 Oct 2026
- Latest release
- The latest stable release is Apache Druid 37.0.0, released May 8, 2026. · druid.apache.org, 1 Oct 2026
- License
- Apache Druid and its documentation are licensed under the Apache License, Version 2.0. · druid.apache.org, 1 Oct 2026
- Notable limitation
- The FAQ says Druid is not commonly used for full-text search over text logs, though it is often used to ingest and analyze semi-structured data such as JSON. · druid.apache.org, 2 Oct 2026
- OLAP scale
- Druid executes OLAP queries in milliseconds on high-cardinality datasets containing billions to trillions of rows. · druid.apache.org, 1 Oct 2026
- Operating systems
- The quickstart supports Linux, Mac OS X, and other Unix-like operating systems; Windows is not supported. · druid.apache.org, 1 Oct 2026
- Purpose
- Apache Druid is a high-performance real-time analytics database for sub-second queries on streaming and batch data at scale. · druid.apache.org, 1 Oct 2026
- Query languages
- Druid supports both Druid SQL and JSON-over-HTTP native queries. · druid.apache.org, 1 Oct 2026
- Query performance
- The project says Druid can execute OLAP queries in milliseconds over datasets with billions to trillions of rows. · druid.apache.org, 2 Oct 2026
- Reliability
- Druid provides continuous backup, automated recovery, and multi-node replication for high availability and durability. · druid.apache.org, 1 Oct 2026
- Security
- Security features include TLS, authentication, and authorization, but they are disabled by default and the documentation says to configure them for production. · druid.apache.org, 2 Oct 2026
- SQL and joins
- Druid provides a SQL API and supports joins during ingestion and at query time. · druid.apache.org, 2 Oct 2026
- Storage and indexing
- Ingested data is columnarized, time-indexed, dictionary-encoded, bitmap-indexed, and compressed. · druid.apache.org, 2 Oct 2026
- Storage format
- Druid automatically columnarizes, time-indexes, dictionary-encodes, bitmap-indexes, and compresses ingested data. · druid.apache.org, 1 Oct 2026
- Streaming
- Native Apache Kafka and Amazon Kinesis integrations provide query-on-arrival, ingestion at millions of events per second, low latency, and guaranteed consistency. · druid.apache.org, 1 Oct 2026
- Support
- The project directs users to its community network for help using Druid. · druid.apache.org, 2 Oct 2026
- System requirement
- The local quickstart requires a machine with at least 6 GiB of RAM and Java 17. · druid.apache.org, 1 Oct 2026
Where Apache Druid stands on Freedom251
- Analytics Data#2 of 30
- Streaming Analytics Software#2 of 25
- OLAP Software#3 of 32
- Analytical Data Store Software#3 of 28
- Stream Analytics Software#3 of 26
- Analytics Databases#4 of 31
- Columnar Databases#4 of 27
- OLAP Databases#5 of 30
- Big Data Analytics Software#6 of 30
- Database Software#26 of 74