Using ClickHouse to scale an events engine

Re:Using ClickHouse to scale an events engine by hipadev23 on Thursday April 11, 2024 @04:42PM (#40006599)

It sounds like you’re probably using Clickhouse Cloud? If so, I was not impressed. Overly pushy sales people, pricing isn’t competitive, and they’re trying to cater to the snowflake/databricks crowd without smoothing any rough edges (like the default timeout being enabled on a GUI).

Overall I’d say CH isn’t as tolerant or forgiving as BigQuery, Snowflake, or Databricks. You can write the worst SQL possible and BQ will happily charge you $5/TB for that cartesian self-join. CH meanwhile will error with memory limit or even crash.

[ Parent | on HN ]

Re:Using ClickHouse to scale an events engine by joshstrange on Thursday April 11, 2024 @04:45PM (#40006631)

We are using Altinity. I believe it's a 3-server cluster and we have 2 clusters (our prod one and another one we are trying to promote to production once our data integrity checks pass, at which point we will spin the other down).

[ Parent | on HN ]

Re:Using ClickHouse to scale an events engine by hipadev23 on Thursday April 11, 2024 @04:51PM (#40006685)

Robert Hodges of Altinity will likely be here shortly, they monitor HN for any mention of clickhouse, maybe they can get you fixed up without their standard $10k/mo support contract.

[ Parent | on HN ]

Re:Using ClickHouse to scale an events engine by hodgesrm on Friday April 12, 2024 @03:20AM (#40010166)

Hi Josh, sorry to hear about the issues. Sounds like things that should be solvable. ClickHouse does require thinking a bit differently from other stores like BigQuery. I sent you an email. Feel free to contact me at the email posted on my HN account. Looking forward to helping you bend ClickHouse to your will.

[ Parent | on HN ]