OCC correct problem

[LiLiu88]

Job1&Job2 do upsert concurrently, and they both have the same primaryKey record (pk1 ...), and this pk1 record does not exists in the table before.

because these two jobs upsert concurrently, so Job1&Job2 do indexlookup and both treat pk1 as insert type.
And Job1 first commit to table, then Job2 commit to table and check file level conflict with Job1's commit, there is no conflict, and also insert pk1 record. Now there are two pk1 record in the table, this is incorrect.

so currently OCC can not handle this multiple concurrent upsert correctly?

[nsivabalan]

yes, this is a known limitation I guess. @n3nash : Can you confirm and add more if any.

[liujinhui1994]

Currently supports different partitions

[nsivabalan]

Closing this as this is a known problem .