skills.rest
ivanshamaev
ivanshamaevCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

starrocks-partitioning

Configure StarRocks RANGE and LIST partitioning with dynamic properties and pruning checks.

14|1|Updated May 5, 2026
Search Tags:#partitioning#partition pruning#starrocks#dynamic partitions#hot cold tiering#show partitions#range list
One-click install
npx skills add https://github.com/ivanshamaev/de-agent-skills --skill starrocks-partitioning
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: starrocks-partitioning
Source: https://github.com/ivanshamaev/de-agent-skills/tree/main/group_skills/starrocks_group_skills/starrocks_partitioning
Command: npx skills add https://github.com/ivanshamaev/de-agent-skills --skill starrocks-partitioning

SYSTEM DOCUMENTATION & REQUIREMENTS

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."

Frequently Asked Questions about starrocks-partitioning

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a StarRocks partitioning strategy to minimize scanned data?▼

Design a StarRocks partitioning strategy by selecting manual RANGE, dynamic RANGE, expression-based, or LIST partitioning based on your workload. This minimizes scanned data by allowing queries to target only relevant data segments instead of performing full table scans.

How do I verify partition pruning in StarRocks using EXPLAIN?▼

Verify partition pruning in StarRocks by running the EXPLAIN command on your query. This reveals whether the query planner successfully excludes irrelevant partitions, helping you identify and avoid query patterns like function-wrapped partition columns that disable pruning.

How do I automate partition creation and retention in StarRocks?▼

Automate StarRocks partition creation and retention by configuring dynamic partition properties. This allows you to set pre-creation windows for upcoming time periods and automatically drop expired partitions, managing the table lifecycle without manual DDL intervention.

Can I implement hot and cold tiering for StarRocks partitions?▼

You can implement hot and cold tiering in StarRocks by moving partitions between SSD and HDD storage mediums. This is managed through per-partition storage medium settings and cooldown timestamps to optimize storage costs for time-series data.

What is the difference between RANGE and LIST partitioning in StarRocks?▼

RANGE partitioning in StarRocks organizes data by continuous intervals like dates for time-series workloads, while LIST partitioning groups data by discrete category values. Choosing between them depends on whether your data is queried by time ranges or categorical attributes.

Why does my StarRocks partition pruning stop working for certain queries?▼

StarRocks partition pruning stops working when query patterns disable it, such as wrapping the partition column in functions or applying problematic type casts. Rewriting these queries to use direct comparisons on the raw partition column restores pruning efficiency.

Related Skills

Explore More Software Engineering Skills→
ivanshamaevivanshamaev
14

dbt-starrocks-models

Generate StarRocks-compatible dbt model definitions with DDL and incremental strategies.

Community
Advanced
icartshicartsh
4

sql-optimization-patterns

Analyze EXPLAIN plans and implement indexing strategies to optimize SQL queries.

Community
Advanced
timequitytimequity
6

warehouse-optimization

Optimize data warehouse queries and storage across Snowflake, BigQuery, and Redshift.

Official
Intermediate
StarRocksStarRocks
73

data-lake

Diagnose StarRocks external catalog query failures and stale data.

Official
Advanced