Describe the bug
Create dynamic partiiton table failed, and getting a lot of invalid format date value message
enable the property "dynamic_partition.create_history_partition" and not set property "dynamic_partition.start"
2021-06-08 12:19:21,255 WARN (doris-mysql-nio-pool-0|147) [DynamicPartitionScheduler.getAddPartitionClause():169] Error in gen addPartitionKeyRange. Error=errCode = 2, detailMessage = date literal [+178951742-12-01] is invalid, db: default_cluster:poc, table: dwd_tf_order2
To Reproduce
create table ddl:
create table poc.dwd_tf_order2 (
pt_date date NULL comment "分区字段" ,
order_id varchar(255) NULL COMMENT "订单ID",
....
) ENGINE = OLAP
UNIQUE KEY(pt_date, order_id)
COMMENT "订单明细表"
PARTITION BY RANGE (pt_date)()
DISTRIBUTED BY HASH(order_id) BUCKETS 6
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"storage_format" = "V2",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "MONTH",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "6",
"dynamic_partition.create_history_partition" = "true");