Apache Druid

When dashboards must answer in under a second over billions of streaming events, Apache Druid is the real-time analytics database built for the job. Point a supervisor at an Apache Kafka topic or Amazon Kinesis stream and events are queryable on arrival, late data included, with exactly-once guarantees. Batch loads run as SQL: INSERT and REPLACE statements ingest files, and EXTERN reads external sources. Schema auto-discovery adds new columns and types as data lands. Joins run at ingestion or at query time. A web console gathers the daily work in one place: a tabbed Query view with EXPLAIN PLAN and query history, a Connect external data wizard, and pages for datasources, segments, retention rules, supervisors, tasks, services, and lookups. Configurable tiers place hot and cold data on different hardware. Quality-of-service settings shield priority workloads from heavy ones. Clickstream analytics, ad campaign reporting, network telemetry, application performance tracking, and IoT metrics all fit. Applications connect over the HTTP SQL API or the Avatica JDBC driver, and native JSON queries remain available for advanced needs. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. Apache-2.0 licensed.

Apache Druid
Apache Druid
Apache Druid
Apache Druid
Apache Druid

Benefits

  • Query Billions Of Events Instantly
  • Columnar, time-partitioned, bitmap-indexed segments with dictionary encoding let Druid answer OLAP queries on high-cardinality data in milliseconds, without pre-defined aggregates or cached queries.
  • Analyze Streams On Arrival
  • Supervisors connect directly to Apache Kafka and Amazon Kinesis without a connector, accept late data, and keep exactly-once guarantees, so events are queryable the moment they land.
  • Scale Out With Loose Coupling
  • Separate services for ingestion, queries, and coordination sit on a deep storage layer, so each tier scales on its own, and replication with automatic recovery keeps data available.
  • Use Familiar SQL Everywhere
  • Druid SQL covers ingestion, transformation, and querying, applications connect through an HTTP API or the Avatica JDBC driver, and native JSON queries remain available for advanced needs.

Features

  • Tabbed Query View
  • The web console edits and runs SQL in multiple tabs, previews INSERT queries, picks the query engine, shows EXPLAIN PLAN output, and keeps a history of past queries.
  • SQL-Based Ingestion
  • The multi-stage query engine runs INSERT and REPLACE statements as batch tasks, reads external data with EXTERN, and parallelizes work across controller and worker tasks.
  • Kafka And Kinesis Streaming
  • Continuously running supervisors read Apache Kafka and Amazon Kinesis topics directly, ingest late data, and deliver exactly-once guarantees with query-on-arrival.
  • Schema Auto-Discovery
  • Druid detects, defines, and updates column names and data types during ingestion, giving the flexibility of schemaless loading with the speed of strongly typed columns.
  • Tiering And QoS
  • Configurable tiers place hot and cold data on different hardware, and quality-of-service settings prioritize workloads and avoid resource contention in mixed deployments.
  • Cluster Management Views
  • Console pages list datasources, segments, retention rules, supervisors, tasks, services, and lookups, with status details for each supervisor and task.

Apps Similar to Apache Druid