SKILL

clickhouse-io

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

Target: Databases. Automatically collected · unverified.

Excerpt from the author’s documentation

Extracted from a fixed version of SKILL.md in its original language. This is the author’s documentation; installation, compatibility and runtime results have not been verified by this site.

Read the original Chinese text

Topics in the source

ClickHouse 分析模式
概述
表格設計模式
MergeTree 引擎（最常見）
ReplacingMergeTree（去重）
AggregatingMergeTree（預聚合）
查詢優化模式
高效過濾

用於高效能分析和資料工程的 ClickHouse 特定模式。 ClickHouse 是一個列式資料庫管理系統（DBMS），用於線上分析處理（OLAP）。它針對大型資料集的快速分析查詢進行了優化。關鍵特性：列式儲存資料壓縮平行查詢執行分散式查詢即時分析按時間分區（通常按月或日）避免太多分區（效能影響）分區鍵使用 DATE 類型最常過濾的欄位放在最前面考慮基數（高基數優先）排序影響壓縮使用最小的適當類型（UInt32 vs UInt64）重複字串使用 LowCardinality 分類資料使用 Enum SELECT （指定欄位） FINAL（改為在查詢前合併資料）太多 JOINs（為分析反正規化）小量頻繁插入（改用批量）追蹤查詢效能監控磁碟使用檢查合併操作審查慢查詢日誌記住：ClickHouse 擅長分析工作負載。為你的查詢模式設計表格，批量插入，並利用物化視圖進行即時聚合。

Source repository: affaan-m/ECC
Source file: docs/zh-TW/skills/clickhouse-io/SKILL.md
Fixed revision: d2ef2680594f9a17526a6e1a2e18b3d242c5d17b

Read the complete original documentation ↗

Sources and evidence

This record was collected automatically. Its documentation, suitability and runtime behavior have not been manually verified.

Author: affaan-m/ECC · original repository metadata. Documentation review: Not reviewed. Last source check: 2026-11-09T15:01:42.720Z.

Categories are inferred from names, descriptions and paths. They do not establish compatibility.

License and attribution

MIT. Third-party content and copyright remain with their authors. Refer to the original license and terms.

Original license ↗

Synchronization, copying and user-reported success do not mark a resource as runtime-tested.

Original project ↗Original documentation ↗

Limitations and notes

Collecting metadata does not mean this site has installed, adapted, runtime-tested or security-reviewed the resource.