db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Range partition

Declarative partitioning splits one logical table into physical partitions by a key. Create the parent first, then one partition per month.

task

Create rp(device_id, ts, temp_c) partitioned by month with partitions rp_jan, rp_feb, rp_mar for January to March 2026.

hints