升级到1.2.4以后,不能delete了(SET delete_without_partition = true) #21524

Hby118 · 2023-07-05T07:19:04Z

Hby118
Jul 5, 2023

之前1.1.3版本还可以
SET delete_without_partition = true
然后
DELETE FROM table
WHERE A = '111'

但是升级到1.2.4以后就报错了
SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = No value present
必须要加分区才给我删
这是为啥

yagagagaga · 2023-07-05T07:27:36Z

yagagagaga
Jul 5, 2023

Can you provide sql which can make me reproduce it?

5 replies

Hby118 Jul 5, 2023
Author

-- ods.ods_mes_p_sn_keyparts definition

CREATE TABLE ods_mes_p_sn_keyparts (
WORK_ORDER varchar(255) NULL,
SERIAL_NUMBER varchar(255) NULL,
STATION_TYPE varchar(255) NULL,
IPN varchar(255) NULL,
ITEM_IPN varchar(255) NULL,
ITEM_SN varchar(255) NULL,
ITEM_GROUP varchar(255) NULL,
VERSION varchar(255) NULL,
STATION_NAME varchar(255) NULL,
ITEM_SN_CUSTOMER varchar(255) NULL,
UPDATE_EMPNO varchar(255) NULL,
UPDATE_TIME datetime NULL,
CREATE_TIME datetime NULL,
ENABLED varchar(50) NULL,
MES_SPEC varchar(255) NULL,
GU_ID varchar(255) NULL,
MODEL varchar(255) NULL COMMENT '机种',
SITE varchar(255) NULL COMMENT 'LXKS/LXSZ',
PLANT varchar(255) NULL COMMENT '厂区',
MFG_TYPE varchar(255) NULL COMMENT 'MLB/FATP',
DATA_SOURCE varchar(255) NULL COMMENT '数据源',
LOCAL_CREATE_BY varchar(255) NULL COMMENT '创建者',
LOCAL_CREATE_TIME varchar(255) NULL COMMENT '创建时间',
LOCAL_UPDATE_BY varchar(255) NULL COMMENT '更新者',
LOCAL_UPDATE_TIME varchar(255) NULL COMMENT '更新时间',
LOCAL_REMARK varchar(255) NULL COMMENT '备注'
) ENGINE=OLAP
DUPLICATE KEY(WORK_ORDER, SERIAL_NUMBER)
COMMENT '产品材料Link记录表'
PARTITION BY RANGE(UPDATE_TIME)
(PARTITION p20220101 VALUES [('0000-01-01 00:00:00'), ('2022-01-02 00:00:00')),
PARTITION p20220102 VALUES [('2022-01-02 00:00:00'), ('2022-01-03 00:00:00')),
PARTITION p20220103 VALUES [('2022-01-03 00:00:00'), ('2022-01-04 00:00:00')),
PARTITION p20220104 VALUES [('2022-01-04 00:00:00'), ('2022-01-05 00:00:00')),
PARTITION p20220105 VALUES [('2022-01-05 00:00:00'), ('2022-01-06 00:00:00')),
PARTITION p20220106 VALUES [('2022-01-06 00:00:00'), ('2022-01-07 00:00:00')),
PARTITION p20220107 VALUES [('2022-01-07 00:00:00'), ('2022-01-08 00:00:00')),
PARTITION p20220108 VALUES [('2022-01-08 00:00:00'), ('2022-01-09 00:00:00')),
PARTITION p20220109 VALUES [('2022-01-09 00:00:00'), ('2022-01-10 00:00:00')),
PARTITION p20220110 VALUES [('2022-01-10 00:00:00'), ('2022-01-11 00:00:00')),
PARTITION p20220111 VALUES [('2022-01-11 00:00:00'), ('2022-01-12 00:00:00')),
PARTITION p20220112 VALUES [('2022-01-12 00:00:00'), ('2022-01-13 00:00:00')),
PARTITION p20220113 VALUES [('2022-01-13 00:00:00'), ('2022-01-14 00:00:00')),
PARTITION p20220114 VALUES [('2022-01-14 00:00:00'), ('2022-01-15 00:00:00')),
PARTITION p20220115 VALUES [('2022-01-15 00:00:00'), ('2022-01-16 00:00:00')),
PARTITION p20220116 VALUES [('2022-01-16 00:00:00'), ('2022-01-17 00:00:00')),
PARTITION p20220117 VALUES [('2022-01-17 00:00:00'), ('2022-01-18 00:00:00')),
PARTITION p20220118 VALUES [('2022-01-18 00:00:00'), ('2022-01-19 00:00:00')),
PARTITION p20220119 VALUES [('2022-01-19 00:00:00'), ('2022-01-20 00:00:00')),
PARTITION p20220120 VALUES [('2022-01-20 00:00:00'), ('2022-01-21 00:00:00')),
PARTITION p20220121 VALUES [('2022-01-21 00:00:00'), ('2022-01-22 00:00:00')),
PARTITION p20220122 VALUES [('2022-01-22 00:00:00'), ('2022-01-23 00:00:00')),
PARTITION p20220123 VALUES [('2022-01-23 00:00:00'), ('2022-01-24 00:00:00')),
PARTITION p20220124 VALUES [('2022-01-24 00:00:00'), ('2022-01-25 00:00:00')),
PARTITION p20220125 VALUES [('2022-01-25 00:00:00'), ('2022-01-26 00:00:00')),
PARTITION p20220126 VALUES [('2022-01-26 00:00:00'), ('2022-01-27 00:00:00')),
PARTITION p20220127 VALUES [('2022-01-27 00:00:00'), ('2022-01-28 00:00:00')),
PARTITION p20220128 VALUES [('2022-01-28 00:00:00'), ('2022-01-29 00:00:00')),
PARTITION p20220129 VALUES [('2022-01-29 00:00:00'), ('2022-01-30 00:00:00')),
PARTITION p20220130 VALUES [('2022-01-30 00:00:00'), ('2022-01-31 00:00:00')),
PARTITION p20220131 VALUES [('2022-01-31 00:00:00'), ('2022-02-01 00:00:00')),
PARTITION p20220201 VALUES [('2022-02-01 00:00:00'), ('2022-02-02 00:00:00')),
PARTITION p20220202 VALUES [('2022-02-02 00:00:00'), ('2022-02-03 00:00:00')),
PARTITION p20220203 VALUES [('2022-02-03 00:00:00'), ('2022-02-04 00:00:00')),
PARTITION p20220204 VALUES [('2022-02-04 00:00:00'), ('2022-02-05 00:00:00')),
PARTITION p20220205 VALUES [('2022-02-05 00:00:00'), ('2022-02-06 00:00:00')),
PARTITION p20220206 VALUES [('2022-02-06 00:00:00'), ('2022-02-07 00:00:00')),
PARTITION p20220207 VALUES [('2022-02-07 00:00:00'), ('2022-02-08 00:00:00')),
PARTITION p20220208 VALUES [('2022-02-08 00:00:00'), ('2022-02-09 00:00:00')),
PARTITION p20220209 VALUES [('2022-02-09 00:00:00'), ('2022-02-10 00:00:00')),
PARTITION p20220210 VALUES [('2022-02-10 00:00:00'), ('2022-02-11 00:00:00')),
PARTITION p20220211 VALUES [('2022-02-11 00:00:00'), ('2022-02-12 00:00:00')),
PARTITION p20220212 VALUES [('2022-02-12 00:00:00'), ('2022-02-13 00:00:00')),
PARTITION p20220213 VALUES [('2022-02-13 00:00:00'), ('2022-02-14 00:00:00')),
PARTITION p20220214 VALUES [('2022-02-14 00:00:00'), ('2022-02-15 00:00:00')),
PARTITION p20220215 VALUES [('2022-02-15 00:00:00'), ('2022-02-16 00:00:00')),
PARTITION p20220216 VALUES [('2022-02-16 00:00:00'), ('2022-02-17 00:00:00')),
PARTITION p20220217 VALUES [('2022-02-17 00:00:00'), ('2022-02-18 00:00:00')),
PARTITION p20220218 VALUES [('2022-02-18 00:00:00'), ('2022-02-19 00:00:00')),
PARTITION p20220219 VALUES [('2022-02-19 00:00:00'), ('2022-02-20 00:00:00')),
PARTITION p20220220 VALUES [('2022-02-20 00:00:00'), ('2022-02-21 00:00:00')),
PARTITION p20220221 VALUES [('2022-02-21 00:00:00'), ('2022-02-22 00:00:00')),
PARTITION p20220222 VALUES [('2022-02-22 00:00:00'), ('2022-02-23 00:00:00')),
PARTITION p20220223 VALUES [('2022-02-23 00:00:00'), ('2022-02-24 00:00:00')),
PARTITION p20220224 VALUES [('2022-02-24 00:00:00'), ('2022-02-25 00:00:00')),
PARTITION p20220225 VALUES [('2022-02-25 00:00:00'), ('2022-02-26 00:00:00')),
PARTITION p20220226 VALUES [('2022-02-26 00:00:00'), ('2022-02-27 00:00:00')),
PARTITION p20220227 VALUES [('2022-02-27 00:00:00'), ('2022-02-28 00:00:00')),
PARTITION p20220228 VALUES [('2022-02-28 00:00:00'), ('2022-03-01 00:00:00')),
PARTITION p20220301 VALUES [('2022-03-01 00:00:00'), ('2022-03-02 00:00:00')),
PARTITION p20220302 VALUES [('2022-03-02 00:00:00'), ('2022-03-03 00:00:00')),
PARTITION p20220303 VALUES [('2022-03-03 00:00:00'), ('2022-03-04 00:00:00')),
PARTITION p20220304 VALUES [('2022-03-04 00:00:00'), ('2022-03-05 00:00:00')),
PARTITION p20220305 VALUES [('2022-03-05 00:00:00'), ('2022-03-06 00:00:00')),
PARTITION p20220306 VALUES [('2022-03-06 00:00:00'), ('2022-03-07 00:00:00')),
PARTITION p20220307 VALUES [('2022-03-07 00:00:00'), ('2022-03-08 00:00:00')),
PARTITION p20220308 VALUES [('2022-03-08 00:00:00'), ('2022-03-09 00:00:00')),
PARTITION p20220309 VALUES [('2022-03-09 00:00:00'), ('2022-03-10 00:00:00')),
PARTITION p20220310 VALUES [('2022-03-10 00:00:00'), ('2022-03-11 00:00:00')),
PARTITION p20220311 VALUES [('2022-03-11 00:00:00'), ('2022-03-12 00:00:00')),
PARTITION p20220312 VALUES [('2022-03-12 00:00:00'), ('2022-03-13 00:00:00')),
PARTITION p20220313 VALUES [('2022-03-13 00:00:00'), ('2022-03-14 00:00:00')),
PARTITION p20220314 VALUES [('2022-03-14 00:00:00'), ('2022-03-15 00:00:00')),
PARTITION p20220315 VALUES [('2022-03-15 00:00:00'), ('2022-03-16 00:00:00')),
PARTITION p20220316 VALUES [('2022-03-16 00:00:00'), ('2022-03-17 00:00:00')),
PARTITION p20220317 VALUES [('2022-03-17 00:00:00'), ('2022-03-18 00:00:00')),
PARTITION p20220318 VALUES [('2022-03-18 00:00:00'), ('2022-03-19 00:00:00')),
PARTITION p20220319 VALUES [('2022-03-19 00:00:00'), ('2022-03-20 00:00:00')),
PARTITION p20220320 VALUES [('2022-03-20 00:00:00'), ('2022-03-21 00:00:00')),
PARTITION p20220321 VALUES [('2022-03-21 00:00:00'), ('2022-03-22 00:00:00')),
PARTITION p20220322 VALUES [('2022-03-22 00:00:00'), ('2022-03-23 00:00:00')),
PARTITION p20220323 VALUES [('2022-03-23 00:00:00'), ('2022-03-24 00:00:00')),
PARTITION p20220324 VALUES [('2022-03-24 00:00:00'), ('2022-03-25 00:00:00')),
PARTITION p20220325 VALUES [('2022-03-25 00:00:00'), ('2022-03-26 00:00:00')),
PARTITION p20220326 VALUES [('2022-03-26 00:00:00'), ('2022-03-27 00:00:00')),
PARTITION p20220327 VALUES [('2022-03-27 00:00:00'), ('2022-03-28 00:00:00')),
PARTITION p20220328 VALUES [('2022-03-28 00:00:00'), ('2022-03-29 00:00:00')),
PARTITION p20220329 VALUES [('2022-03-29 00:00:00'), ('2022-03-30 00:00:00')),
PARTITION p20220330 VALUES [('2022-03-30 00:00:00'), ('2022-03-31 00:00:00')),
PARTITION p20220331 VALUES [('2022-03-31 00:00:00'), ('2022-04-01 00:00:00')),
PARTITION p20220401 VALUES [('2022-04-01 00:00:00'), ('2022-04-02 00:00:00')),
PARTITION p20220402 VALUES [('2022-04-02 00:00:00'), ('2022-04-03 00:00:00')),
PARTITION p20220403 VALUES [('2022-04-03 00:00:00'), ('2022-04-04 00:00:00')),
PARTITION p20220404 VALUES [('2022-04-04 00:00:00'), ('2022-04-05 00:00:00')),
PARTITION p20220405 VALUES [('2022-04-05 00:00:00'), ('2022-04-06 00:00:00')),
PARTITION p20220406 VALUES [('2022-04-06 00:00:00'), ('2022-04-07 00:00:00')),
PARTITION p20220407 VALUES [('2022-04-07 00:00:00'), ('2022-04-08 00:00:00')),
PARTITION p20220408 VALUES [('2022-04-08 00:00:00'), ('2022-04-09 00:00:00')),
PARTITION p20220409 VALUES [('2022-04-09 00:00:00'), ('2022-04-10 00:00:00')),
PARTITION p20220410 VALUES [('2022-04-10 00:00:00'), ('2022-04-11 00:00:00')),
PARTITION p20220411 VALUES [('2022-04-11 00:00:00'), ('2022-04-12 00:00:00')),
PARTITION p20220412 VALUES [('2022-04-12 00:00:00'), ('2022-04-13 00:00:00')),
PARTITION p20220413 VALUES [('2022-04-13 00:00:00'), ('2022-04-14 00:00:00')),
PARTITION p20220414 VALUES [('2022-04-14 00:00:00'), ('2022-04-15 00:00:00')),
PARTITION p20220415 VALUES [('2022-04-15 00:00:00'), ('2022-04-16 00:00:00')),
PARTITION p20220416 VALUES [('2022-04-16 00:00:00'), ('2022-04-17 00:00:00')),
PARTITION p20220417 VALUES [('2022-04-17 00:00:00'), ('2022-04-18 00:00:00')),
PARTITION p20220418 VALUES [('2022-04-18 00:00:00'), ('2022-04-19 00:00:00')),
PARTITION p20220419 VALUES [('2022-04-19 00:00:00'), ('2022-04-20 00:00:00')),
PARTITION p20220420 VALUES [('2022-04-20 00:00:00'), ('2022-04-21 00:00:00')),
PARTITION p20220421 VALUES [('2022-04-21 00:00:00'), ('2022-04-22 00:00:00')),
PARTITION p20220422 VALUES [('2022-04-22 00:00:00'), ('2022-04-23 00:00:00')),
PARTITION p20220423 VALUES [('2022-04-23 00:00:00'), ('2022-04-24 00:00:00')),
PARTITION p20220424 VALUES [('2022-04-24 00:00:00'), ('2022-04-25 00:00:00')),
PARTITION p20220425 VALUES [('2022-04-25 00:00:00'), ('2022-04-26 00:00:00')),
PARTITION p20220426 VALUES [('2022-04-26 00:00:00'), ('2022-04-27 00:00:00')),
PARTITION p20220427 VALUES [('2022-04-27 00:00:00'), ('2022-04-28 00:00:00')),
PARTITION p20220428 VALUES [('2022-04-28 00:00:00'), ('2022-04-29 00:00:00')),
PARTITION p20220429 VALUES [('2022-04-29 00:00:00'), ('2022-04-30 00:00:00')),
PARTITION p20220430 VALUES [('2022-04-30 00:00:00'), ('2022-05-01 00:00:00')),
PARTITION p20220501 VALUES [('2022-05-01 00:00:00'), ('2022-05-02 00:00:00')),
PARTITION p20220502 VALUES [('2022-05-02 00:00:00'), ('2022-05-03 00:00:00')),
PARTITION p20220503 VALUES [('2022-05-03 00:00:00'), ('2022-05-04 00:00:00')),
PARTITION p20220504 VALUES [('2022-05-04 00:00:00'), ('2022-05-05 00:00:00')),
PARTITION p20220505 VALUES [('2022-05-05 00:00:00'), ('2022-05-06 00:00:00')),
PARTITION p20220506 VALUES [('2022-05-06 00:00:00'), ('2022-05-07 00:00:00')),
PARTITION p20220507 VALUES [('2022-05-07 00:00:00'), ('2022-05-08 00:00:00')),
PARTITION p20220508 VALUES [('2022-05-08 00:00:00'), ('2022-05-09 00:00:00')),
PARTITION p20220509 VALUES [('2022-05-09 00:00:00'), ('2022-05-10 00:00:00')),
PARTITION p20220510 VALUES [('2022-05-10 00:00:00'), ('2022-05-11 00:00:00')),
PARTITION p20220511 VALUES [('2022-05-11 00:00:00'), ('2022-05-12 00:00:00')),
PARTITION p20220512 VALUES [('2022-05-12 00:00:00'), ('2022-05-13 00:00:00')),
PARTITION p20220513 VALUES [('2022-05-13 00:00:00'), ('2022-05-14 00:00:00')),
PARTITION p20220514 VALUES [('2022-05-14 00:00:00'), ('2022-05-15 00:00:00')),
PARTITION p20220515 VALUES [('2022-05-15 00:00:00'), ('2022-05-16 00:00:00')),
PARTITION p20220516 VALUES [('2022-05-16 00:00:00'), ('2022-05-17 00:00:00')),
PARTITION p20220517 VALUES [('2022-05-17 00:00:00'), ('2022-05-18 00:00:00')),
PARTITION p20220518 VALUES [('2022-05-18 00:00:00'), ('2022-05-19 00:00:00')),
PARTITION p20220519 VALUES [('2022-05-19 00:00:00'), ('2022-05-20 00:00:00')),
PARTITION p20220520 VALUES [('2022-05-20 00:00:00'), ('2022-05-21 00:00:00')),
PARTITION p20220521 VALUES [('2022-05-21 00:00:00'), ('2022-05-22 00:00:00')),
PARTITION p20220522 VALUES [('2022-05-22 00:00:00'), ('2022-05-23 00:00:00')),
PARTITION p20220523 VALUES [('2022-05-23 00:00:00'), ('2022-05-24 00:00:00')),
PARTITION p20220524 VALUES [('2022-05-24 00:00:00'), ('2022-05-25 00:00:00')),
PARTITION p20220525 VALUES [('2022-05-25 00:00:00'), ('2022-05-26 00:00:00')),
PARTITION p20220526 VALUES [('2022-05-26 00:00:00'), ('2022-05-27 00:00:00')),
PARTITION p20220527 VALUES [('2022-05-27 00:00:00'), ('2022-05-28 00:00:00')),
PARTITION p20220528 VALUES [('2022-05-28 00:00:00'), ('2022-05-29 00:00:00')),
PARTITION p20220529 VALUES [('2022-05-29 00:00:00'), ('2022-05-30 00:00:00')),
PARTITION p20220530 VALUES [('2022-05-30 00:00:00'), ('2022-05-31 00:00:00')),
PARTITION p20220531 VALUES [('2022-05-31 00:00:00'), ('2022-06-01 00:00:00')),
PARTITION p20220601 VALUES [('2022-06-01 00:00:00'), ('2022-06-02 00:00:00')),
PARTITION p20220602 VALUES [('2022-06-02 00:00:00'), ('2022-06-03 00:00:00')),
PARTITION p20220603 VALUES [('2022-06-03 00:00:00'), ('2022-06-04 00:00:00')),
PARTITION p20220604 VALUES [('2022-06-04 00:00:00'), ('2022-06-05 00:00:00')),
PARTITION p20220605 VALUES [('2022-06-05 00:00:00'), ('2022-06-06 00:00:00')),
PARTITION p20220606 VALUES [('2022-06-06 00:00:00'), ('2022-06-07 00:00:00')),
PARTITION p20220607 VALUES [('2022-06-07 00:00:00'), ('2022-06-08 00:00:00')),
PARTITION p20220608 VALUES [('2022-06-08 00:00:00'), ('2022-06-09 00:00:00')),
PARTITION p20220609 VALUES [('2022-06-09 00:00:00'), ('2022-06-10 00:00:00')),
PARTITION p20220610 VALUES [('2022-06-10 00:00:00'), ('2022-06-11 00:00:00')),
PARTITION p20220611 VALUES [('2022-06-11 00:00:00'), ('2022-06-12 00:00:00')),
PARTITION p20220612 VALUES [('2022-06-12 00:00:00'), ('2022-06-13 00:00:00')),
PARTITION p20220613 VALUES [('2022-06-13 00:00:00'), ('2022-06-14 00:00:00')),
PARTITION p20220614 VALUES [('2022-06-14 00:00:00'), ('2022-06-15 00:00:00')),
PARTITION p20220615 VALUES [('2022-06-15 00:00:00'), ('2022-06-16 00:00:00')),
PARTITION p20220616 VALUES [('2022-06-16 00:00:00'), ('2022-06-17 00:00:00')),
PARTITION p20220617 VALUES [('2022-06-17 00:00:00'), ('2022-06-18 00:00:00')),
PARTITION p20220618 VALUES [('2022-06-18 00:00:00'), ('2022-06-19 00:00:00')),
PARTITION p20220619 VALUES [('2022-06-19 00:00:00'), ('2022-06-20 00:00:00')),
PARTITION p20220620 VALUES [('2022-06-20 00:00:00'), ('2022-06-21 00:00:00')),
PARTITION p20220621 VALUES [('2022-06-21 00:00:00'), ('2022-06-22 00:00:00')),
PARTITION p20220622 VALUES [('2022-06-22 00:00:00'), ('2022-06-23 00:00:00')),
PARTITION p20220623 VALUES [('2022-06-23 00:00:00'), ('2022-06-24 00:00:00')),
PARTITION p20220624 VALUES [('2022-06-24 00:00:00'), ('2022-06-25 00:00:00')),
PARTITION p20220625 VALUES [('2022-06-25 00:00:00'), ('2022-06-26 00:00:00')),
PARTITION p20220626 VALUES [('2022-06-26 00:00:00'), ('2022-06-27 00:00:00')),
PARTITION p20220627 VALUES [('2022-06-27 00:00:00'), ('2022-06-28 00:00:00')),
PARTITION p20220628 VALUES [('2022-06-28 00:00:00'), ('2022-06-29 00:00:00')),
PARTITION p20220629 VALUES [('2022-06-29 00:00:00'), ('2022-06-30 00:00:00')),
PARTITION p20220630 VALUES [('2022-06-30 00:00:00'), ('2022-07-01 00:00:00')),
PARTITION p20220701 VALUES [('2022-07-01 00:00:00'), ('2022-07-02 00:00:00')),
PARTITION p20220702 VALUES [('2022-07-02 00:00:00'), ('2022-07-03 00:00:00')),
PARTITION p20220703 VALUES [('2022-07-03 00:00:00'), ('2022-07-04 00:00:00')),
PARTITION p20220704 VALUES [('2022-07-04 00:00:00'), ('2022-07-05 00:00:00')),
PARTITION p20220705 VALUES [('2022-07-05 00:00:00'), ('2022-07-06 00:00:00')),
PARTITION p20220706 VALUES [('2022-07-06 00:00:00'), ('2022-07-07 00:00:00')),
PARTITION p20220707 VALUES [('2022-07-07 00:00:00'), ('2022-07-08 00:00:00')),
PARTITION p20220708 VALUES [('2022-07-08 00:00:00'), ('2022-07-09 00:00:00')),
PARTITION p20220709 VALUES [('2022-07-09 00:00:00'), ('2022-07-10 00:00:00')),
PARTITION p20220710 VALUES [('2022-07-10 00:00:00'), ('2022-07-11 00:00:00')),
PARTITION p20220711 VALUES [('2022-07-11 00:00:00'), ('2022-07-12 00:00:00')),
PARTITION p20220712 VALUES [('2022-07-12 00:00:00'), ('2022-07-13 00:00:00')),
PARTITION p20220713 VALUES [('2022-07-13 00:00:00'), ('2022-07-14 00:00:00')),
PARTITION p20220714 VALUES [('2022-07-14 00:00:00'), ('2022-07-15 00:00:00')),
PARTITION p20220715 VALUES [('2022-07-15 00:00:00'), ('2022-07-16 00:00:00')),
PARTITION p20220716 VALUES [('2022-07-16 00:00:00'), ('2022-07-17 00:00:00')),
PARTITION p20220717 VALUES [('2022-07-17 00:00:00'), ('2022-07-18 00:00:00')),
PARTITION p20220718 VALUES [('2022-07-18 00:00:00'), ('2022-07-19 00:00:00')),
PARTITION p20220719 VALUES [('2022-07-19 00:00:00'), ('2022-07-20 00:00:00')),
PARTITION p20220720 VALUES [('2022-07-20 00:00:00'), ('2022-07-21 00:00:00')),
PARTITION p20220721 VALUES [('2022-07-21 00:00:00'), ('2022-07-22 00:00:00')),
PARTITION p20220722 VALUES [('2022-07-22 00:00:00'), ('2022-07-23 00:00:00')),
PARTITION p20220723 VALUES [('2022-07-23 00:00:00'), ('2022-07-24 00:00:00')),
PARTITION p20220724 VALUES [('2022-07-24 00:00:00'), ('2022-07-25 00:00:00')),
PARTITION p20220725 VALUES [('2022-07-25 00:00:00'), ('2022-07-26 00:00:00')),
PARTITION p20220726 VALUES [('2022-07-26 00:00:00'), ('2022-07-27 00:00:00')),
PARTITION p20220727 VALUES [('2022-07-27 00:00:00'), ('2022-07-28 00:00:00')),
PARTITION p20220728 VALUES [('2022-07-28 00:00:00'), ('2022-07-29 00:00:00')),
PARTITION p20220729 VALUES [('2022-07-29 00:00:00'), ('2022-07-30 00:00:00')),
PARTITION p20220730 VALUES [('2022-07-30 00:00:00'), ('2022-07-31 00:00:00')),
PARTITION p20220731 VALUES [('2022-07-31 00:00:00'), ('2022-08-01 00:00:00')),
PARTITION p20220801 VALUES [('2022-08-01 00:00:00'), ('2022-08-02 00:00:00')),
PARTITION p20220802 VALUES [('2022-08-02 00:00:00'), ('2022-08-03 00:00:00')),
PARTITION p20220803 VALUES [('2022-08-03 00:00:00'), ('2022-08-04 00:00:00')),
PARTITION p20220804 VALUES [('2022-08-04 00:00:00'), ('2022-08-05 00:00:00')),
PARTITION p20220805 VALUES [('2022-08-05 00:00:00'), ('2022-08-06 00:00:00')),
PARTITION p20220806 VALUES [('2022-08-06 00:00:00'), ('2022-08-07 00:00:00')),
PARTITION p20220807 VALUES [('2022-08-07 00:00:00'), ('2022-08-08 00:00:00')),
PARTITION p20220808 VALUES [('2022-08-08 00:00:00'), ('2022-08-09 00:00:00')),
PARTITION p20220809 VALUES [('2022-08-09 00:00:00'), ('2022-08-10 00:00:00')),
PARTITION p20220810 VALUES [('2022-08-10 00:00:00'), ('2022-08-11 00:00:00')),
PARTITION p20220811 VALUES [('2022-08-11 00:00:00'), ('2022-08-12 00:00:00')),
PARTITION p20220812 VALUES [('2022-08-12 00:00:00'), ('2022-08-13 00:00:00')),
PARTITION p20220813 VALUES [('2022-08-13 00:00:00'), ('2022-08-14 00:00:00')),
PARTITION p20220814 VALUES [('2022-08-14 00:00:00'), ('2022-08-15 00:00:00')),
PARTITION p20220815 VALUES [('2022-08-15 00:00:00'), ('2022-08-16 00:00:00')),
PARTITION p20220816 VALUES [('2022-08-16 00:00:00'), ('2022-08-17 00:00:00')),
PARTITION p20220817 VALUES [('2022-08-17 00:00:00'), ('2022-08-18 00:00:00')),
PARTITION p20220818 VALUES [('2022-08-18 00:00:00'), ('2022-08-19 00:00:00')),
PARTITION p20220819 VALUES [('2022-08-19 00:00:00'), ('2022-08-20 00:00:00')),
PARTITION p20220820 VALUES [('2022-08-20 00:00:00'), ('2022-08-21 00:00:00')),
PARTITION p20220821 VALUES [('2022-08-21 00:00:00'), ('2022-08-22 00:00:00')),
PARTITION p20220822 VALUES [('2022-08-22 00:00:00'), ('2022-08-23 00:00:00')),
PARTITION p20220823 VALUES [('2022-08-23 00:00:00'), ('2022-08-24 00:00:00')),
PARTITION p20220824 VALUES [('2022-08-24 00:00:00'), ('2022-08-25 00:00:00')),
PARTITION p20220825 VALUES [('2022-08-25 00:00:00'), ('2022-08-26 00:00:00')),
PARTITION p20220826 VALUES [('2022-08-26 00:00:00'), ('2022-08-27 00:00:00')),
PARTITION p20220827 VALUES [('2022-08-27 00:00:00'), ('2022-08-28 00:00:00')),
PARTITION p20220828 VALUES [('2022-08-28 00:00:00'), ('2022-08-29 00:00:00')),
PARTITION p20220829 VALUES [('2022-08-29 00:00:00'), ('2022-08-30 00:00:00')),
PARTITION p20220830 VALUES [('2022-08-30 00:00:00'), ('2022-08-31 00:00:00')),
PARTITION p20220831 VALUES [('2022-08-31 00:00:00'), ('2022-09-01 00:00:00')),
PARTITION p20220901 VALUES [('2022-09-01 00:00:00'), ('2022-09-02 00:00:00')),
PARTITION p20220902 VALUES [('2022-09-02 00:00:00'), ('2022-09-03 00:00:00')),
PARTITION p20220903 VALUES [('2022-09-03 00:00:00'), ('2022-09-04 00:00:00')),
PARTITION p20220904 VALUES [('2022-09-04 00:00:00'), ('2022-09-05 00:00:00')),
PARTITION p20220905 VALUES [('2022-09-05 00:00:00'), ('2022-09-06 00:00:00')),
PARTITION p20220906 VALUES [('2022-09-06 00:00:00'), ('2022-09-07 00:00:00')),
PARTITION p20220907 VALUES [('2022-09-07 00:00:00'), ('2022-09-08 00:00:00')),
PARTITION p20220908 VALUES [('2022-09-08 00:00:00'), ('2022-09-09 00:00:00')),
PARTITION p20220909 VALUES [('2022-09-09 00:00:00'), ('2022-09-10 00:00:00')),
PARTITION p20220910 VALUES [('2022-09-10 00:00:00'), ('2022-09-11 00:00:00')),
PARTITION p20220911 VALUES [('2022-09-11 00:00:00'), ('2022-09-12 00:00:00')),
PARTITION p20220912 VALUES [('2022-09-12 00:00:00'), ('2022-09-13 00:00:00')),
PARTITION p20220913 VALUES [('2022-09-13 00:00:00'), ('2022-09-14 00:00:00')),
PARTITION p20220914 VALUES [('2022-09-14 00:00:00'), ('2022-09-15 00:00:00')),
PARTITION p20220915 VALUES [('2022-09-15 00:00:00'), ('2022-09-16 00:00:00')),
PARTITION p20220916 VALUES [('2022-09-16 00:00:00'), ('2022-09-17 00:00:00')),
PARTITION p20220917 VALUES [('2022-09-17 00:00:00'), ('2022-09-18 00:00:00')),
PARTITION p20220918 VALUES [('2022-09-18 00:00:00'), ('2022-09-19 00:00:00')),
PARTITION p20220919 VALUES [('2022-09-19 00:00:00'), ('2022-09-20 00:00:00')),
PARTITION p20220920 VALUES [('2022-09-20 00:00:00'), ('2022-09-21 00:00:00')),
PARTITION p20220921 VALUES [('2022-09-21 00:00:00'), ('2022-09-22 00:00:00')),
PARTITION p20220922 VALUES [('2022-09-22 00:00:00'), ('2022-09-23 00:00:00')),
PARTITION p20220923 VALUES [('2022-09-23 00:00:00'), ('2022-09-24 00:00:00')),
PARTITION p20220924 VALUES [('2022-09-24 00:00:00'), ('2022-09-25 00:00:00')),
PARTITION p20220925 VALUES [('2022-09-25 00:00:00'), ('2022-09-26 00:00:00')),
PARTITION p20220926 VALUES [('2022-09-26 00:00:00'), ('2022-09-27 00:00:00')),
PARTITION p20220927 VALUES [('2022-09-27 00:00:00'), ('2022-09-28 00:00:00')),
PARTITION p20220928 VALUES [('2022-09-28 00:00:00'), ('2022-09-29 00:00:00')),
PARTITION p20220929 VALUES [('2022-09-29 00:00:00'), ('2022-09-30 00:00:00')),
PARTITION p20220930 VALUES [('2022-09-30 00:00:00'), ('2022-10-01 00:00:00')),
PARTITION p20221001 VALUES [('2022-10-01 00:00:00'), ('2022-10-02 00:00:00')),
PARTITION p20221002 VALUES [('2022-10-02 00:00:00'), ('2022-10-03 00:00:00')),
PARTITION p20221003 VALUES [('2022-10-03 00:00:00'), ('2022-10-04 00:00:00')),
PARTITION p20221004 VALUES [('2022-10-04 00:00:00'), ('2022-10-05 00:00:00')),
PARTITION p20221005 VALUES [('2022-10-05 00:00:00'), ('2022-10-06 00:00:00')),
PARTITION p20221006 VALUES [('2022-10-06 00:00:00'), ('2022-10-07 00:00:00')),
PARTITION p20221007 VALUES [('2022-10-07 00:00:00'), ('2022-10-08 00:00:00')),
PARTITION p20221008 VALUES [('2022-10-08 00:00:00'), ('2022-10-09 00:00:00')),
PARTITION p20221009 VALUES [('2022-10-09 00:00:00'), ('2022-10-10 00:00:00')),
PARTITION p20221010 VALUES [('2022-10-10 00:00:00'), ('2022-10-11 00:00:00')),
PARTITION p20221011 VALUES [('2022-10-11 00:00:00'), ('2022-10-12 00:00:00')),
PARTITION p20221012 VALUES [('2022-10-12 00:00:00'), ('2022-10-13 00:00:00')),
PARTITION p20221013 VALUES [('2022-10-13 00:00:00'), ('2022-10-14 00:00:00')),
PARTITION p20221014 VALUES [('2022-10-14 00:00:00'), ('2022-10-15 00:00:00')),
PARTITION p20221015 VALUES [('2022-10-15 00:00:00'), ('2022-10-16 00:00:00')),
PARTITION p20221016 VALUES [('2022-10-16 00:00:00'), ('2022-10-17 00:00:00')),
PARTITION p20221017 VALUES [('2022-10-17 00:00:00'), ('2022-10-18 00:00:00')),
PARTITION p20221018 VALUES [('2022-10-18 00:00:00'), ('2022-10-19 00:00:00')),
PARTITION p20221019 VALUES [('2022-10-19 00:00:00'), ('2022-10-20 00:00:00')),
PARTITION p20221020 VALUES [('2022-10-20 00:00:00'), ('2022-10-21 00:00:00')),
PARTITION p20221021 VALUES [('2022-10-21 00:00:00'), ('2022-10-22 00:00:00')),
PARTITION p20221022 VALUES [('2022-10-22 00:00:00'), ('2022-10-23 00:00:00')),
PARTITION p20221023 VALUES [('2022-10-23 00:00:00'), ('2022-10-24 00:00:00')),
PARTITION p20221024 VALUES [('2022-10-24 00:00:00'), ('2022-10-25 00:00:00')),
PARTITION p20221025 VALUES [('2022-10-25 00:00:00'), ('2022-10-26 00:00:00')),
PARTITION p20221026 VALUES [('2022-10-26 00:00:00'), ('2022-10-27 00:00:00')),
PARTITION p20221027 VALUES [('2022-10-27 00:00:00'), ('2022-10-28 00:00:00')),
PARTITION p20221028 VALUES [('2022-10-28 00:00:00'), ('2022-10-29 00:00:00')),
PARTITION p20221029 VALUES [('2022-10-29 00:00:00'), ('2022-10-30 00:00:00')),
PARTITION p20221030 VALUES [('2022-10-30 00:00:00'), ('2022-10-31 00:00:00')),
PARTITION p20221031 VALUES [('2022-10-31 00:00:00'), ('2022-11-01 00:00:00')),
PARTITION p20221101 VALUES [('2022-11-01 00:00:00'), ('2022-11-02 00:00:00')),
PARTITION p20221102 VALUES [('2022-11-02 00:00:00'), ('2022-11-03 00:00:00')),
PARTITION p20221103 VALUES [('2022-11-03 00:00:00'), ('2022-11-04 00:00:00')),
PARTITION p20221104 VALUES [('2022-11-04 00:00:00'), ('2022-11-05 00:00:00')),
PARTITION p20221105 VALUES [('2022-11-05 00:00:00'), ('2022-11-06 00:00:00')),
PARTITION p20221106 VALUES [('2022-11-06 00:00:00'), ('2022-11-07 00:00:00')),
PARTITION p20221107 VALUES [('2022-11-07 00:00:00'), ('2022-11-08 00:00:00')),
PARTITION p20221108 VALUES [('2022-11-08 00:00:00'), ('2022-11-09 00:00:00')),
PARTITION p20221109 VALUES [('2022-11-09 00:00:00'), ('2022-11-10 00:00:00')),
PARTITION p20221110 VALUES [('2022-11-10 00:00:00'), ('2022-11-11 00:00:00')),
PARTITION p20221111 VALUES [('2022-11-11 00:00:00'), ('2022-11-12 00:00:00')),
PARTITION p20221112 VALUES [('2022-11-12 00:00:00'), ('2022-11-13 00:00:00')),
PARTITION p20221113 VALUES [('2022-11-13 00:00:00'), ('2022-11-14 00:00:00')),
PARTITION p20221114 VALUES [('2022-11-14 00:00:00'), ('2022-11-15 00:00:00')),
PARTITION p20221115 VALUES [('2022-11-15 00:00:00'), ('2022-11-16 00:00:00')),
PARTITION p20221116 VALUES [('2022-11-16 00:00:00'), ('2022-11-17 00:00:00')),
PARTITION p20221117 VALUES [('2022-11-17 00:00:00'), ('2022-11-18 00:00:00')),
PARTITION p20221118 VALUES [('2022-11-18 00:00:00'), ('2022-11-19 00:00:00')),
PARTITION p20221119 VALUES [('2022-11-19 00:00:00'), ('2022-11-20 00:00:00')),
PARTITION p20221120 VALUES [('2022-11-20 00:00:00'), ('2022-11-21 00:00:00')),
PARTITION p20221121 VALUES [('2022-11-21 00:00:00'), ('2022-11-22 00:00:00')),
PARTITION p20221122 VALUES [('2022-11-22 00:00:00'), ('2022-11-23 00:00:00')),
PARTITION p20221123 VALUES [('2022-11-23 00:00:00'), ('2022-11-24 00:00:00')),
PARTITION p20221124 VALUES [('2022-11-24 00:00:00'), ('2022-11-25 00:00:00')),
PARTITION p20221125 VALUES [('2022-11-25 00:00:00'), ('2022-11-26 00:00:00')),
PARTITION p20221126 VALUES [('2022-11-26 00:00:00'), ('2022-11-27 00:00:00')),
PARTITION p20221127 VALUES [('2022-11-27 00:00:00'), ('2022-11-28 00:00:00')),
PARTITION p20221128 VALUES [('2022-11-28 00:00:00'), ('2022-11-29 00:00:00')),
PARTITION p20221129 VALUES [('2022-11-29 00:00:00'), ('2022-11-30 00:00:00')),
PARTITION p20221130 VALUES [('2022-11-30 00:00:00'), ('2022-12-01 00:00:00')),
PARTITION p20221201 VALUES [('2022-12-01 00:00:00'), ('2022-12-02 00:00:00')),
PARTITION p20221202 VALUES [('2022-12-02 00:00:00'), ('2022-12-03 00:00:00')),
PARTITION p20221203 VALUES [('2022-12-03 00:00:00'), ('2022-12-04 00:00:00')),
PARTITION p20221204 VALUES [('2022-12-04 00:00:00'), ('2022-12-05 00:00:00')),
PARTITION p20221205 VALUES [('2022-12-05 00:00:00'), ('2022-12-06 00:00:00')),
PARTITION p20221206 VALUES [('2022-12-06 00:00:00'), ('2022-12-07 00:00:00')),
PARTITION p20221207 VALUES [('2022-12-07 00:00:00'), ('2022-12-08 00:00:00')),
PARTITION p20221208 VALUES [('2022-12-08 00:00:00'), ('2022-12-09 00:00:00')),
PARTITION p20221209 VALUES [('2022-12-09 00:00:00'), ('2022-12-10 00:00:00')),
PARTITION p20221210 VALUES [('2022-12-10 00:00:00'), ('2022-12-11 00:00:00')),
PARTITION p20221211 VALUES [('2022-12-11 00:00:00'), ('2022-12-12 00:00:00')),
PARTITION p20221212 VALUES [('2022-12-12 00:00:00'), ('2022-12-13 00:00:00')),
PARTITION p20221213 VALUES [('2022-12-13 00:00:00'), ('2022-12-14 00:00:00')),
PARTITION p20221214 VALUES [('2022-12-14 00:00:00'), ('2022-12-15 00:00:00')),
PARTITION p20221215 VALUES [('2022-12-15 00:00:00'), ('2022-12-16 00:00:00')),
PARTITION p20221216 VALUES [('2022-12-16 00:00:00'), ('2022-12-17 00:00:00')),
PARTITION p20221217 VALUES [('2022-12-17 00:00:00'), ('2022-12-18 00:00:00')),
PARTITION p20221218 VALUES [('2022-12-18 00:00:00'), ('2022-12-19 00:00:00')),
PARTITION p20221219 VALUES [('2022-12-19 00:00:00'), ('2022-12-20 00:00:00')),
PARTITION p20221220 VALUES [('2022-12-20 00:00:00'), ('2022-12-21 00:00:00')),
PARTITION p20221221 VALUES [('2022-12-21 00:00:00'), ('2022-12-22 00:00:00')),
PARTITION p20221222 VALUES [('2022-12-22 00:00:00'), ('2022-12-23 00:00:00')),
PARTITION p20221223 VALUES [('2022-12-23 00:00:00'), ('2022-12-24 00:00:00')),
PARTITION p20221224 VALUES [('2022-12-24 00:00:00'), ('2022-12-25 00:00:00')),
PARTITION p20221225 VALUES [('2022-12-25 00:00:00'), ('2022-12-26 00:00:00')),
PARTITION p20221226 VALUES [('2022-12-26 00:00:00'), ('2022-12-27 00:00:00')),
PARTITION p20221227 VALUES [('2022-12-27 00:00:00'), ('2022-12-28 00:00:00')),
PARTITION p20221228 VALUES [('2022-12-28 00:00:00'), ('2022-12-29 00:00:00')),
PARTITION p20221229 VALUES [('2022-12-29 00:00:00'), ('2022-12-30 00:00:00')),
PARTITION p20221230 VALUES [('2022-12-30 00:00:00'), ('2022-12-31 00:00:00')),
PARTITION p20221231 VALUES [('2022-12-31 00:00:00'), ('2023-01-01 00:00:00')),
PARTITION p20230101 VALUES [('2023-01-01 00:00:00'), ('2023-01-02 00:00:00')),
PARTITION p20230102 VALUES [('2023-01-02 00:00:00'), ('2023-01-03 00:00:00')),
PARTITION p20230103 VALUES [('2023-01-03 00:00:00'), ('2023-01-04 00:00:00')),
PARTITION p20230104 VALUES [('2023-01-04 00:00:00'), ('2023-01-05 00:00:00')),
PARTITION p20230105 VALUES [('2023-01-05 00:00:00'), ('2023-01-06 00:00:00')),
PARTITION p20230106 VALUES [('2023-01-06 00:00:00'), ('2023-01-07 00:00:00')),
PARTITION p20230107 VALUES [('2023-01-07 00:00:00'), ('2023-01-08 00:00:00')),
PARTITION p20230108 VALUES [('2023-01-08 00:00:00'), ('2023-01-09 00:00:00')),
PARTITION p20230109 VALUES [('2023-01-09 00:00:00'), ('2023-01-10 00:00:00')),
PARTITION p20230110 VALUES [('2023-01-10 00:00:00'), ('2023-01-11 00:00:00')),
PARTITION p20230111 VALUES [('2023-01-11 00:00:00'), ('2023-01-12 00:00:00')),
PARTITION p20230112 VALUES [('2023-01-12 00:00:00'), ('2023-01-13 00:00:00')),
PARTITION p20230113 VALUES [('2023-01-13 00:00:00'), ('2023-01-14 00:00:00')),
PARTITION p20230114 VALUES [('2023-01-14 00:00:00'), ('2023-01-15 00:00:00')),
PARTITION p20230115 VALUES [('2023-01-15 00:00:00'), ('2023-01-16 00:00:00')),
PARTITION p20230116 VALUES [('2023-01-16 00:00:00'), ('2023-01-17 00:00:00')),
PARTITION p20230117 VALUES [('2023-01-17 00:00:00'), ('2023-01-18 00:00:00')),
PARTITION p20230118 VALUES [('2023-01-18 00:00:00'), ('2023-01-19 00:00:00')),
PARTITION p20230119 VALUES [('2023-01-19 00:00:00'), ('2023-01-20 00:00:00')),
PARTITION p20230120 VALUES [('2023-01-20 00:00:00'), ('2023-01-21 00:00:00')),
PARTITION p20230121 VALUES [('2023-01-21 00:00:00'), ('2023-01-22 00:00:00')),
PARTITION p20230122 VALUES [('2023-01-22 00:00:00'), ('2023-01-23 00:00:00')),
PARTITION p20230123 VALUES [('2023-01-23 00:00:00'), ('2023-01-24 00:00:00')),
PARTITION p20230124 VALUES [('2023-01-24 00:00:00'), ('2023-01-25 00:00:00')),
PARTITION p20230125 VALUES [('2023-01-25 00:00:00'), ('2023-01-26 00:00:00')),
PARTITION p20230126 VALUES [('2023-01-26 00:00:00'), ('2023-01-27 00:00:00')),
PARTITION p20230127 VALUES [('2023-01-27 00:00:00'), ('2023-01-28 00:00:00')),
PARTITION p20230128 VALUES [('2023-01-28 00:00:00'), ('2023-01-29 00:00:00')),
PARTITION p20230129 VALUES [('2023-01-29 00:00:00'), ('2023-01-30 00:00:00')),
PARTITION p20230130 VALUES [('2023-01-30 00:00:00'), ('2023-01-31 00:00:00')),
PARTITION p20230131 VALUES [('2023-01-31 00:00:00'), ('2023-02-01 00:00:00')),
PARTITION p20230201 VALUES [('2023-02-01 00:00:00'), ('2023-02-02 00:00:00')),
PARTITION p20230202 VALUES [('2023-02-02 00:00:00'), ('2023-02-03 00:00:00')),
PARTITION p20230203 VALUES [('2023-02-03 00:00:00'), ('2023-02-04 00:00:00')),
PARTITION p20230204 VALUES [('2023-02-04 00:00:00'), ('2023-02-05 00:00:00')),
PARTITION p20230205 VALUES [('2023-02-05 00:00:00'), ('2023-02-06 00:00:00')),
PARTITION p20230206 VALUES [('2023-02-06 00:00:00'), ('2023-02-07 00:00:00')),
PARTITION p20230207 VALUES [('2023-02-07 00:00:00'), ('2023-02-08 00:00:00')),
PARTITION p20230208 VALUES [('2023-02-08 00:00:00'), ('2023-02-09 00:00:00')),
PARTITION p20230209 VALUES [('2023-02-09 00:00:00'), ('2023-02-10 00:00:00')),
PARTITION p20230210 VALUES [('2023-02-10 00:00:00'), ('2023-02-11 00:00:00')),
PARTITION p20230211 VALUES [('2023-02-11 00:00:00'), ('2023-02-12 00:00:00')),
PARTITION p20230212 VALUES [('2023-02-12 00:00:00'), ('2023-02-13 00:00:00')),
PARTITION p20230213 VALUES [('2023-02-13 00:00:00'), ('2023-02-14 00:00:00')),
PARTITION p20230214 VALUES [('2023-02-14 00:00:00'), ('2023-02-15 00:00:00')),
PARTITION p20230215 VALUES [('2023-02-15 00:00:00'), ('2023-02-16 00:00:00')),
PARTITION p20230216 VALUES [('2023-02-16 00:00:00'), ('2023-02-17 00:00:00')),
PARTITION p20230217 VALUES [('2023-02-17 00:00:00'), ('2023-02-18 00:00:00')),
PARTITION p20230218 VALUES [('2023-02-18 00:00:00'), ('2023-02-19 00:00:00')),
PARTITION p20230219 VALUES [('2023-02-19 00:00:00'), ('2023-02-20 00:00:00')),
PARTITION p20230220 VALUES [('2023-02-20 00:00:00'), ('2023-02-21 00:00:00')),
PARTITION p20230221 VALUES [('2023-02-21 00:00:00'), ('2023-02-22 00:00:00')),
PARTITION p20230222 VALUES [('2023-02-22 00:00:00'), ('2023-02-23 00:00:00')),
PARTITION p20230223 VALUES [('2023-02-23 00:00:00'), ('2023-02-24 00:00:00')),
PARTITION p20230224 VALUES [('2023-02-24 00:00:00'), ('2023-02-25 00:00:00')),
PARTITION p20230225 VALUES [('2023-02-25 00:00:00'), ('2023-02-26 00:00:00')),
PARTITION p20230226 VALUES [('2023-02-26 00:00:00'), ('2023-02-27 00:00:00')),
PARTITION p20230227 VALUES [('2023-02-27 00:00:00'), ('2023-02-28 00:00:00')),
PARTITION p20230228 VALUES [('2023-02-28 00:00:00'), ('2023-03-01 00:00:00')),
PARTITION p20230301 VALUES [('2023-03-01 00:00:00'), ('2023-03-02 00:00:00')),
PARTITION p20230302 VALUES [('2023-03-02 00:00:00'), ('2023-03-03 00:00:00')),
PARTITION p20230303 VALUES [('2023-03-03 00:00:00'), ('2023-03-04 00:00:00')),
PARTITION p20230304 VALUES [('2023-03-04 00:00:00'), ('2023-03-05 00:00:00')),
PARTITION p20230305 VALUES [('2023-03-05 00:00:00'), ('2023-03-06 00:00:00')),
PARTITION p20230306 VALUES [('2023-03-06 00:00:00'), ('2023-03-07 00:00:00')),
PARTITION p20230307 VALUES [('2023-03-07 00:00:00'), ('2023-03-08 00:00:00')),
PARTITION p20230308 VALUES [('2023-03-08 00:00:00'), ('2023-03-09 00:00:00')),
PARTITION p20230309 VALUES [('2023-03-09 00:00:00'), ('2023-03-10 00:00:00')),
PARTITION p20230310 VALUES [('2023-03-10 00:00:00'), ('2023-03-11 00:00:00')),
PARTITION p20230311 VALUES [('2023-03-11 00:00:00'), ('2023-03-12 00:00:00')),
PARTITION p20230312 VALUES [('2023-03-12 00:00:00'), ('2023-03-13 00:00:00')),
PARTITION p20230313 VALUES [('2023-03-13 00:00:00'), ('2023-03-14 00:00:00')),
PARTITION p20230314 VALUES [('2023-03-14 00:00:00'), ('2023-03-15 00:00:00')),
PARTITION p20230315 VALUES [('2023-03-15 00:00:00'), ('2023-03-16 00:00:00')),
PARTITION p20230316 VALUES [('2023-03-16 00:00:00'), ('2023-03-17 00:00:00')),
PARTITION p20230317 VALUES [('2023-03-17 00:00:00'), ('2023-03-18 00:00:00')),
PARTITION p20230318 VALUES [('2023-03-18 00:00:00'), ('2023-03-19 00:00:00')),
PARTITION p20230319 VALUES [('2023-03-19 00:00:00'), ('2023-03-20 00:00:00')),
PARTITION p20230320 VALUES [('2023-03-20 00:00:00'), ('2023-03-21 00:00:00')),
PARTITION p20230321 VALUES [('2023-03-21 00:00:00'), ('2023-03-22 00:00:00')),
PARTITION p20230322 VALUES [('2023-03-22 00:00:00'), ('2023-03-23 00:00:00')),
PARTITION p20230323 VALUES [('2023-03-23 00:00:00'), ('2023-03-24 00:00:00')),
PARTITION p20230324 VALUES [('2023-03-24 00:00:00'), ('2023-03-25 00:00:00')),
PARTITION p20230325 VALUES [('2023-03-25 00:00:00'), ('2023-03-26 00:00:00')),
PARTITION p20230326 VALUES [('2023-03-26 00:00:00'), ('2023-03-27 00:00:00')),
PARTITION p20230327 VALUES [('2023-03-27 00:00:00'), ('2023-03-28 00:00:00')),
PARTITION p20230328 VALUES [('2023-03-28 00:00:00'), ('2023-03-29 00:00:00')),
PARTITION p20230329 VALUES [('2023-03-29 00:00:00'), ('2023-03-30 00:00:00')),
PARTITION p20230330 VALUES [('2023-03-30 00:00:00'), ('2023-03-31 00:00:00')),
PARTITION p20230331 VALUES [('2023-03-31 00:00:00'), ('2023-04-01 00:00:00')),
PARTITION p20230401 VALUES [('2023-04-01 00:00:00'), ('2023-04-02 00:00:00')),
PARTITION p20230402 VALUES [('2023-04-02 00:00:00'), ('2023-04-03 00:00:00')),
PARTITION p20230403 VALUES [('2023-04-03 00:00:00'), ('2023-04-04 00:00:00')),
PARTITION p20230404 VALUES [('2023-04-04 00:00:00'), ('2023-04-05 00:00:00')),
PARTITION p20230405 VALUES [('2023-04-05 00:00:00'), ('2023-04-06 00:00:00')),
PARTITION p20230406 VALUES [('2023-04-06 00:00:00'), ('2023-04-07 00:00:00')),
PARTITION p20230407 VALUES [('2023-04-07 00:00:00'), ('2023-04-08 00:00:00')),
PARTITION p20230408 VALUES [('2023-04-08 00:00:00'), ('2023-04-09 00:00:00')),
PARTITION p20230409 VALUES [('2023-04-09 00:00:00'), ('2023-04-10 00:00:00')),
PARTITION p20230410 VALUES [('2023-04-10 00:00:00'), ('2023-04-11 00:00:00')),
PARTITION p20230411 VALUES [('2023-04-11 00:00:00'), ('2023-04-12 00:00:00')),
PARTITION p20230412 VALUES [('2023-04-12 00:00:00'), ('2023-04-13 00:00:00')),
PARTITION p20230413 VALUES [('2023-04-13 00:00:00'), ('2023-04-14 00:00:00')),
PARTITION p20230414 VALUES [('2023-04-14 00:00:00'), ('2023-04-15 00:00:00')),
PARTITION p20230415 VALUES [('2023-04-15 00:00:00'), ('2023-04-16 00:00:00')),
PARTITION p20230416 VALUES [('2023-04-16 00:00:00'), ('2023-04-17 00:00:00')),
PARTITION p20230417 VALUES [('2023-04-17 00:00:00'), ('2023-04-18 00:00:00')),
PARTITION p20230418 VALUES [('2023-04-18 00:00:00'), ('2023-04-19 00:00:00')),
PARTITION p20230419 VALUES [('2023-04-19 00:00:00'), ('2023-04-20 00:00:00')),
PARTITION p20230420 VALUES [('2023-04-20 00:00:00'), ('2023-04-21 00:00:00')),
PARTITION p20230421 VALUES [('2023-04-21 00:00:00'), ('2023-04-22 00:00:00')),
PARTITION p20230422 VALUES [('2023-04-22 00:00:00'), ('2023-04-23 00:00:00')),
PARTITION p20230423 VALUES [('2023-04-23 00:00:00'), ('2023-04-24 00:00:00')),
PARTITION p20230424 VALUES [('2023-04-24 00:00:00'), ('2023-04-25 00:00:00')),
PARTITION p20230425 VALUES [('2023-04-25 00:00:00'), ('2023-04-26 00:00:00')),
PARTITION p20230426 VALUES [('2023-04-26 00:00:00'), ('2023-04-27 00:00:00')),
PARTITION p20230427 VALUES [('2023-04-27 00:00:00'), ('2023-04-28 00:00:00')),
PARTITION p20230428 VALUES [('2023-04-28 00:00:00'), ('2023-04-29 00:00:00')),
PARTITION p20230429 VALUES [('2023-04-29 00:00:00'), ('2023-04-30 00:00:00')),
PARTITION p20230430 VALUES [('2023-04-30 00:00:00'), ('2023-05-01 00:00:00')),
PARTITION p20230501 VALUES [('2023-05-01 00:00:00'), ('2023-05-02 00:00:00')),
PARTITION p20230502 VALUES [('2023-05-02 00:00:00'), ('2023-05-03 00:00:00')),
PARTITION p20230503 VALUES [('2023-05-03 00:00:00'), ('2023-05-04 00:00:00')),
PARTITION p20230504 VALUES [('2023-05-04 00:00:00'), ('2023-05-05 00:00:00')),
PARTITION p20230505 VALUES [('2023-05-05 00:00:00'), ('2023-05-06 00:00:00')),
PARTITION p20230506 VALUES [('2023-05-06 00:00:00'), ('2023-05-07 00:00:00')),
PARTITION p20230507 VALUES [('2023-05-07 00:00:00'), ('2023-05-08 00:00:00')),
PARTITION p20230508 VALUES [('2023-05-08 00:00:00'), ('2023-05-09 00:00:00')),
PARTITION p20230509 VALUES [('2023-05-09 00:00:00'), ('2023-05-10 00:00:00')),
PARTITION p20230510 VALUES [('2023-05-10 00:00:00'), ('2023-05-11 00:00:00')),
PARTITION p20230511 VALUES [('2023-05-11 00:00:00'), ('2023-05-12 00:00:00')),
PARTITION p20230512 VALUES [('2023-05-12 00:00:00'), ('2023-05-13 00:00:00')),
PARTITION p20230513 VALUES [('2023-05-13 00:00:00'), ('2023-05-14 00:00:00')),
PARTITION p20230514 VALUES [('2023-05-14 00:00:00'), ('2023-05-15 00:00:00')),
PARTITION p20230515 VALUES [('2023-05-15 00:00:00'), ('2023-05-16 00:00:00')),
PARTITION p20230516 VALUES [('2023-05-16 00:00:00'), ('2023-05-17 00:00:00')),
PARTITION p20230517 VALUES [('2023-05-17 00:00:00'), ('2023-05-18 00:00:00')),
PARTITION p20230518 VALUES [('2023-05-18 00:00:00'), ('2023-05-19 00:00:00')),
PARTITION p20230519 VALUES [('2023-05-19 00:00:00'), ('2023-05-20 00:00:00')),
PARTITION p20230520 VALUES [('2023-05-20 00:00:00'), ('2023-05-21 00:00:00')),
PARTITION p20230521 VALUES [('2023-05-21 00:00:00'), ('2023-05-22 00:00:00')),
PARTITION p20230522 VALUES [('2023-05-22 00:00:00'), ('2023-05-23 00:00:00')),
PARTITION p20230523 VALUES [('2023-05-23 00:00:00'), ('2023-05-24 00:00:00')),
PARTITION p20230524 VALUES [('2023-05-24 00:00:00'), ('2023-05-25 00:00:00')),
PARTITION p20230525 VALUES [('2023-05-25 00:00:00'), ('2023-05-26 00:00:00')),
PARTITION p20230526 VALUES [('2023-05-26 00:00:00'), ('2023-05-27 00:00:00')),
PARTITION p20230527 VALUES [('2023-05-27 00:00:00'), ('2023-05-28 00:00:00')),
PARTITION p20230528 VALUES [('2023-05-28 00:00:00'), ('2023-05-29 00:00:00')),
PARTITION p20230529 VALUES [('2023-05-29 00:00:00'), ('2023-05-30 00:00:00')),
PARTITION p20230530 VALUES [('2023-05-30 00:00:00'), ('2023-05-31 00:00:00')),
PARTITION p20230531 VALUES [('2023-05-31 00:00:00'), ('2023-06-01 00:00:00')),
PARTITION p20230601 VALUES [('2023-06-01 00:00:00'), ('2023-06-02 00:00:00')),
PARTITION p20230602 VALUES [('2023-06-02 00:00:00'), ('2023-06-03 00:00:00')),
PARTITION p20230603 VALUES [('2023-06-03 00:00:00'), ('2023-06-04 00:00:00')),
PARTITION p20230604 VALUES [('2023-06-04 00:00:00'), ('2023-06-05 00:00:00')),
PARTITION p20230605 VALUES [('2023-06-05 00:00:00'), ('2023-06-06 00:00:00')),
PARTITION p20230606 VALUES [('2023-06-06 00:00:00'), ('2023-06-07 00:00:00')),
PARTITION p20230607 VALUES [('2023-06-07 00:00:00'), ('2023-06-08 00:00:00')),
PARTITION p20230608 VALUES [('2023-06-08 00:00:00'), ('2023-06-09 00:00:00')),
PARTITION p20230609 VALUES [('2023-06-09 00:00:00'), ('2023-06-10 00:00:00')),
PARTITION p20230610 VALUES [('2023-06-10 00:00:00'), ('2023-06-11 00:00:00')),
PARTITION p20230611 VALUES [('2023-06-11 00:00:00'), ('2023-06-12 00:00:00')),
PARTITION p20230612 VALUES [('2023-06-12 00:00:00'), ('2023-06-13 00:00:00')),
PARTITION p20230613 VALUES [('2023-06-13 00:00:00'), ('2023-06-14 00:00:00')),
PARTITION p20230614 VALUES [('2023-06-14 00:00:00'), ('2023-06-15 00:00:00')),
PARTITION p20230615 VALUES [('2023-06-15 00:00:00'), ('2023-06-16 00:00:00')),
PARTITION p20230616 VALUES [('2023-06-16 00:00:00'), ('2023-06-17 00:00:00')),
PARTITION p20230617 VALUES [('2023-06-17 00:00:00'), ('2023-06-18 00:00:00')),
PARTITION p20230618 VALUES [('2023-06-18 00:00:00'), ('2023-06-19 00:00:00')),
PARTITION p20230619 VALUES [('2023-06-19 00:00:00'), ('2023-06-20 00:00:00')),
PARTITION p20230620 VALUES [('2023-06-20 00:00:00'), ('2023-06-21 00:00:00')),
PARTITION p20230621 VALUES [('2023-06-21 00:00:00'), ('2023-06-22 00:00:00')),
PARTITION p20230622 VALUES [('2023-06-22 00:00:00'), ('2023-06-23 00:00:00')),
PARTITION p20230623 VALUES [('2023-06-23 00:00:00'), ('2023-06-24 00:00:00')),
PARTITION p20230624 VALUES [('2023-06-24 00:00:00'), ('2023-06-25 00:00:00')),
PARTITION p20230625 VALUES [('2023-06-25 00:00:00'), ('2023-06-26 00:00:00')),
PARTITION p20230626 VALUES [('2023-06-26 00:00:00'), ('2023-06-27 00:00:00')),
PARTITION p20230627 VALUES [('2023-06-27 00:00:00'), ('2023-06-28 00:00:00')),
PARTITION p20230628 VALUES [('2023-06-28 00:00:00'), ('2023-06-29 00:00:00')),
PARTITION p20230629 VALUES [('2023-06-29 00:00:00'), ('2023-06-30 00:00:00')),
PARTITION p20230630 VALUES [('2023-06-30 00:00:00'), ('2023-07-01 00:00:00')),
PARTITION p20230701 VALUES [('2023-07-01 00:00:00'), ('2023-07-02 00:00:00')),
PARTITION p20230702 VALUES [('2023-07-02 00:00:00'), ('2023-07-03 00:00:00')),
PARTITION p20230703 VALUES [('2023-07-03 00:00:00'), ('2023-07-04 00:00:00')),
PARTITION p20230704 VALUES [('2023-07-04 00:00:00'), ('2023-07-05 00:00:00')),
PARTITION p20230705 VALUES [('2023-07-05 00:00:00'), ('2023-07-06 00:00:00')),
PARTITION p20230706 VALUES [('2023-07-06 00:00:00'), ('2023-07-07 00:00:00')),
PARTITION p20230707 VALUES [('2023-07-07 00:00:00'), ('2023-07-08 00:00:00')),
PARTITION p20230708 VALUES [('2023-07-08 00:00:00'), ('2023-07-09 00:00:00')))
DISTRIBUTED BY HASH(WORK_ORDER, SERIAL_NUMBER) BUCKETS 10
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-2147483648",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.replication_allocation" = "tag.location.default: 3",
"dynamic_partition.buckets" = "10",
"dynamic_partition.create_history_partition" = "false",
"dynamic_partition.history_partition_num" = "-1",
"dynamic_partition.hot_partition_num" = "0",
"dynamic_partition.reserved_history_periods" = "NULL",
"dynamic_partition.storage_policy" = "",
"dynamic_partition.storage_medium" = "HDD",
"in_memory" = "false",
"storage_format" = "V2",
"disable_auto_compaction" = "false"
);

Hby118 Jul 5, 2023
Author

INSERT INTO ods_mes_p_sn_keyparts
SELECT

'11' AS WORK_ORDER
,'11' AS SERIAL_NUMBER
,'11' AS STATION_TYPE
,'11' AS IPN
,'11' AS ITEM_IPN
,'11' AS ITEM_SN
,'11' AS ITEM_GROUP
,'11' AS VERSION
,'11' AS STATION_NAME
,'11' AS ITEM_SN_CUSTOMER
,'11' AS UPDATE_EMPNO
,'11' AS UPDATE_TIME
,'11' AS CREATE_TIME
,'11' AS ENABLED
,'11' AS MES_SPEC
,'11' AS GU_ID
,'11' AS MODEL
,'11' AS SITE
,'11' AS PLANT
,'11' AS MFG_TYPE
,'11' AS DATA_SOURCE
,'WF5_0_prd_ods_mes_p_sn_keyparts_x6_fatp_inc' AS LOCAL_CREATE_BY
,'11' AS LOCAL_CREATE_TIME
,'11' AS LOCAL_UPDATE_BY
,'11' AS LOCAL_UPDATE_TIME
,'11' AS LOCAL_REMARK

SET delete_without_partition = true;

DELETE FROM test.test_ods_mes_p_sn_keyparts
WHERE LOCAL_CREATE_BY = 'WF5_0_prd_ods_mes_p_sn_keyparts_x6_fatp_inc';

Hby118 Jul 5, 2023
Author

我自己改了下表名

能复现

yagagagaga Jul 5, 2023

Well, it indeed a bug and it has fixed in next version.

Hby118 Jul 5, 2023
Author

好吧谢谢

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

升级到1.2.4以后,不能delete了(SET delete_without_partition = true) #21524

{{title}}

Replies: 1 comment 5 replies

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

Select a reply

升级到1.2.4以后,不能delete了(SET delete_without_partition = true) #21524

Hby118 Jul 5, 2023

Replies: 1 comment · 5 replies

yagagagaga Jul 5, 2023

Hby118 Jul 5, 2023 Author

Hby118 Jul 5, 2023 Author

Hby118 Jul 5, 2023 Author

yagagagaga Jul 5, 2023

Hby118 Jul 5, 2023 Author

Hby118
Jul 5, 2023

Replies: 1 comment 5 replies

yagagagaga
Jul 5, 2023

Hby118 Jul 5, 2023
Author

Hby118 Jul 5, 2023
Author

Hby118 Jul 5, 2023
Author

Hby118 Jul 5, 2023
Author