starrocks-partitioning

What problem does it solve?

It helps you design and operate an effective partitioning strategy in StarRocks so queries scan only relevant data, while you automate partition creation, pruning verification, and lifecycle actions for time-series and category workloads.

Core Features & Use Cases

• Choose the right partitioning method: manual RANGE, dynamic RANGE, expression-based partitioning (StarRocks 3.0+), and LIST partitioning for discrete categories.
• Prevent slow full scans: validate partition pruning using EXPLAIN and avoid query patterns that disable pruning (e.g., wrapping the partition column in functions or problematic type casts).
• Automate partition lifecycle: manage retention and pre-creation with dynamic partition properties, and perform operational DDL for ADD/DROP/TRUNCATE.
• Implement hot/cold tiering: move partitions between SSD and HDD using per-partition storage medium settings and cooldown timestamps.

Quick Start

Load the starrocks-partitioning skill and ask: "Design a daily dynamic RANGE partitioning scheme for my StarRocks event table with 90-day retention, 3-day pre-creation, SSD hot storage, and explain how to verify partition pruning with EXPLAIN."