Apache Druid vs Esper

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.

Esper is a language, compiler, and runtime for complex event processing and streaming analytics in Java and .NET. Its Event Processing Language extends SQL with expressions over events and time. The compiler turns EPL into bytecode that can be packaged in JAR files. Esper and NEsper embed inside Java or .NET processes rather than running as standalone servers. The in-memory runtime is described as memory-efficient and low-latency and does not require external storage or services. Adapters handle CSV, JMS, HTTP, Kafka, database, and socket input and output, with JMX metrics exposure. Queries can join event streams with web services and relational databases through SQL-query or method-invocation joins. Esper Enterprise Edition adds scale-out architecture with elastic scaling, load balancing, fault tolerance, and multi-datacenter support using Apache Kafka and Apache Zookeeper. Listed uses include business-process monitoring, financial applications such as fraud detection, network and application monitoring, and sensor networks. Esper 9.0.0 is listed under GNU GPL (GPL v2); commercial redistribution licenses are available. Production support has Bronze, Silver, and Gold levels, plus a Developer Seat for how-to questions.