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

["Peter Rozsa (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-13242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Peter Rozsa reassigned IMPALA-13242:
------------------------------------

    Assignee: Peter Rozsa

> 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
>            Assignee: Peter Rozsa
>            Priority: Major
>              Labels: impala-iceberg
>
> 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-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org