kbendick removed a comment on issue #3566: URL: https://github.com/apache/iceberg/issues/3566#issuecomment-971868858
Hi @kaohaonan6666! First, which engine are you using? Iceberg has support for row level deletes as well as row level upserts. It possible to have a delete that's based on a key identifier as well (an equality delete, which you can roughly think of as an expression in a SQL where clause like `pk = 'Value'`. One thing that people often do, for supporting use cases based on primary key, is use Spark SQL for `MERGE INTO`. Such as ```sql MERGE INTO table as T using updates as U In general though, for existing tables, I think you'd need to write a job to delete data by row. However, Iceberg has support for row level deletes as well as row level upserts. It possible to have a delete that's based on a key identifier as well (an equality delete, which you can roughly think of as an expression in a SQL where clause like `pk = 'Value'`. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
