create table parts (
id int
,created date
)
organize by row
distribute by hash(id)
data capture none
compress no
partition by range(created nulls last)
(
partition 202102 starting from ('2021-02-01') inclusive ending ('2021-03-01') exclusive in ts1 index in ts2 long in ts1,
[...] -- etc
partition 202112 starting from ('2021-12-01') inclusive ending ('2022-01-01') exclusive in ts1 index in ts2 long in ts1
)

create table parts_new (
id int
,created date
,month_int int generated always as (month(created))
)
organize by row
in ts1 index in ts2 long in ts1
distribute by hash(id)
data capture none
compress no
partition by range(month_int)
(starting from 1 ending at 12 every 1)

create table parts_new (
id int
,created date
,month_int int generated always as (month(created))
)
organize by row
in ts1 index in ts2 long in ts1
distribute by hash(id)
data capture none
compress no
partition by range(month_int)
(starting from 0 ending at 1)