“With our old setup, we kept hearing complaints from customers that it was way too slow. But with ClickHouse, we can now display real-time aggregation results to advertisers.” - Ryu Kiyose, Engineering Manager

ClickHouse is a leading platform for open-source columnar database technology and real-time analytics. With ClickHouse, developers can delve into documentation, case studies, and performance benchmarks to learn how to build highly scalable and performant analytical systems. It provides tips about ClickHouse's storage engine, query execution, and distributed architecture. Developers can gain insights into their data in real-time, enabling them to make informed decisions and extract  business insights.

ClickHouse

SmartNews migrated from Redshift to ClickHouse to power real-time ad performance dashboards for thousands of advertisers. The new streaming architecture reduced query times from hours to seconds, now handling 3 million queries and 60,000 inserts per hour with sub-100ms latency. The system uses materialized views for pre-aggregation, ReplicatedSummingMergeTree for efficient data compression, and HyperLogLog-based uniqCombined function for calculating unique ad reach at scale with ~2% error margin.

How SmartNews powers real-time ad performance dashboards with ClickHouse