search

h2oai / db-benchmark

reproducible benchmark of database-like ops
https://h2oai.github.io/db-benchmark
Mozilla Public License 2.0
326 stars 88 forks source link

add ClickHouse #73

Closed jangorecki closed 5 years ago

jangorecki commented 5 years ago

https://github.com/yandex/ClickHouse

jangorecki commented 5 years ago

ideally following two issues should be resolved first:

jangorecki commented 5 years ago

At the current moment 1e7 and 1e8 are successfully finishing using in-memory engine. 1e9 requires disk engine due to lack of memory to process that data size. 1e9 k=2 crashes anyway, even using disk memory. Another reason to consider #65

jangorecki commented 5 years ago

Blocking issue is at the moment https://github.com/yandex/ClickHouse/issues/4518

jangorecki commented 5 years ago

currently blocked by https://github.com/yandex/ClickHouse/issues/5456

jangorecki commented 5 years ago

clickhouse added for basic 5 questions, what is left is q6-q10 and validate answers

jangorecki commented 5 years ago

ClickHouse has been added to groupby benchmark fully, answers validated on 1e7, k=1e2 (only head). All 10 groupby queries are implemented. I will close this issue once fresh run of benchmark timings will get published.

Pending issues related to CH: