[ https://issues.apache.org/jira/browse/HIVE-17340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eugene Koifman updated HIVE-17340: ---------------------------------- Summary: TxnHandler.checkLock() - reduce number of SQL statements (was: TxnHandler.checkLock(Connection dbConn, long extLockId) optimization) > TxnHandler.checkLock() - reduce number of SQL statements > -------------------------------------------------------- > > Key: HIVE-17340 > URL: https://issues.apache.org/jira/browse/HIVE-17340 > Project: Hive > Issue Type: Improvement > Components: Transactions > Reporter: Eugene Koifman > Assignee: Eugene Koifman > > This calls acquire(Connection dbConn, Statement stmt, long extLockId, > LockInfo lockInfo) > for each lock in the same DB transaction - 1 Update stmt per acquire(). > There is no reason all of them cannot be sent in 1 statement if all the locks > are granted > With a lot of partitions this can be a perf issue -- This message was sent by Atlassian JIRA (v6.4.14#64029)