Comparison with scylladb

unread,

Dec 17, 2019, 1:50:46 PM12/17/19

to ClickHouse

Hi,

I'm a long term Clickhouse fan and a user.

Out of curiosity. Has anyone here come across a meaningful comparison between Clickhouse and Scylladb?

Scylladb is a c implementation of Apache Cassandra and I think a comprehensive comparison might be very beneficial.

Thank you,

- Stefán

unread,

Dec 17, 2019, 2:40:16 PM12/17/19

to ClickHouse

But Scylladb is not an OLAP but the opposite -- K/V.

For example Scylladb unable to run select sum() from multibillion_table group by millions_key

And vice versa CH is super slow on select value from multibillion_table where key=

unread,

Dec 17, 2019, 3:54:12 PM12/17/19

to ClickHouse

This seems to contradict their claims.

I have not looked into this but I possibly will and if I do then I will report findings.

unread,

Dec 17, 2019, 3:59:03 PM12/17/19

to ClickHouse

This seems to be a good lead going forward:

On Tuesday, December 17, 2019 at 7:40:16 PM UTC, Denis Zhuravlev wrote:

unread,

Jan 6, 2020, 8:21:03 PM1/6/20

to ClickHouse

	ScyllaDB	ClickHouse
Servers	83 x n2.xlarge.x86 for the database 24 x c2.medium.x86 for the worker nodes	1 Intel NUC
CPU cores	83 x 28 cores (Intel Xeon Gold 5120) + 24 x 24 cores (AMD EPYC 7401p) = 2900 cores	4 cores (Intel i7-6770HQ)
RAM	83 x 384 GB + 24 x 64 GB = 33408 GB	32 GB
Storage	83 x 3.8TB NVMe SSD + 24 x 960GB SSD = 338 TB NVMe SSD	1 TB NVMe SSD

8.6 seconds vs 542 seconds in ScyllaDB.

On Tuesday, 17 December 2019 14:50:46 UTC-4, Stefán Baxter wrote:

unread,

Jan 8, 2020, 4:43:20 AM1/8/20

to ClickHouse

Thank you Denis

Reply all

Reply to author

Forward