[
https://issues.apache.org/jira/browse/HIVE-29816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Raghav Aggarwal updated HIVE-29816:
-----------------------------------
Attachment: hive.png
spark.png
> 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
> Priority: Major
> Attachments: hive.png, spark.png
>
>
> 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)
