search

apache / iceberg

Apache Iceberg
https://iceberg.apache.org/
Apache License 2.0
6.4k stars 2.21k forks source link

Add update-statement support in the Flink engine #9517

Open yimlin opened 9 months ago

yimlin commented 9 months ago

Feature Request / Improvement

As in the spark engine, we can apply update-statement, but we can't do the same thing in the flink engine. So please add update-statement support in the Flink engine

Query engine

Flink

pvary commented 9 months ago

If you are updating based on a table key, then upsert mode can help you: https://iceberg.apache.org/docs/latest/flink-writes/#upsert

INSERT INTO tableName /*+ OPTIONS('upsert-enabled'='true') */
...

Other than that, it is a totally new statement to support, and it would take a while to implement it.

yimlin commented 9 months ago

Thanks very much. as you know, the trino engine also suppport update statement, it's better for iceberg that it has the same behaviors in different engines.

github-actions[bot] commented 2 weeks ago

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.