apache / doris

Apache Doris is an easy-to-use, high performance and unified analytics database.
https://doris.apache.org
Apache License 2.0
12.54k stars 3.24k forks source link

[Bug] Table does not create new partition in new year when using dynamic partition #29382

Open ducthangbui opened 9 months ago

ducthangbui commented 9 months ago

Search before asking

Version

doris-2.0.3-rc06

What's Wrong?

I use dynamic partition with mysql CREATE TABLE source_ucm.raw_account_profile_value( id bigint, t_created_day date, t_action varchar(2), customer_id int, table_attribute_field_id int, value varchar(500), t_process_time varchar(50), ts_ms bigint, t_insert_at datetimev2 DEFAULT current_timestamp ) ENGINE=OLAP DUPLICATE KEY (id, t_created_day, t_action) PARTITION BY RANGE(t_created_day)() DISTRIBUTED BY HASH(id, t_action) BUCKETS AUTO PROPERTIES ( "replication_num" = "2", "dynamic_partition.create_history_partition"= "true", "dynamic_partition.history_partition_num" = "497", "dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "DAY", "dynamic_partition.end" = "3", "dynamic_partition.buckets" = "1", "dynamic_partition.prefix" = "p" );

Today, I receive log error no partition for this tuple when insert new data. I check partition by sql command show partitions from source_ucm.raw_account_profile_value order by PartitionName desc, I see only last year partition

image

What You Expected?

I want to have new patch for this bug

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

Code of Conduct

cambyzju commented 9 months ago

There should be some log in fe.log, show why dynamic partition create failed.