Why ClickHouse Dominates OLAP: Features, Configurations, Table Engines and Real‑World Use Cases

This article provides an in‑depth technical overview of ClickHouse, covering its OLAP‑focused architecture, key performance features, detailed configuration files, a comprehensive comparison of its many table engines, common troubleshooting tips, and real‑world deployment patterns for recommendation and advertising systems.

ClickHouseDatabase ConfigurationKafka Engine

0 likes · 68 min read

Why ClickHouse Dominates OLAP: Features, Configurations, Table Engines and Real‑World Use Cases

Past Memory Big Data

Feb 1, 2023 · Databases

From ClickHouse to ByteHouse: Real‑Time Data Analytics Optimization Practices

This article details ByteDance's large‑scale ClickHouse deployment, presents two real‑time analytics use cases—recommendation metrics and ad delivery—and explains the performance bottlenecks encountered and the concrete engineering solutions such as asynchronous indexing, multi‑threaded Kafka Engine, and enhanced Buffer Engine that boosted throughput and ensured data integrity.

Buffer EngineByteHouseClickHouse

0 likes · 11 min read

From ClickHouse to ByteHouse: Real‑Time Data Analytics Optimization Practices

Big Data Technology Architecture

Nov 16, 2021 · Databases

ByteHouse: ClickHouse Enterprise Edition Case Studies and Optimizations at ByteDance

ByteDance’s ByteHouse, a ClickHouse enterprise edition, showcases large‑scale real‑time analytics through two detailed case studies—recommendation system metrics and ad‑delivery data—detailing technical selection, challenges, multi‑threaded Kafka Engine, async indexing, buffer engine enhancements, and the resulting performance gains.

ByteHouseClickHouseKafka Engine

0 likes · 10 min read

ByteHouse: ClickHouse Enterprise Edition Case Studies and Optimizations at ByteDance