I have a requirement where I need to run multiple concurrent runs on a particular table, however some merges fail and some merges execute. how can i handle this
I have a requirement where I need to run multiple concurrent runs on a particular table, however some merges fail and some merges execute. how can i handle this. I have tried below option -1 . Partition by primary key : Do merge update on parttion key still getting merge conflict issue.2. retry option : using this option merge conflict issue.
I have a requirement where I need to run multiple concurrent operations on a particular table. However, some merge operations fail while others succeed. How can I handle this?
I have tried the following options:
Partitioning by primary key – I performed merge updates on the partition key, but still encountered merge conflict issues.
Retry option – I used a retry mechanism, but the merge conflicts still persist.
There is option to over-come this issue?
Thanks in advance.
