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.
Características Principales
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
