weijingtao / eventql

The EventQL Database

EventQL

EventQL is a distributed, column-oriented database built for large-scale event collection and analytics. It runs super-fast SQL and JavaScript queries.

Documentation & Examples: eventql.io

Features

• Tables are transparently split into ordered partitions by primary key and distributed onto many machines
• Supports INSERT, UPDATE and DELETE operations
• Supports flat and complex/nested tables (OBJECT/ARRAY column types). Table rows can be inserted and retrieved as JSON objects.
• Rows are stored in a column oriented fashion. Queries only read required data for referenced columns.
• (Almost) complete SQL 2009 support. (It does JOINs!)
• Queries are also automatically parallelized and executed on many machines in parallel
• Scales to hundreds of terrabytes per table, thousands of tables per cluster
• "Shared nothing" design. An EventQL cluster consists of many equally privileged servers
• Fully transparent query caching when the same query is repeatedly executed on (partially) unchanged data
• Written in modern C++11 with extensive documentation. Commercial support available

Build

Before we can start we need to install some build dependencies. Currently you need a modern c++ compiler, libz, autotools and python (for spidermonkey/mozbuild)

# Ubuntu
$ apt-get install clang++ cmake make automake autoconf zlib1g-dev

# OSX
$ brew install automake autoconf

To build EventQL from a distribution tarball:

$ ./configure
$ make
$ sudo make install

To build EventQL from a git checkout:

$ git clone [email protected]:eventql/eventql.git
$ cd eventql
$ ./autogen.sh
$ ./configure
$ make V=1
$ src/evql -h

To run the test suite:

$ make test