[jira] [Created] (HIVE-29816) Iceberg: MERGE INTO with WHEN MATCHED THEN DELETE incorrectly duplicates rows under Copy-On-Write delete mode

[Raghav Aggarwal (Jira)]

Raghav Aggarwal created HIVE-29816:
--------------------------------------

             Summary: Iceberg: MERGE INTO with WHEN MATCHED THEN DELETE 
incorrectly duplicates rows under Copy-On-Write delete mode
                 Key: HIVE-29816
                 URL: https://issues.apache.org/jira/browse/HIVE-29816
             Project: Hive
          Issue Type: Bug
            Reporter: Raghav Aggarwal
            Assignee: Raghav Aggarwal


When executing a MERGE INTO statement with a WHEN MATCHED THEN DELETE clause on 
an Iceberg table configured with *write.delete.mode=copy-on-write* ({*}and 
default write.merge.mode=merge-on-read{*}), the target rows matching the 
condition are incorrectly duplicated instead of being deleted.



Attaching sql to repro and spark vs hive comparison screenshot



--
This message was sent by Atlassian Jira
(v8.20.10#820010)