[ 
https://issues.apache.org/jira/browse/HIVE-26244?focusedWorklogId=779352&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-779352
 ]

ASF GitHub Bot logged work on HIVE-26244:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 08/Jun/22 08:27
            Start Date: 08/Jun/22 08:27
    Worklog Time Spent: 10m 
      Work Description: simhadri-g commented on code in PR #3307:
URL: https://github.com/apache/hive/pull/3307#discussion_r892070374


##########
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnHandler.java:
##########
@@ -5283,6 +5284,39 @@ is performed on that db (e.g. show tables, created 
table, etc).
             return response;
           }
         }
+
+        if (isValidTxn(txnId)) {
+          LockType lockType = LockTypeUtil.getLockTypeFromEncoding(lockChar)
+                  .orElseThrow(() -> new MetaException("Unknown lock type: " + 
lockChar));
+
+          if (lockType == LockType.EXCL_WRITE && blockedBy.state == 
LockState.ACQUIRED) {

Review Comment:
   I was able to optimize it by moving this check to a much earlier step, right 
before we call checkLocks. This prevents unnecessary insert into the 
TXN_COMPONENTS table and saves us at least 3 to 4 subsequent queries to the 
metastore.





Issue Time Tracking
-------------------

    Worklog Id:     (was: 779352)
    Time Spent: 3h  (was: 2h 50m)

> Implementing locking for concurrent ctas
> ----------------------------------------
>
>                 Key: HIVE-26244
>                 URL: https://issues.apache.org/jira/browse/HIVE-26244
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Simhadri G
>            Assignee: Simhadri G
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 3h
>  Remaining Estimate: 0h
>




--
This message was sent by Atlassian Jira
(v8.20.7#820007)

Reply via email to