Hacker GitHub

← All repos

ClickHouse/ClickBench

View on GitHub ↗ ★ 1,152 Shell

ClickBench: a Benchmark For Analytical Databases

73 mentions on Hacker News by 33 people: 4 stories, 69 comments · first 2022-07-13 · latest 2026-11-02

Mentions per year 73 mentions · busiest year 2026 (27)
20082026
AllStoriesComments NewestTopOldest
  1. It can be applied for a larger dataset, see https://github.com/ClickHouse/ClickBench/tree/main/clickhous... (100 billion records), but so far only ClickHouse has been tested on this volume - it takes too much time and cost to load this…
    comment by zX41ZdbW · 2023-05-19 · in Can you even trust benchmarks these days? ClickHouse vs. Druid vs. Rockset
  2. …publishes a list of Limitations that everyone should keep in mind as they run ClickBench: https://github.com/ClickHouse/ClickBench/#limitations CelerData (based on StarRocks) also wrote up this: https://celerdata.com/blog/what-you-should-kn…
    comment by PeterCorless · 2023-05-19 · in Can you even trust benchmarks these days? ClickHouse vs. Druid vs. Rockset
  3. I am the author of ClickBench: https://github.com/ClickHouse/ClickBench/ You can check the methodology described in the README and check the pull requests submitted by many database vendors.
    comment by zX41ZdbW · 2023-05-19 · in Can you even trust benchmarks these days? ClickHouse vs. Druid vs. Rockset
  4. One way to add some trust is to make benchmarks open-source and reproducible: https://github.com/ClickHouse/ClickBench/ (I work at ClickHouse)
    comment by ryadh · 2023-05-19 · in Can you even trust benchmarks these days? ClickHouse vs. Druid vs. Rockset
  5. I recommend checking ClickBench: https://github.com/ClickHouse/ClickBench Disclaimer: I'm the author of ClickBench. It contains the comparison of Datafusion, DuckDB as well, and 30+ more DB engines in an open benchmark. The results of…
    comment by zX41ZdbW · 2023-05-19 · in Comparison of DataFusion and DuckDB using TPC-H benchmarks
  6. …and Boilingdata, that are currently missing from the benchmark. Please help me adding them: https://github.com/ClickHouse/ClickBench Also, it includes another mode of ClickHouse, named "web" - MergeTree tables hosted on a HTTP server…
    comment by zX41ZdbW · 2023-04-24 · in Throwing lots of data at DuckDB and Athena
  7. it's like duckdb, but it is base on ClickHouse, here is chdb benchmark: https://github.com/ClickHouse/ClickBench/pull/96/files , , it's waiting for merge. you can checkout benchmark result over here.
    comment by kongsys · 2023-04-19 · in ServerLess OLAP with Chdb
  8. …as the number of query workers is selected dynamically on a per-query basis. [1] ClickBench: https://github.com/ClickHouse/ClickBench/ [2] https://cube.dev/blog/dewitt-clause-or-can-you-benchmark-a-d...
    comment by zX41ZdbW · 2023-02-28 · in ClickHouse to Serve Real-Time Queries on Top of BigQuery Data
  9. …I created a dataset of 100 billion records. Here is a description of how to generate this dataset: https://github.com/ClickHouse/ClickBench/tree/main/clickhous... Basically, you train a model on the existing dataset, then run the generator…
    comment by zX41ZdbW · 2023-02-17
  10. I did not find a reliable way to query MongoDB with SQL: https://github.com/ClickHouse/ClickBench/blob/main/mongodb/q... It looks like it's only available in the Atlas service. Please correct me if I'm wrong. Writing analytic queries in JS…
    comment by zX41ZdbW · 2023-02-08 · in NoSQL: The Baby and the Bathwater
  11. …is multi-node, which puts it in a different category -- with considerably higher costs. [1]: https://github.com/ClickHouse/ClickBench/blob/main/greenplum...
    comment by wuputah · 2022-12-13 · in Hydra – the fastest Postgres for analytics [benchmarks]
  12. There is a good reference to the available benchmarks for analytical databases: https://github.com/ClickHouse/ClickBench#similar-projects
    comment by zX41ZdbW · 2022-10-05 · in ClickHouse Cloud is now in Public Beta
  13. …scans with filters, aggregations, and sorts. Since it's a single table, there are no joins. [0]: https://github.com/ClickHouse/ClickBench/blob/main/snowflake...
    comment by carlineng · 2022-10-04 · in ClickHouse Cloud is now in Public Beta
  14. …better. You can read more on the specifics of ClickBench methodology in the GitHub repository here: https://github.com/ClickHouse/ClickBench/ There are other responses from ClickHouse in the comments on the pricing, so I'll defer to their…
    comment by thomoco · 2022-10-04 · in ClickHouse Cloud is now in Public Beta
  15. …vary between tests. However, I think the point in providing the open-source ClickBench benchmark [ https://github.com/ClickHouse/ClickBench ] is exactly to allow users to do their own research in providing a standardized client and…
    comment by thomoco · 2022-07-13 · in Show HN: A benchmark for analytical databases (Snowflake, Druid, Redshift)
  16. Databricks is in the list of systems I want to add: https://github.com/ClickHouse/ClickBench/#systems-included
    comment by zX41ZdbW · 2022-07-13 · in Show HN: A benchmark for analytical databases (Snowflake, Druid, Redshift)
  17. …was selected to get 16 cores in total, so it is 4 nodes of ra3.xplus 4vCPU to get 16vCPU in total. https://github.com/ClickHouse/ClickBench/tree/main/redshift We can add more results on different configurations easily. There is also…
    comment by zX41ZdbW · 2022-07-13 · in Show HN: A benchmark for analytical databases (Snowflake, Druid, Redshift)
  18. There are many limitations of this benchmark, indeed: https://github.com/ClickHouse/ClickBench/#limitations
    comment by zX41ZdbW · 2022-07-13 · in Show HN: A benchmark for analytical databases (Snowflake, Druid, Redshift)
  19. ….dev/blog/dewitt-clause-or-can-you-benchmark-a-d... The benchmark instructions for BigQuery are here: https://github.com/ClickHouse/ClickBench/tree/main/bigquery If you follow them, just add the .json with the results and regenerate the…
    comment by zX41ZdbW · 2022-07-13 · in Show HN: A benchmark for analytical databases (Snowflake, Druid, Redshift)