Iceberg table merge into delete support

1

Currently, Dremio not support merge into with delete

but other engine (spark ) support

https://iceberg.apache.org/docs/latest/spark-writes/#merge-into


WHEN MATCHED AND s.op = 'delete' THEN DELETE
WHEN MATCHED AND t.count IS NULL AND s.op = 'increment' THEN UPDATE SET t.count = 0
WHEN MATCHED AND s.op = 'increment' THEN UPDATE SET t.count = t.count + 1
2

@balaji.ramaswamy I am also interested to know if this functionality is on the roadmap for Dremio.

3

Looks like that is in the feature backlog

In 25.1, “Dremio now supports writes using merge-on-read in Apache Iceberg table properties, which creates positional delete files and optimizes DML operations.”