创建表时按月分区不成功

ddl：
CREATE TABLE dwd_resource_operate_detail (
object_id bigint(20) NOT NULL COMMENT “文件id”,
partition_month date NOT NULL COMMENT “精确到月用于分区”,
request_time_stamp bigint(20) NOT NULL COMMENT “请求时间戳”,
sys_key int(3) NOT NULL COMMENT “业务代码（编号）”,
bucket_code int(3) NOT NULL COMMENT “桶的编码”,
object_name varchar(200) NOT NULL COMMENT “文件名称”,
operatie_code int(3) NOT NULL COMMENT “操作类型编码”,
client_ip varchar(64) NULL COMMENT “请求ip”,
province varchar(64) NULL COMMENT “省”,
city varchar(64) NULL COMMENT “城市”,
network_operator varchar(64) NULL COMMENT “网络运营商”,
user_agent varchar(64) NULL COMMENT “用户请求头”,
resp_time bigint(20) NULL COMMENT “响应时间 单位毫秒”,
oss_cost_time bigint(20) NULL COMMENT “oss服务器处理请求时间”,
obj_size bigint(20) NULL COMMENT “文件大小 字节”,
content_length bigint(20) NULL COMMENT “响应头中长度”,
err_code varchar(100) NULL COMMENT “错误编码”,
storage_type int(3) NULL COMMENT “0 standard：标准存储类型= 1,archive：归档存储类型=2 ,infrequent_access=低频访问存储类型”
) ENGINE=OLAP
PRIMARY KEY(object_id, partition_month, request_time_stamp)
COMMENT “OLAP”
PARTITION BY RANGE(partition_month)
(PARTITION p202302 VALUES [(‘202302’), (‘202303’)),
PARTITION p202303 VALUES [(‘202303’), (‘202304’)),
PARTITION p202304 VALUES [(‘202304’), (‘202305’)))
DISTRIBUTED BY HASH(object_id,sys_key) BUCKETS 12
PROPERTIES (
“replication_num” = “2”,
“dynamic_partition.enable” = “true”,
“dynamic_partition.time_unit” = “MONTH”,
“dynamic_partition.time_zone” = “Asia/Shanghai”,
“dynamic_partition.start” = “-2147483648”,
“dynamic_partition.end” = “2”,
“dynamic_partition.prefix” = “p”,
“dynamic_partition.buckets” = “12”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”,
“enable_persistent_index” = “false”
);
报错图片：

创建表报错信息1569×971 93.1 KB

CREATE TABLE dwd_resource_operate_detail (

object_id bigint(20) NOT NULL COMMENT “文件id”,

partition_month date NOT NULL COMMENT “精确到月用于分区”,

request_time_stamp bigint(20) NOT NULL COMMENT “请求时间戳”,

sys_key int(3) NOT NULL COMMENT “业务代码（编号）”,

bucket_code int(3) NOT NULL COMMENT “桶的编码”,

object_name varchar(200) NOT NULL COMMENT “文件名称”,

operatie_code int(3) NOT NULL COMMENT “操作类型编码”,

client_ip varchar(64) NULL COMMENT “请求ip”,

province varchar(64) NULL COMMENT “省”,

city varchar(64) NULL COMMENT “城市”,

network_operator varchar(64) NULL COMMENT “网络运营商”,

user_agent varchar(64) NULL COMMENT “用户请求头”,

resp_time bigint(20) NULL COMMENT “响应时间 单位毫秒”,

oss_cost_time bigint(20) NULL COMMENT “oss服务器处理请求时间”,

obj_size bigint(20) NULL COMMENT “文件大小 字节”,

content_length bigint(20) NULL COMMENT “响应头中长度”,

err_code varchar(100) NULL COMMENT “错误编码”,

storage_type int(3) NULL COMMENT “0 standard：标准存储类型= 1,archive：归档存储类型=2 ,infrequent_access=低频访问存储类型”

) ENGINE=OLAP

PRIMARY KEY(object_id, partition_month, request_time_stamp,sys_key)

PARTITION BY RANGE(partition_month)(

PARTITION p202302 VALUES [(‘2023-02-01’), (‘2023-03-01’)),

PARTITION p202303 VALUES [(‘2023-03-01’), (‘2023-04-01’)),

PARTITION p202304 VALUES [(‘2023-04-01’), (‘2023-05-01’)))

DISTRIBUTED BY HASH(object_id,sys_key) BUCKETS 12

PROPERTIES (

“replication_num” = “2”,

“dynamic_partition.enable” = “true”,

“dynamic_partition.time_unit” = “MONTH”,

“dynamic_partition.time_zone” = “Asia/Shanghai”,

“dynamic_partition.start” = “-2147483648”,

“dynamic_partition.end” = “2”,

“dynamic_partition.prefix” = “p”,

“dynamic_partition.buckets” = “12”,

“in_memory” = “false”,

“storage_format” = “DEFAULT”,

“enable_persistent_index” = “false”

);