Ashutosh Chauhan created HIVE-22697:
---------------------------------------

             Summary: Remove expensive RDBMS queries in lock acquisition logic
                 Key: HIVE-22697
                 URL: https://issues.apache.org/jira/browse/HIVE-22697
             Project: Hive
          Issue Type: Improvement
          Components: Transactions
            Reporter: Gopal Vijayaraghavan


There are queries like
"update NEXT_LOCK_ID set nl_next = 163084841;" which can be entirely skipped
the ACID impl doesn't require globally unique lock ids
because locks are marked as txn.id
In a particular instance we observed this logic taking multiple seconds in mysql



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to