Top all-time · #17845
PhoenixAI
Company blog · celerdata.com/blogdatasystems
PhoenixAI is the company blog at celerdata.com, writing about data and systems. Since 2022, 4 different Hacker News readers have linked it 13 times, most often “What You Should Know Before Using ClickBench”. No feed was found, so read it on the site itself.
Too few sampled comments (4) to say how often HN recommends it.?
Why HN links it
HN commenters link this ClickHouse vs. StarRocks benchmark post as evidence that ClickHouse times out on TPC-H join tests. The post is a detailed benchmark comparison.
Summarised by Claude from a sample of 4 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Connect agents to streaming and lakehouse data with sub-second SQL, complex joins, and governed access inside your cloud.
Most-linked posts?
- What You Should Know Before Using ClickBench3 people · 5 mentions · first linked 2023-02-28
What Hacker News says?
The work on materialized views in ClickHouse, from my perspective, is still quite rudimentary. If interested, I suggest looking into the materialized views of StarRocks. StarRocks' materialized views not only support multi-table joins and incremental updates but can also automatically rewrite query requests, so you don't have to modify your SQL statements at all. https://celerdata.com/glossary/materialized-view
Comment linking /glossary/materialized-view
on “ClickHouse Materialized Views for Fast Aggregation and Queries”Submitted 5 Brilliant Lakehouse Architectures as a story · 10 points
HN discussionCH timeouts using joins on TPCH test data. https://celerdata.com/blog/clickhouse-vs.-starrocks-a-detail...
Comment linking /blog/clickhouse-vs.-starrocks-a-detailed-comparison
on “Neeva Acquired by Snowflake”Submitted Is Join a Luxury in Real-Time Analytics? as a story · 2 points
HN discussionnot really. CH times out on TPCH join scenarios. https://celerdata.com/blog/clickhouse-vs.-starrocks-a-detail...
Comment linking /blog/clickhouse-vs.-starrocks-a-detailed-comparison
on “Neeva Acquired by Snowflake”Submitted What You Should Know Before Using ClickBench as a story · 2 points
HN discussionnot really. CH clusters timeout on join testing on TPCH. https://celerdata.com/blog/clickhouse-vs.-starrocks-a-detail...
Comment linking /blog/clickhouse-vs.-starrocks-a-detailed-comparison
on “Neeva Acquired by Snowflake”Submitted ChatGPT Is Now Finding Bugs in Databases as a story · 1 points
HN discussionFull disclosure: I work at StarTree, which is powered by Apache Pinot. ClickHouse's ClickBench is a good general tool. However, it's not the end-all, be-all of performance benchmarking and testing. Its results may or may not be applicable for guidance on the performance of your specific use case when you get to production. It is definitely a stab at getting an objective suite of tools for the real-time analytics spa…
Comment linking /blog/what-you-should-know-before-using-clickbench
on “Can you even trust benchmarks these days? ClickHouse vs. Druid vs. Rockset”Submitted What You Should Know Before Using ClickBench as a story · 1 points
HN discussionSubmitted What You Should Know Before Using ClickBench as a story · 1 points
HN discussionSubmitted What You Should Know Before Using Clickbench as a story · 1 points
HN discussionSubmitted Understanding ClickHouse: Benefits and Limitations as a story · 1 points
HN discussion