About EventQL
EventQL is a distributed database built specifically for large-scale data collection and analytics workloads, aimed at teams that need to ingest very high volumes of streaming data while still running fast SQL and MapReduce-style queries over it. It is designed as a columnar, massively parallel (MPP) system rather than a general-purpose transactional database.
Tables are automatically partitioned by primary key and distributed across machines without manual shard configuration, and the system supports idempotent primary-key-based INSERT, UPSERT and DELETE operations, with UPSERT suited to exactly-once ingestion from streaming sources. Its compact columnar storage engine drastically reduces I/O for analytical workloads compared with row-oriented systems, and it supports nearly complete SQL 2009, including joins, with queries automatically parallelized across many machines. It claims to scale to petabytes across equally privileged servers and supports streaming, low-latency writes, with mutations immediately visible and minimal query latency as low as 0.1 milliseconds.
EventQL natively supports both time-series and relational data models through the same automatic partitioning mechanism. It is written in C++11, and the repository metadata lists its license as Other, so check the license file for exact terms before adopting it, particularly given the project's age and apparently limited recent activity.
Key features
- Automatic table partitioning across machines
- Columnar storage for fast analytical queries
- Idempotent UPSERT for streaming ingestion
- Near-complete SQL 2009 support including joins
- Petabyte-scale distributed architecture
- Sub-millisecond query latency on fresh writes
Good fit for
- →Large-scale event and time-series analytics
- →High-throughput streaming data ingestion with SQL querying
- Built with
- C++
- Tags
- distributed-database
- sql
- analytics
- columnar-storage
- cpp
- timeseries
- self-hosted
EventQL: questions and answers
- What is EventQL used for?
- EventQL is a free, open-source, distributed columnar database and massively parallel SQL query engine written in C++, built for large-scale event collection and analytics. It is a good fit for large-scale event and time-series analytics, and high-throughput streaming data ingestion with SQL querying.
- 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; there is no official hosted version.
- 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 StarRocks, Apache Cloudberry and ClickHouse.
- 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
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
Apache Cloudberry
Databases
One advanced and mature open-source MPP (Massively Parallel Processing) database. Open sou
Apache-2.0vs Snowflake★ 1.4k
ClickHouse
Databases
ClickHouse is a fast open-source column-oriented database management system that allows ge
Apache-2.0vs Snowflake★ 50k
Apache Doris
Databases
Apache Doris is a real-time analytics and hybrid search database for AI agents.
Apache-2.0vs Snowflake★ 16k
Databend
Databases
Data Agent Ready Warehouse : One for Analytics, Search, AI, Python Sandbox. — rebuilt fr
OSSvs Snowflake★ 9.5k
Apache Hive
Databases
Apache Hive
Apache-2.0vs Snowflake★ 6k
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
Amazon Athena
Databases
Serverless interactive query service for analyzing data in Amazon S3 with SQL
SaaS
Amazon Redshift
Databases
Managed cloud data warehouse on AWS for SQL analytics at scale
SaaS
Azure Synapse Analytics
Databases
Microsoft analytics service combining data warehousing, big data and data integration
SaaS
MotherDuck
Databases
Managed cloud service for DuckDB analytics
SaaS
