Answer-first summary for fast verification
Answer: Merge operations cannot proceed if multiple source rows match and attempt to modify the same target row in the table.
The correct answer highlights a specific limitation of the MERGE INTO command: it cannot be performed if multiple source rows matched and attempted to modify the same target row in the table. This scenario leads to ambiguity because it's unclear which source row should be used to update or delete the matching target row. To avoid this issue, preprocessing the source table to eliminate multiple matches is necessary. For more details, refer to the [Databricks documentation on error messages](https://docs.databricks.com/error-messages/index.html#delta_multiple_source_row_matching_target_row_in_merge).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is considered a limitation when using the MERGE INTO command in Databricks?
A
Merge operations are not supported in streaming jobs without the use of Watermarking.
B
Merge operations cannot delete records; they only support upsert operations.
C
Merge operations cannot proceed if a single source row matches and attempts to modify multiple target rows in the table.
D
Merge operations cannot proceed if multiple source rows match and attempt to modify the same target row in the table.
E
All the above are considered limitations of the MERGE INTO command.
No comments yet.