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
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
ClickHouse
Databases
ClickHouse is a fast open-source column-oriented database management system that allows ge
Apache-2.0vs Snowflake★ 51k
Trino
Databases
Official repository of Trino, the distributed SQL query engine for big data, formerly know
Apache-2.0vs Amazon Redshift★ 14k
Apache Doris
Databases
Apache Doris is a real-time analytics and hybrid search database for AI agents.
Apache-2.0vs Snowflake★ 16k
StarRocks
Databases
The world's fastest open query engine for sub-second analytics both on and off the data la
Apache-2.0vs Snowflake★ 12k
Databend
Databases
Data Agent Ready Warehouse : One for Analytics, Search, AI, Python Sandbox. — rebuilt fr
OSSvs Snowflake★ 9.5k
CrateDB
Databases
CrateDB is a distributed and scalable SQL database for storing and analyzing massive amoun
Apache-2.0vs SingleStore★ 4.5k
SaaS alternatives to EventQL
See all
Google BigQuery
Databases
Serverless data warehouse for SQL analytics on large datasets
SaaS
Snowflake
Databases
Cloud data platform for warehousing, data sharing and analytics
SaaS
Vertica
Databases
Columnar analytical database for data warehousing and in-database machine learning
SaaS
Amazon Redshift
Databases
Managed cloud data warehouse on AWS for SQL analytics at scale
SaaS
Amazon Athena
Databases
Serverless interactive query service for analyzing data in Amazon S3 with SQL
SaaS
Azure Data Explorer
Databases
Analytics service on Azure for exploring log, telemetry and time-series data with Kusto queries
SaaS
