[
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: [email protected]
For additional commands, e-mail: [email protected]
