Re: [I] When deleting data from Iceberg tables in Spark, the current approach is to delete all data and then rewrite the new data, which is very wasteful in terms of storage space and computation. However, when using the Trino engine to delete data from Iceberg tables, it only marks the data to be deleted with the pos flag. It is hoped that Iceberg's Spark runtime can do the same. [iceberg]

[via GitHub]

c8679724 commented on issue #9891:
URL: https://github.com/apache/iceberg/issues/9891#issuecomment-1987633789

   > > When deleting data from Iceberg tables in Spark
   > 
   > How do you delete the data? could you provide an example for your code?
   
   delete from iceberg.ods.syc_db12005_cf_db_user_wk_account
   where exists (select 1 from iceberg.ods.syc_delete_wk_wk_account d where 
d.accountid=iceberg.ods.syc_db12005_cf_db_user_wk_account.accountid)
   ;


-- 
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