Iceberg REST Catalog DELETE FROM Support

[c-thiel]

Feature request

Is your feature request related to a problem? Please describe.

I want to delete rows from a Table stored in an Iceberg REST Catalog.

Describe the solution you'd like

Support Delete and document supported / not supported operations.

Additional context

Steps to reproduce:

• Clone the lakekeeper catalog repository and run this docker compose (comes with starrocks): https://github.com/lakekeeper/lakekeeper/tree/main/examples/self-contained
• Open localhost:8888
• Execute the Starrocks Notebook
• Add the following line: connection.execute("DELETE FROM starrocks_namespace.my_table where my_ints = 1")

Error: (1064, "Getting analyzing error. Detail message: Table of iceberg catalog doesn't support [DELETE].")

[Dshadowzh]

Thanks for feedback, delete and merge in Iceberg are not supported now, but we'll support in next few versions.

[mrsergeifrolov]

We are really looking forward to this fix. Please speed up the release if possible.

[armanbest]

We’re facing a similar issue – StarRocks + Iceberg + REST does not support deletion and modification. This feature is highly needed; @Dshadowzh are there any updates on it?

[leoshevt]

We’re encountering the same issue

[popinguy]

Same issue. Looking forward to resolving it

[zwhitten]

I'm also looking to be able to delete and update via jdbc using Iceberg + REST. Does this work with Iceberg + Hive?