Analytic database comparison

We found an in-depth article that compares several of the leading analytic databases. So if you are in the market for an analytic database, this might be a good place to do some comparison shopping. We have personally taken a look at Exasol and found that it performs well. Find our postings about Exasol here:  Exasol postings at Realized Design.

The database engines compare include:

• Greenplum
• Yandex Clickhouse
• SAP HANA
• EXASOL
• MemSQL
• Impala

Below are the summary results from the web site. If you want the full details, you can find them here: [The site is in Russian, so you'll want to enable translation.]
Development → Comparison of analytical in-memory database.

Results reported are in seconds - lower is better:

Inquiry	Greenplum	Exasol	Clickhouse	Memsql	SAP Hana	Impala
N1	14	<1	-	108	6	78
N2	131	eleven	-	-	127	Error
N3	67	85	-	-	122	733
T1	14	1.8	64	70	20	100
T2	17	4.2	86	105	20	127
D1	1393	284	-	45	1500	-
D2	> 7200	1200	-	> 7200	Error	-

Clickhouse Benchmarks

On the clickhouse.yandex site, they list several benchmark tests comparing Clickhouse to several other analytic databases.  But - none of the queries JOIN another table.  So sadly, not a very useful comparison.  See:  https://clickhouse.yandex/benchmark.html

MemSQL vs. MySQL (w/ InnoDB)

Good read with thoughtful comments on comparing the two: https://dom.as/2012/06/26/memsql-rage/