EventQL

Open source

Distributed columnar database for streaming event and time series data, queried with SQL and MapReduce and written in C++.

Open-source alternative to

GitHub stars
1.2k
Last 30 days
-1(+0%)
Last commit
9 yr ago
Repository age
10 years
Version
v0.4.1
Licence
Custom
Self-hosted
Yes

About EventQL

EventQL is a distributed, columnar database built for large-scale data collection and analytics. It takes in a large volume of streaming writes and answers SQL and MapReduce queries. Tables are split into partitions by primary key and spread over many machines, so the number of shards does not have to be set upfront.

Writes are keyed. INSERT, UPSERT and DELETE work on the primary key, and UPSERT is the suggested route to exactly-once ingestion from streaming sources. Queries use almost complete SQL 2009, including JOINs, and run in parallel on many machines. Data can be read and written through an HTTP API or a native TCP protocol, and REPEATED and RECORD column types let arbitrary JSON objects go into rows.

Every node in a cluster has equal standing, with no single point of failure. The server ships as a single binary and needs only Zookeeper or a similar coordination service. It is built from a tarball or git checkout with configure and make, and the README lists apt and Homebrew packages for the build tools. The project says it targets analytics (OLAP) rather than transactional workloads.

Key features

  • Tables split automatically into partitions by primary key
  • Primary-key INSERT, UPSERT and DELETE operations
  • Columnar storage engine to cut I/O
  • Near-complete SQL 2009 with joins
  • HTTP API plus a native TCP protocol
  • Range scans over ordered partitions
  • REPEATED and RECORD types for JSON objects

Good fit for

  • Storing and analysing streaming event data
  • Logging high-volume sensor data
  • Joining time series with relational tables
Built with
C++ tools
Tags
database
distributed
columnar
sql
analytics
timeseries
cpp

EventQL: questions and answers

What is EventQL used for?
EventQL is a distributed columnar database for streaming event and time series data, queried with SQL and MapReduce and written in C++. It is a good fit for storing and analysing streaming event data, logging high-volume sensor data, and joining time series with relational tables.
Is EventQL open source?
Yes. EventQL is open source under a custom licence. Its source code is on GitHub at eventql/eventql and is written mainly in C++.
Is EventQL free?
Yes. EventQL is open source, so the software itself is free to use under the terms of its own licence.
Can I self-host EventQL?
Yes. EventQL can be self-hosted on your own server or infrastructure.
What is EventQL an alternative to?
EventQL is an open-source alternative to Google BigQuery and Snowflake. Other open-source alternatives to Google BigQuery include ClickHouse, Trino and Apache Doris.
Is EventQL actively maintained?
The most recent commit to EventQL was on 6 May 2017, and the latest release is v0.4.1, published on 28 February 2017. The project has 1.2k stars on GitHub.

Open-source alternatives to EventQL

See all

SaaS alternatives to EventQL

See all