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

Reply via email to