This skill provides specialized guidance for ClickHouse, the high-performance OLAP database, focusing on schema design, query optimization, and data engineering best practices. It helps developers implement efficient MergeTree engines, utilize materialized views for real-time aggregation, and write complex analytical queries for time-series, funnel, and cohort analysis. By applying these patterns, users can maximize the performance of columnar storage and parallel query execution while ensuring robust data ingestion and effective resource monitoring.
主要功能
01Real-time aggregation using Materialized Views
02Query optimization for high-cardinality data filtering
03High-performance batch and stream data ingestion patterns
04Complex analytical query templates for retention and funnels
05112,913 GitHub stars
06Advanced MergeTree family engine schema design
