starrocks-schema-evolution

What problem does it solve?

StarRocks schema evolution often risks breaking downstream queries, causing downtime, or triggering unintended full rewrites when changing columns in production.

Core Features & Use Cases

• DIRECT / LINKED / SORT change guidance: classifies ALTER TABLE COLUMN operations by whether they are metadata-only, background backfilled, or require full tablet rewrites.
• Safe ALTER patterns for ADD/DROP/MODIFY/REORDER: covers nullable vs defaulted columns, allowed type widenings, restrictions for key columns, and safe drop constraints.
• Operational monitoring and rollback safety: explains how to track progress via SHOW ALTER TABLE COLUMN, when to cancel jobs safely, and how to use expand-contract patterns for breaking changes and dbt model evolution.

Quick Start

Use the skill to plan and execute a zero-downtime StarRocks schema change by adding a new nullable column to a production table, monitoring the job state until FINISHED, and updating dbt settings to append new columns without dropping existing ones.