sink delta update error - merge error

arkiboys 9,706 Reputation points
2022-05-31T18:08:00.193+00:00

I get this error in sink delta where I try to do an update on delta parquet files.
n: at Sink 'sinkUpdate': java.lang.UnsupportedOperationException: Cannot perform MERGE as multiple source rows matched and attempted to update the same\ntarget row in the Delta table. By SQL semantics of merge, when multiple source rows m

Any thoughts please?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,582 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. arkiboys 9,706 Reputation points
    2022-05-31T19:56:49.543+00:00

    solved.
    now the same fields are present in source and target


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.