a8356555 opened a new issue, #11341:
URL: https://github.com/apache/iceberg/issues/11341
### Apache Iceberg version
1.6.0
### Query engine
Spark
### Please describe the bug 🐞
Description:
I'm encountering an issue when running UPDATE or DELETE queries after
upgrading to Iceberg 1.6.0. These queries were working fine in Iceberg 1.5.2,
but now I get the following error in PySpark:
```
pyspark.errors.exceptions.captured.IllegalArgumentException: Cannot add
fieldId 1 as an identifier field: field does not exist
```
This error occurs whenever I try to execute any update or delete query in my
Iceberg table.
The table was originally created using FlinkSQL. Here is the script I used
to create the table (use flink for the purpose of real-time upserting):
```
CREATE CATALOG glue_catalog WITH (
'type'='iceberg',
'catalog-impl'='org.apache.iceberg.aws.glue.GlueCatalog',
'warehouse'='s3://my-bucket'
);
CREATE DATABASE IF NOT EXISTS glue_catalog.my_db;
CREATE TABLE IF NOT EXISTS glue_catalog.my_db.my_table(
id_b BIGINT,
...,
id_a STRING,
id_c DATE,
PRIMARY KEY (id_b,id_a,id_c) NOT ENFORCED
) PARTITIONED BY (
id_c
) WITH (
'format-version'='2',
'write.metadata.delete-after-commit.enabled'='true',
'write.upsert.enabled'='true',
'write.delete.mode'='merge-on-read',
'write.merge.mode'='merge-on-read',
'write.update.mode'='merge-on-read'
);
```
Query Execution: The issue occurs when running an UPDATE or DELETE query in
PySpark after the upgrade to Iceberg 1.6.0.
Expected Behavior:
The queries should execute successfully as they did in Iceberg 1.5.2.
Environment Details:
previous iceberg-spark-runtime package VERSION:
iceberg-spark-runtime-3.4_2.12:1.5.2 (Works fine)
current iceberg-spark-runtime package VERSION:
iceberg-spark-runtime-3.4_2.12:1.6.0 (Issue)
iceberg-flink-runtime package VERSION: iceberg-flink-runtime-1.16-1.4.1.jar
### Willingness to contribute
- [ ] I can contribute a fix for this bug independently
- [ ] I would be willing to contribute a fix for this bug with guidance from
the Iceberg community
- [ ] I cannot contribute a fix for this bug at this time
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org
For additional commands, e-mail: issues-h...@iceberg.apache.org
