Apache Druid
druid.apache.org
What it is
Apache Druid is a free, open-source analytics database for querying streaming and batch data. It is designed to return OLAP queries in milliseconds, including on high-cardinality datasets with billions to trillions of rows. The project describes applications ranging from hundreds to 100,000 queries per second. Native Apache Kafka and Amazon Kinesis integrations support low-latency ingestion and querying as data arrives. Druid organizes ingested data into columnar, time-indexed, encoded and compressed storage. Queries can use Druid SQL or JSON-over-HTTP, and joins are available during ingestion or at query time. Its web console can load data, manage datasources and tasks, show server status and run queries. Extensions connect to storage, databases and formats including S3, HDFS, Azure, PostgreSQL, Avro, ORC and Parquet. Druid can be self-hosted on Linux, macOS and other Unix-like systems; Windows is not supported. The local quickstart needs at least 6 GiB of RAM and Java 17. Production security controls require configuration.
Spec sheet
- What it does
- Apache Druid is a real-time analytics database for sub-second queries on streaming and batch data at scale.Read 2 Oct 2026 · druid.apache.org
- Purpose
- Apache Druid is a high-performance real-time analytics database for sub-second queries on streaming and batch data at scale.Read 1 Oct 2026 · druid.apache.org
- Deployment
- Druid can run on commodity hardware in *NIX environments and is designed to run in AWS, GCP, Azure, and other cloud environments.Read 2 Oct 2026 · druid.apache.org
- Integrations
- Core extensions support systems and formats including S3, HDFS, Google Cloud Storage, Azure, Kafka, Kinesis, Avro, ORC, Parquet, MySQL, and PostgreSQL.Read 1 Oct 2026 · druid.apache.org
- Security
- Security features include TLS, authentication, and authorization, but they are disabled by default and the documentation says to configure them for production.Read 2 Oct 2026 · druid.apache.org
- Support
- The project directs users to its community network for help using Druid.Read 2 Oct 2026 · druid.apache.org
- License
- Apache Druid and its documentation are licensed under the Apache License, Version 2.0.Read 1 Oct 2026 · druid.apache.org
- Architecture
- Loosely coupled ingestion, query, and orchestration components with deep storage support scale-up and scale-out.Read 1 Oct 2026 · druid.apache.org
- Authentication options
- Documented authenticator extensions include HTTP Basic authentication, LDAP, and Kerberos.Read 2 Oct 2026 · druid.apache.org
- Concurrency
- The project describes Druid as supporting workloads from hundreds to tens of thousands of queries per second at consistent performance.Read 2 Oct 2026 · druid.apache.org
- Extensions
- Core extensions add support for storage, metadata stores, formats, authentication, and other capabilities; examples include S3, HDFS, Azure, Kafka, and PostgreSQL.Read 2 Oct 2026 · druid.apache.org
- Ingestion
- Druid integrates natively with Apache Kafka and Amazon Kinesis for low-latency streaming ingestion and query-on-arrival.Read 2 Oct 2026 · druid.apache.org
- 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.Read 2 Oct 2026 · druid.apache.org
- Latest release
- The latest stable release is Apache Druid 37.0.0, released May 8, 2026.Read 1 Oct 2026 · druid.apache.org
- 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.Read 2 Oct 2026 · druid.apache.org
- OLAP scale
- Druid executes OLAP queries in milliseconds on high-cardinality datasets containing billions to trillions of rows.Read 1 Oct 2026 · druid.apache.org
- Operating systems
- The quickstart supports Linux, Mac OS X, and other Unix-like operating systems; Windows is not supported.Read 1 Oct 2026 · druid.apache.org
- Query languages
- Druid supports both Druid SQL and JSON-over-HTTP native queries.Read 1 Oct 2026 · druid.apache.org
- Query performance
- The project says Druid can execute OLAP queries in milliseconds over datasets with billions to trillions of rows.Read 2 Oct 2026 · druid.apache.org
- Reliability
- Druid provides continuous backup, automated recovery, and multi-node replication for high availability and durability.Read 1 Oct 2026 · druid.apache.org
- SQL and joins
- Druid provides a SQL API and supports joins during ingestion and at query time.Read 2 Oct 2026 · druid.apache.org
- Storage and indexing
- Ingested data is columnarized, time-indexed, dictionary-encoded, bitmap-indexed, and compressed.Read 2 Oct 2026 · druid.apache.org
- Storage format
- Druid automatically columnarizes, time-indexes, dictionary-encodes, bitmap-indexes, and compresses ingested data.Read 1 Oct 2026 · druid.apache.org
- Streaming
- Native Apache Kafka and Amazon Kinesis integrations provide query-on-arrival, ingestion at millions of events per second, low latency, and guaranteed consistency.Read 1 Oct 2026 · druid.apache.org
- System requirement
- The local quickstart requires a machine with at least 6 GiB of RAM and Java 17.Read 1 Oct 2026 · druid.apache.org
- Web console
- The web console loads data, manages datasources and tasks, displays server status and segments, and runs SQL and native queries.Read 1 Oct 2026 · druid.apache.org
Plans and prices
Strong points and limits
Strong points
- Free and licensed under Apache License 2.0.
- Supports Kafka and Kinesis streaming ingestion.
- Offers SQL and JSON-over-HTTP queries.
- Web console manages data and runs queries.
Limits
- Windows is not supported.
- Security features are disabled by default.
- Quickstart needs 6 GiB RAM and Java 17.
Who it suits
Druid suits teams building user-facing analytics or working with streaming data, low-latency queries and ad hoc exploration. It is a fit for those able to configure and operate a self-hosted deployment.
Apache Druid in depth
Read the full write-up
Overview
Apache Druid is an analytics database for teams that need to query large, changing datasets quickly. It is a strong fit for user-facing analytics and exploratory work where fresh data and high query concurrency matter; it is a less natural choice for full-text search or general-purpose database duties.
Druid’s ingestion, query, and orchestration components are loosely coupled, with deep storage supporting scale-up and scale-out deployments. That architecture can serve workloads ranging from hundreds to 100,000 queries per second, and the project describes millisecond OLAP queries across billions to trillions of rows. These are ambitious target capabilities, not a substitute for sizing a deployment to its workload. Druid 37.0.0, released May 8, 2026, is the latest stable release, 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 teams can analyze streams alongside data from object stores, databases, and files. This breadth makes it useful when an application needs recent events and historical context in the same analytical system.
Indexed storage and query interfaces
Druid automatically turns ingested data into compressed columnar storage, applying time indexes, dictionary encoding, and bitmap indexes. This is designed to make selective analytical queries fast, especially on high-cardinality data. Users can query through Druid SQL or native JSON-over-HTTP queries; SQL joins are supported during ingestion and at query time.
Operations, integrations, and security
The web console can load data, manage datasources and tasks, show server and segment status, and run both query types. Core extensions connect Druid to systems and formats including S3, HDFS, Google Cloud Storage, Azure, Kafka, Kinesis, Avro, ORC, Parquet, MySQL, and PostgreSQL. Continuous backup, automated recovery, and multi-node replication support availability and durability, though these capabilities still require a deployment designed and operated for production.
Security features are disabled by default. Production operators must configure TLS, authentication, and authorization; documented authenticator extensions include HTTP Basic, LDAP, and Kerberos. That flexibility is useful in managed environments, but it makes security setup an essential part of deployment rather than an optional finishing touch.
Pricing
Apache Druid: free. This open-source analytics database is downloadable for self-hosting, with real-time ingestion and SQL support. There is no paid Druid plan in the stated offering; teams supply and operate their own infrastructure. The Apache License, Version 2.0 applies to the software and documentation.
For a local quickstart, the machine needs at least 6 GiB of RAM and Java 17. The quickstart supports Linux, Mac OS X, and other Unix-like systems, but not Windows. The project points users to Slack and GitHub for help and names Cloudera, Datumo, Deep.BI, Imply, and Rill Data as commercial support providers.
Platforms
Druid runs on Linux, macOS, Unix-like systems, and self-hosted environments, and is designed for AWS, GCP, Azure, and other cloud environments. The quickstart does not support Windows. API and web-console access provide additional ways to work with the system, but a local deployment still needs Java 17 and at least 6 GiB of RAM.
Who it's for
Consider Druid for streaming analytics, low-latency high-concurrency queries, applications that need immediate data visibility, and ad hoc exploration. It is particularly compelling when teams need to ingest and query structured or semi-structured data at scale. For full-text search over text logs, it is not a common choice; its ability to ingest and analyze semi-structured formats such as JSON does not make it a search engine.
Pros and cons
Fast analytics at substantial scale: Druid is designed for millisecond OLAP queries over very large datasets and high query volumes, making it suited to interactive and user-facing workloads.
Fresh data with broad ingestion: Kafka and Kinesis integrations enable low-latency streaming, while batch sources let teams combine event streams with stored data.
Operational flexibility: Loosely coupled components, deep storage, backup, recovery, and replication support distributed deployments, but operators must manage the system and configure production security themselves.
Local setup has real prerequisites: The quickstart requires Java 17 and at least 6 GiB of RAM, and Windows is unsupported.
Not aimed at full-text search: Teams searching text logs should choose a tool built for that workload rather than treating Druid’s semi-structured data support as a substitute.
Alternatives
Streaming Analytics Software, Columnar Databases, OLAP Databases, OLAP Software, and Database Software are useful category starting points.
Timeplus is worth considering for a lightweight streaming SQL engine: its open-source Proton plan is a single binary under 500MB, and the service also offers a free trial.
Confluent Cloud suits teams seeking managed, serverless Kafka resources, autoscaling, and more than 80 managed connectors, with a free Basic plan and free trial.
Materialize offers a self-managed Community License capped at 24 GiB of memory and 48 GiB of disk, or a Cloud Capacity plan priced at 1.50 USD; consider it when those deployment and capacity terms fit.
Apache Storm is a free, open-source option for teams looking for a distributed stream-processing system rather than Druid’s analytics-database focus.
Feldera offers an open-source edition with full SQL support and all connectors in a single-node, single-container setup; it is a candidate when that model suits the workload.
Apache Beam provides an open-source programming model; execution costs depend on the runner and infrastructure selected.
Ververica Platform has a free Community Edition that may require a license and may restrict use; check its terms if those conditions matter.
RisingWave offers self-managed Apache 2.0 open source without feature gates, license fees, or usage restrictions, for teams prioritizing those terms.
Verdict
Choose Apache Druid when your team needs fast, highly concurrent analytics across streaming and batch data and can operate a self-hosted distributed system. Its combination of query-on-arrival, indexed columnar storage, and open-source licensing is compelling for that job. Look elsewhere if you need full-text log search, Windows quickstart support, or a deployment that avoids security and operations work.
Verdict
Apache Druid is aimed at fast analytics across streaming and batch data, with multiple query interfaces and integrations. Production deployments need security configuration, and local setup has stated system requirements.
Where Specifiction places it
- Big Data Analytics Software#2 of 309.0
- Stream Analytics Software#2 of 269.0
- Streaming Analytics Software#2 of 259.0
- OLAP Software#3 of 329.0
- Analytics Databases#3 of 319.0
- Analytics Data#3 of 309.0
- OLAP Databases#3 of 309.0
- Analytical Data Store Software#4 of 289.0
- Columnar Databases#6 of 279.0
- Database Software#18 of 748.7