You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@iceberg.apache.org by "christianknoepfle (via GitHub)" <gi...@apache.org> on 2025/07/09 10:59:07 UTC
[I] Delete/Update/Merge (Spark Scala)-API instead of SQL? [iceberg]
christianknoepfle opened a new issue, #13500:
URL: https://github.com/apache/iceberg/issues/13500
### Query engine
Spark
### Question
Hi,
in Delta I have an API for Delete/Update/Merge in Spark. So I can write ``mytable.delete(col("foo") === lit(2))`` (using Spark Expressions/Functions) instead of doing it with pure SQL (String) ``DELETE FROM MYTABLE WHERE foo = 2`. Same for update and merge ([here](https://docs.delta.io/latest/delta-update.html#language-scala))
In Iceberg I only find SQL (String) examples and wondering whether there is an API available where I can write my transformations using Spark functions.
The reason: In our app all transformations are based on Spark functions, giving us the benefit of compile time checking for typos, separating transformations easily into smaller functions that we can then weave together etc. Would be great if we can avoid breaking this approach when dealing with Iceberg tables.
Are there plans to offer something like that or am I just missing something here?
Thanks a lot
Christian
--
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-unsubscribe@iceberg.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Delete/Update/Merge (Spark Scala)-API instead of SQL? [iceberg]
Posted by "manuzhang (via GitHub)" <gi...@apache.org>.
manuzhang commented on issue #13500:
URL: https://github.com/apache/iceberg/issues/13500#issuecomment-3056769988
Only MergeInto is supported since Spark 4.0. You can find docs [here](https://iceberg.apache.org/docs/nightly/spark-writes/#merging-data).
--
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-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Delete/Update/Merge (Spark Scala)-API instead of SQL? [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #13500:
URL: https://github.com/apache/iceberg/issues/13500#issuecomment-3764520623
This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.
--
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-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Delete/Update/Merge (Spark Scala)-API instead of SQL? [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #13500:
URL: https://github.com/apache/iceberg/issues/13500#issuecomment-3829831565
This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'
--
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-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Delete/Update/Merge (Spark Scala)-API instead of SQL? [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #13500: Delete/Update/Merge (Spark Scala)-API instead of SQL?
URL: https://github.com/apache/iceberg/issues/13500
--
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-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org