[jira] [Created] (IMPALA-13242) DROP PARTITION can't drop partitions before a partition evolution if the partition transform was changed

[Gabor Kaszab (Jira)]

Gabor Kaszab created IMPALA-13242:
-------------------------------------

             Summary: DROP PARTITION can't drop partitions before a partition 
evolution if the partition transform was changed
                 Key: IMPALA-13242
                 URL: https://issues.apache.org/jira/browse/IMPALA-13242
             Project: IMPALA
          Issue Type: Bug
          Components: Frontend
    Affects Versions: Impala 4.4.0
            Reporter: Gabor Kaszab


Steps to set up the repro table:
{code:java}
create table year_part_tbl (i int, d date) partitioned by spec (year(d)) stored 
as iceberg;

insert into year_part_tbl values (1, "2024-07-17"), (2, "2024-07-16");

alter table year_part_tbl set partition spec (month(d));

insert into year_part_tbl values (3, "2024-07-18");
{code}

After the partition evolution we can't drop the partitions with year()
{code:java}
alter table year_part_tbl drop partition (year(d)=2024);
Query: alter table year_part_tbl drop partition (year(d)=2024)
ERROR: AnalysisException: Can't filter column 'd' with transform type: 'YEAR'
{code}

I guess the issue here is that we compare the filter expression against the 
latest partition spec and there the transform on the column is month() instead 
of year().



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org