[Bug]: Iceberg mixed partition table, amoro UI display and merged write directory error

[archer2012]

What happened?

This table use month-day mixed partitioning.

amoro UI display and merged write data to directory error(1970-xx-xx)

Affects Versions

0.5.x

What engines are you seeing the problem on?

AMS, Optimizer

How to reproduce

create table t1(id int, create_at timestamp) partition sep month(create_at) stored as iceberg tblpropertises('format'='v2');

insert into t1(1,'2022-01-01 01:00:00');
insert into t1(2,'2022-02-01 01:00:00');
insert into t1(3,'2022-03-01 01:00:00');
 
alter table t1 replace partition day(create_at);

insert into t1(1,'2023-01-01 01:00:00');
insert into t1(2,'2023-02-01 01:00:00');
insert into t1(3,'2023-03-01 01:00:00');

Relevant log output

No response

Anything else

No response

Code of Conduct

• I agree to follow this project's Code of Conduct

[shidayang]

Thank you for reporting this issue. We need to confirm some details, but if I understand correctly, the problem is that after modifying the partition of Iceberg, the partition of the output data file is incorrect after self-optimizing, right?

[zhoujinsong]

It seems that the reason for the issue is that when Iceberg contains files with multiple Partition Specs, Amoro currently uses the current Partition Spec to process all files in both file display and self-optimizing processes, which is incorrect and may cause problems that the issue described.