dengzhhu653 commented on PR #5929:
URL: https://github.com/apache/hive/pull/5929#issuecomment-3059992046

   > UPDATE TBS
   SET last_updated = NOW()
   WHERE TBL_ID = <tblId> AND last_updated = '<timestamp>'; -- The exact 
timestamp you originally read
   
   As far as I know in mysql this will block others for the same row(the same 
for update), if the 0 row returns, means we have acquired the IX `tblId` row 
lock, why do we need to retry 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: gitbox-unsubscr...@hive.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org

Reply via email to