News for hackers. Stuff that matters.
Re:ClickHouse raises $350M Series C by jgalt212 on Thursday May 29, 2025 @01:04PM (#44127985)
I'm not sure storing 900B or 900MM records for analytics benefits anyone other than AWS. Why not sample?
Re:ClickHouse raises $350M Series C by sethhochberg on Thursday May 29, 2025 @01:19PM (#44128128)
A use case where we reached for Clickhouse years ago at an old job was for streaming music royalty reporting. Days of runtime on our beefy MySQL cluster, minutes of runtime in a very naively optimized Clickhouse server. And sampling wasn't an option because rightholders like the exactly correct amount of money per stream instead of some approximation of the right amount of money :)

There's nothing Clickhouse does that other OLAP DBs can't do, but the killer feature for us was just how trivially easy it was to replicate InnoDB data into Clickhouse and get great general performance out of the box. It was a very accessible option for a bunch of Rails developers who were moonlighting as DBAs in a small company.

Re:ClickHouse raises $350M Series C by jgalt212 on Thursday May 29, 2025 @03:19PM (#44129292)
Yes, payments is an N=all scenario. Analytics is not, however.
Re:ClickHouse raises $350M Series C by antisthenes on Thursday May 29, 2025 @06:15PM (#44130910)
Use-case dependent. For some analytics, you really want to see the tail ends (e.g. rare events) which sampling can sometimes omit or under-represent.