ad1happy2go commented on issue #9512:
URL: https://github.com/apache/hudi/issues/9512#issuecomment-1694675079

   @Jason-liujc We can't say this feature is not supported as that's how 
optimistic concurrency control is designed to work.
   
   Below from MSFT SQL server block - 
https://learn.microsoft.com/en-us/sql/odbc/reference/develop-app/optimistic-concurrency?view=sql-server-ver16
   
   ```
   Optimistic concurrency derives its name from the optimistic assumption that 
collisions between transactions will rarely occur; a collision is said to have 
occurred when another transaction updates or deletes a row of data between the 
time it is read by the current transaction and the time it is updated or 
deleted. It is the opposite of pessimistic concurrency, or locking, in which 
the application developer believes that such collisions are commonplace.
   In optimistic concurrency, a row is left unlocked until the time comes to 
update or delete it. At that point, the row is reread and checked to see if it 
has been changed since it was last read. If the row has changed, the update or 
delete fails and must be tried again.
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to