Databricks support updating multiple target rows with single matching source row in merge query?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-06-2025 06:30 AM
Hi,
I am getting this error in merge statement. DeltaUnsupportedOperationException: Cannot perform Merge as multiple source rows matched and attempted to modify the same target row in the Delta table in possibly conflicting ways.
Does Databricks support updating multiple records with single row coming from source in a merge query (we are getting multiple target rows based on match condition for each single source row)? Basically, source- 1 row, Target- many rows