pvary commented on issue #11573: URL: https://github.com/apache/iceberg/issues/11573#issuecomment-2491203879
> But my use case requires upsert, so in this scenario, using status as the partition key is not suitable, right? The problem is not with the partitioning. The problem is that you added `status` to your PRIMARY KEY. - Original table: ``` CREATE TABLE mysql_cdc_source ( [..] PRIMARY KEY (id) NOT ENFORCED ) WITH ( ``` - New table: ``` CREATE TABLE IF NOT EXISTS glue_catalog.my_db.my_table( [..] PRIMARY KEY (id,status) NOT ENFORCED ) PARTITIONED BY ( ``` -- 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 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