Skill Claude CodeCodex
Workload-aware architecture design for Apache Doris. MUST USE when designing data architectures, choosing between data models, planning ingestion strategies, sizing clusters, or translating business requirements into Apache Doris system designs. Complements doris-best-practices with decision frameworks and…
Skill Claude CodeCodex
Apache Doris table design and cluster sizing best practices. MUST USE when writing, reviewing, or optimizing Doris CREATE TABLE statements, partition/bucket strategies, data models, or cluster configurations. ALSO MUST USE whenever the doris-architecture-advisor skill produces DDL — apply the Pre-Flight Checklist to…
Skill Claude CodeCodex
Apache Doris production diagnostics router. Use when Apache Doris queries are slow, imports are failing or timing out, compaction is raising -235 errors, nodes are OOM or crashing, materialized views are not rewriting, or tablet/replica health is degraded. Routes to the appropriate doris-debug- skill. Covers…
Skill Claude CodeCodex
Use for Doris storage-compute separation (cloud mode) issues: meta-service latency, cache miss storms, object store throughput, and shared-nothing config conflicts in compute groups.
Skill Claude CodeCodex
Use for Doris -235 / too many versions and compaction lag. Error raised in RowsetBuilder::checktabletversioncount when versioncount > maxtabletversionnum (default 2000) or meta serialize size limit.
Skill Claude CodeCodex
Use for Doris external catalog issues: Hive/Iceberg/Paimon/Hudi query failures, metadata refresh, filesystem S3/HDFS connectivity, external MV rewrite misses.
Skill Claude CodeCodex
Use for Doris FE/BE startup failures, port conflicts, prioritynetworks misrouting, metadir corruption, and ADD/DROP BACKEND issues.
Skill Claude CodeCodex
Use for Doris Stream/Broker/Routine Load issues and Group Commit asyncmode WAL pile-up. Tunables: table groupcommitintervalms / groupcommitdatabytes; BE groupcommitinsertthreads, groupcommitwalpath, groupcommitwalmaxdisklimit.
Skill Claude CodeCodex
Use for Doris sync MV (rollup) miss or async MTMV refresh/rewrite issues. Commands: SHOW ALTER TABLE MATERIALIZED VIEW, mvinfos(), EXPLAIN, REFRESH MATERIALIZED VIEW.
Skill Claude CodeCodex
Use for Doris FE/BE OOM, crash, or false Alive. BE: MemTrackerLimiter lines in be.WARNING; FE: JVM heap / jstack. Distinguish heartbeat Alive from query/brpc serving health.
Skill Claude CodeCodex
Use for Apache Doris slow/hanging/timeout queries. Covers FE planner (Nereids timeout), BE Profile bottlenecks, and Exchange WaitForData / brpc E1008 on port 8060. Session vars: enableprofile, querytimeout, nereidstimeoutsecond.
Skill Claude CodeCodex
Use for Doris Workload Group / resource tag queue starvation, CPU/memory isolation leaks, and workload policy debugging. Commands: SHOW WORKLOAD GROUPS, EXPLAIN resource.
Skill Claude CodeCodex
Use for Doris tablet/replica health, version skew, clone backlog, disk balance, and tablet repair. Commands: SHOW PROC tablethealth, SHOW TABLET, ADMIN REPAIR.
Skill Claude CodeCodex
Interpret Apache Doris query runtime profiles, especially profile bottleneck triage, misleading wait counters, per-operator metric priority, scan, join-order/runtime-filter analysis, and evidence-bounded performance explanations. Use when given a Doris profile, query id, profile URL/text, or a request to explain Doris…
Skill Claude CodeCodex
Given a PR URL (/doris-repo-review https://github.com/apache/doris/pull/66807), first check whether the current directory's branch and commit match that PR, and if they do not, align the current directory to the PR head without disturbing local work (refuse to switch when tracked files are modified and hand the…