原表
CREATE TABLE "test1"
(
"SCHEDUL_PLAN_DATE" TIMESTAMP(0) NOT NULL,
……
"SCHEDUL_PLAN_TIME" TIMESTAMP(0),
"TASK_TIME" TIMESTAMP(0))
PARTITION BY RANGE("SCHEDUL_PLAN_DATE")

(
PARTITION "TPD_PART_18" VALUES LESS THAN(DATETIME'2023-03-02 00:00:00'),
……
PARTITION "TPD_PART_59" VALUES LESS THAN(DATETIME'2023-12-14 00:00:00'),
PARTITION "TPD_PART_60" VALUES LESS THAN(DATETIME'2023-12-21 00:00:00'),
PARTITION "TPD_PART_61" VALUES LESS THAN(DATETIME'2023-12-28 00:00:00'),
PARTITION "TPD_PART_62" VALUES LESS THAN(DATETIME'2024-01-04 00:00:00')
) STORAGE(ON "DMHR", CLUSTERBTR) ;

1、现在能想到的方式是新建test2
CREATE TABLE "test2"
(
"SCHEDUL_PLAN_DATE" TIMESTAMP(0) NOT NULL,
……
"SCHEDUL_PLAN_TIME" TIMESTAMP(0),
"TASK_TIME" TIMESTAMP(0))
PARTITION BY RANGE("SCHEDUL_PLAN_DATE")
INTERVAL (NUMTODSINTERVAL(7,'DAY'))--间隔7天
(
PARTITION "TPD_PART_18" VALUES LESS THAN(DATETIME'2023-03-02 00:00:00'),
……
PARTITION "TPD_PART_59" VALUES LESS THAN(DATETIME'2023-12-14 00:00:00'),
PARTITION "TPD_PART_60" VALUES LESS THAN(DATETIME'2023-12-21 00:00:00'),
PARTITION "TPD_PART_61" VALUES LESS THAN(DATETIME'2023-12-28 00:00:00'),
PARTITION "TPD_PART_62" VALUES LESS THAN(DATETIME'2024-01-04 00:00:00')
) STORAGE(ON "DMHR", CLUSTERBTR) ;

2、insert into test2 select * from test1
3、重命名test2 为test1

有没有其他alter 修改表属性的方式新增