[ https://issues.apache.org/jira/browse/HIVE-22888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17037408#comment-17037408 ]
Hive QA commented on HIVE-22888: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12993398/HIVE-22888.1.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/20635/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/20635/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-20635/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Tests exited with: Exception: Patch URL https://issues.apache.org/jira/secure/attachment/12993398/HIVE-22888.1.patch was found in seen patch url's cache and a test was probably run already on it. Aborting... {noformat} This message is automatically generated. ATTACHMENT ID: 12993398 - PreCommit-HIVE-Build > Rewrite checkLock inner select with JOIN operator > ------------------------------------------------- > > Key: HIVE-22888 > URL: https://issues.apache.org/jira/browse/HIVE-22888 > Project: Hive > Issue Type: Improvement > Components: Locking > Reporter: Denys Kuzmenko > Assignee: Denys Kuzmenko > Priority: Major > Attachments: HIVE-22888.1.patch > > > - Created extra (db, tbl, part) index on HIVE_LOCKS table; > - Replaced inner select under checkLocks using multiple IN statements with > JOIN operator; > generated query looks like : > {code} > SELECT LS.* FROM ( > SELECT HL_LOCK_EXT_ID, HL_LOCK_INT_ID, HL_DB, HL_TABLE, HL_PARTITION, > HL_LOCK_STATE, HL_LOCK_TYPE, HL_TXNID FROM HIVE_LOCKS > WHERE HL_LOCK_EXT_ID < 12143) LS > LEFT JOIN ( > SELECT HL_DB, HL_TABLE, HL_PARTITION FROM HIVE_LOCKS WHERE HL_LOCK_EXT_ID > = 12143) LBC > ON LS.HL_DB = LBC.HL_DB AND LS.HL_TABLE = LBC.HL_TABLE AND LS.HL_PARTITION = > LBC.HL_PARTITION > WHERE (LS.HL_TABLE IS NULL OR LBC.HL_DB IS NOT NULL) > AND (LS.HL_PARTITION IS NULL OR LBC.HL_DB IS NOT NULL) > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)