[jira] [Commented] (HIVE-20080) TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more than 1000 partitions
[ https://issues.apache.org/jira/browse/HIVE-20080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16604781#comment-16604781 ] ASF GitHub Bot commented on HIVE-20080: --- Github user rajkrrsingh closed the pull request at: https://github.com/apache/hive/pull/390 > TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more > than 1000 partitions > > > Key: HIVE-20080 > URL: https://issues.apache.org/jira/browse/HIVE-20080 > Project: Hive > Issue Type: Bug > Components: Transactions >Affects Versions: 2.1.0 >Reporter: Rajkumar Singh >Assignee: Rajkumar Singh >Priority: Major > Labels: pull-request-available > Attachments: HIVE-20080.patch > > > with Oracle as Metastore, txnhandler checkLock fail with > "checkLockWithRetry(181398,34773) : ORA-01795: maximum number of expressions > in a list is 1000" if the write table has more than 1000 partitions. > complete stacktrace > {code} > txn.TxnHandler (TxnHandler.java:checkRetryable(2099)) - Non-retryable error > in checkLockWithRetry(181398,34773) : ORA-01795: maximum number of > expressions in a list is 1000 > (SQLState=42000, ErrorCode=1795) > 2018-06-25 15:09:35,999 ERROR [pool-7-thread-197]: > metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(203)) - > MetaException(message:Unable to update transaction database > java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in > a list is 1000 > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) > at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195) > at > oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876) > at > oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) > at > oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498) > at > oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) > at > com.jolbox.bonecp.StatementHandle.executeQuery(StatementHandle.java:464) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.checkLock(TxnHandler.java:2649) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.checkLockWithRetry(TxnHandler.java:1126) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.lock(TxnHandler.java:895) > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.lock(HiveMetaStore.java:6123) > at sun.reflect.GeneratedMethodAccessor90.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147) > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105) > at com.sun.proxy.$Proxy11.lock(Unknown Source) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$lock.getResult(ThriftHiveMetastore.java:12012) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$lock.getResult(ThriftHiveMetastore.java:11996) > at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) > at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) > at > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor$1.run(HadoopThriftAuthBridge.java:551) > at > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor$1.run(HadoopThriftAuthBridge.java:546) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1866) > at > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor.process(HadoopThriftAuthBridge.java:546) > at > org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:748) > ) > a
[jira] [Commented] (HIVE-20080) TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more than 1000 partitions
[ https://issues.apache.org/jira/browse/HIVE-20080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16604986#comment-16604986 ] Hive QA commented on HIVE-20080: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12938523/HIVE-20080.01.branch-2.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 15 failed/errored test(s), 10691 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestAccumuloCliDriver.testCliDriver[accumulo_queries] (batchId=227) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[avro_tableproperty_optimize] (batchId=22) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[explaindenpendencydiffengs] (batchId=38) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[llap_smb] (batchId=142) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[orc_ppd_basic] (batchId=139) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[table_nonprintable] (batchId=140) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[join_acid_non_acid] (batchId=158) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[union_fast_stats] (batchId=153) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_parquet_types] (batchId=155) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[merge_negative_5] (batchId=88) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[explaindenpendencydiffengs] (batchId=115) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorization_input_format_excludes] (batchId=117) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorized_ptf] (batchId=125) org.apache.hadoop.hive.metastore.txn.TestTxnHandler.testLockTableLocksPartition (batchId=245) org.apache.hive.hcatalog.api.TestHCatClient.testTransportFailure (batchId=176) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/13609/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/13609/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-13609/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 15 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12938523 - PreCommit-HIVE-Build > TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more > than 1000 partitions > > > Key: HIVE-20080 > URL: https://issues.apache.org/jira/browse/HIVE-20080 > Project: Hive > Issue Type: Bug > Components: Transactions >Affects Versions: 2.1.0 >Reporter: Rajkumar Singh >Assignee: Rajkumar Singh >Priority: Major > Labels: pull-request-available > Attachments: HIVE-20080.01.branch-2.patch, HIVE-20080.patch > > > with Oracle as Metastore, txnhandler checkLock fail with > "checkLockWithRetry(181398,34773) : ORA-01795: maximum number of expressions > in a list is 1000" if the write table has more than 1000 partitions. > complete stacktrace > {code} > txn.TxnHandler (TxnHandler.java:checkRetryable(2099)) - Non-retryable error > in checkLockWithRetry(181398,34773) : ORA-01795: maximum number of > expressions in a list is 1000 > (SQLState=42000, ErrorCode=1795) > 2018-06-25 15:09:35,999 ERROR [pool-7-thread-197]: > metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(203)) - > MetaException(message:Unable to update transaction database > java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in > a list is 1000 > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) > at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195) > at > oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876) > at > oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) > at > oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498) > at > oracle.
[jira] [Commented] (HIVE-20080) TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more than 1000 partitions
[ https://issues.apache.org/jira/browse/HIVE-20080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16605323#comment-16605323 ] Hive QA commented on HIVE-20080: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12938563/HIVE-20080.02.branch-2.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 15 failed/errored test(s), 10691 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestAccumuloCliDriver.testCliDriver[accumulo_queries] (batchId=227) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[avro_tableproperty_optimize] (batchId=22) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[explaindenpendencydiffengs] (batchId=38) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[llap_smb] (batchId=142) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[orc_ppd_basic] (batchId=139) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[table_nonprintable] (batchId=140) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[join_acid_non_acid] (batchId=158) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[union_fast_stats] (batchId=153) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_if_expr] (batchId=144) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_parquet_types] (batchId=155) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[merge_negative_5] (batchId=88) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[explaindenpendencydiffengs] (batchId=115) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorization_input_format_excludes] (batchId=117) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorized_ptf] (batchId=125) org.apache.hive.hcatalog.api.TestHCatClient.testTransportFailure (batchId=176) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/13617/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/13617/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-13617/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 15 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12938563 - PreCommit-HIVE-Build > TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more > than 1000 partitions > > > Key: HIVE-20080 > URL: https://issues.apache.org/jira/browse/HIVE-20080 > Project: Hive > Issue Type: Bug > Components: Transactions >Affects Versions: 2.1.0 >Reporter: Rajkumar Singh >Assignee: Rajkumar Singh >Priority: Major > Labels: pull-request-available > Attachments: HIVE-20080.01.branch-2.patch, > HIVE-20080.02.branch-2.patch, HIVE-20080.patch > > > with Oracle as Metastore, txnhandler checkLock fail with > "checkLockWithRetry(181398,34773) : ORA-01795: maximum number of expressions > in a list is 1000" if the write table has more than 1000 partitions. > complete stacktrace > {code} > txn.TxnHandler (TxnHandler.java:checkRetryable(2099)) - Non-retryable error > in checkLockWithRetry(181398,34773) : ORA-01795: maximum number of > expressions in a list is 1000 > (SQLState=42000, ErrorCode=1795) > 2018-06-25 15:09:35,999 ERROR [pool-7-thread-197]: > metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(203)) - > MetaException(message:Unable to update transaction database > java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in > a list is 1000 > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) > at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195) > at > oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876) > at > oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) > at > oracle.jdbc.driver.OracleStatement.executeQuery(OracleSta
[jira] [Commented] (HIVE-20080) TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more than 1000 partitions
[ https://issues.apache.org/jira/browse/HIVE-20080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16607403#comment-16607403 ] Ashutosh Chauhan commented on HIVE-20080: - +1 [~Rajkumar Singh] Can you please create a jira for master. Lets use this one for branch-2. > TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more > than 1000 partitions > > > Key: HIVE-20080 > URL: https://issues.apache.org/jira/browse/HIVE-20080 > Project: Hive > Issue Type: Bug > Components: Transactions >Affects Versions: 2.1.0 >Reporter: Rajkumar Singh >Assignee: Rajkumar Singh >Priority: Major > Labels: pull-request-available > Attachments: HIVE-20080.01.branch-2.patch, > HIVE-20080.02.branch-2.patch, HIVE-20080.patch > > > with Oracle as Metastore, txnhandler checkLock fail with > "checkLockWithRetry(181398,34773) : ORA-01795: maximum number of expressions > in a list is 1000" if the write table has more than 1000 partitions. > complete stacktrace > {code} > txn.TxnHandler (TxnHandler.java:checkRetryable(2099)) - Non-retryable error > in checkLockWithRetry(181398,34773) : ORA-01795: maximum number of > expressions in a list is 1000 > (SQLState=42000, ErrorCode=1795) > 2018-06-25 15:09:35,999 ERROR [pool-7-thread-197]: > metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(203)) - > MetaException(message:Unable to update transaction database > java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in > a list is 1000 > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) > at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195) > at > oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876) > at > oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) > at > oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498) > at > oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) > at > com.jolbox.bonecp.StatementHandle.executeQuery(StatementHandle.java:464) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.checkLock(TxnHandler.java:2649) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.checkLockWithRetry(TxnHandler.java:1126) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.lock(TxnHandler.java:895) > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.lock(HiveMetaStore.java:6123) > at sun.reflect.GeneratedMethodAccessor90.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147) > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105) > at com.sun.proxy.$Proxy11.lock(Unknown Source) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$lock.getResult(ThriftHiveMetastore.java:12012) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$lock.getResult(ThriftHiveMetastore.java:11996) > at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) > at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) > at > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor$1.run(HadoopThriftAuthBridge.java:551) > at > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor$1.run(HadoopThriftAuthBridge.java:546) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1866) > at > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor.process(HadoopThriftAuthBridge.java:546) > at > org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java
[jira] [Commented] (HIVE-20080) TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more than 1000 partitions
[ https://issues.apache.org/jira/browse/HIVE-20080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16687602#comment-16687602 ] Daniel Dai commented on HIVE-20080: --- This introduces another issue when partition list is big: HIVE-20921 > TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more > than 1000 partitions > > > Key: HIVE-20080 > URL: https://issues.apache.org/jira/browse/HIVE-20080 > Project: Hive > Issue Type: Bug > Components: Transactions >Affects Versions: 2.1.0 >Reporter: Rajkumar Singh >Assignee: Rajkumar Singh >Priority: Major > Labels: pull-request-available > Fix For: 2.4.0 > > Attachments: HIVE-20080.01.branch-2.patch, > HIVE-20080.02.branch-2.patch, HIVE-20080.patch > > > with Oracle as Metastore, txnhandler checkLock fail with > "checkLockWithRetry(181398,34773) : ORA-01795: maximum number of expressions > in a list is 1000" if the write table has more than 1000 partitions. > complete stacktrace > {code} > txn.TxnHandler (TxnHandler.java:checkRetryable(2099)) - Non-retryable error > in checkLockWithRetry(181398,34773) : ORA-01795: maximum number of > expressions in a list is 1000 > (SQLState=42000, ErrorCode=1795) > 2018-06-25 15:09:35,999 ERROR [pool-7-thread-197]: > metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(203)) - > MetaException(message:Unable to update transaction database > java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in > a list is 1000 > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) > at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195) > at > oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876) > at > oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) > at > oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498) > at > oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) > at > com.jolbox.bonecp.StatementHandle.executeQuery(StatementHandle.java:464) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.checkLock(TxnHandler.java:2649) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.checkLockWithRetry(TxnHandler.java:1126) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.lock(TxnHandler.java:895) > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.lock(HiveMetaStore.java:6123) > at sun.reflect.GeneratedMethodAccessor90.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147) > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105) > at com.sun.proxy.$Proxy11.lock(Unknown Source) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$lock.getResult(ThriftHiveMetastore.java:12012) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$lock.getResult(ThriftHiveMetastore.java:11996) > at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) > at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) > at > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor$1.run(HadoopThriftAuthBridge.java:551) > at > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor$1.run(HadoopThriftAuthBridge.java:546) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1866) > at > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor.process(HadoopThriftAuthBridge.java:546) > at > org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) >
[jira] [Commented] (HIVE-20080) TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more than 1000 partitions
[ https://issues.apache.org/jira/browse/HIVE-20080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16533967#comment-16533967 ] ASF GitHub Bot commented on HIVE-20080: --- GitHub user rajkrrsingh opened a pull request: https://github.com/apache/hive/pull/390 HIVE-20080: TxnHandler checkLock direct sql fail with ORA-01795 , if … check if the dbType is oracle break the query IN clause to include hl_partition in batch of 1000. You can merge this pull request into a Git repository by running: $ git pull https://github.com/rajkrrsingh/hive HIVE-20080 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/hive/pull/390.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #390 commit 097c42a8e54ca48cd634dd5c777021eebab076bb Author: Rajkumar singh Date: 2018-07-05T17:52:30Z HIVE-20080: TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more than 1000 partitions > TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more > than 1000 partitions > > > Key: HIVE-20080 > URL: https://issues.apache.org/jira/browse/HIVE-20080 > Project: Hive > Issue Type: Bug > Components: Hive >Affects Versions: 2.1.0 >Reporter: Rajkumar Singh >Assignee: Rajkumar Singh >Priority: Major > Labels: pull-request-available > > with Oracle as Metastore, txnhandler checkLock fail with > "checkLockWithRetry(181398,34773) : ORA-01795: maximum number of expressions > in a list is 1000" if the write table has more than 1000 partitions. > complete stacktrace > {code} > txn.TxnHandler (TxnHandler.java:checkRetryable(2099)) - Non-retryable error > in checkLockWithRetry(181398,34773) : ORA-01795: maximum number of > expressions in a list is 1000 > (SQLState=42000, ErrorCode=1795) > 2018-06-25 15:09:35,999 ERROR [pool-7-thread-197]: > metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(203)) - > MetaException(message:Unable to update transaction database > java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in > a list is 1000 > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) > at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195) > at > oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876) > at > oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) > at > oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498) > at > oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) > at > com.jolbox.bonecp.StatementHandle.executeQuery(StatementHandle.java:464) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.checkLock(TxnHandler.java:2649) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.checkLockWithRetry(TxnHandler.java:1126) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.lock(TxnHandler.java:895) > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.lock(HiveMetaStore.java:6123) > at sun.reflect.GeneratedMethodAccessor90.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147) > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105) > at com.sun.proxy.$Proxy11.lock(Unknown Source) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$lock.getResult(ThriftHiveMetastore.java:12012) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$lock.getResult(ThriftHiveMetastore.java:11996) > at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) > at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) > at > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor$1.run(HadoopThriftAuthBridge.java:551) > at > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssum
[jira] [Commented] (HIVE-20080) TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more than 1000 partitions
[ https://issues.apache.org/jira/browse/HIVE-20080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16534281#comment-16534281 ] Eugene Koifman commented on HIVE-20080: --- There is TxnUtils.buildQueryWithINClause() built for such issues (and more). It currently works for INT in list. It would make more sense to extend that to handle other types. > TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more > than 1000 partitions > > > Key: HIVE-20080 > URL: https://issues.apache.org/jira/browse/HIVE-20080 > Project: Hive > Issue Type: Bug > Components: Hive >Affects Versions: 2.1.0 >Reporter: Rajkumar Singh >Assignee: Rajkumar Singh >Priority: Major > Labels: pull-request-available > Attachments: HIVE-20080.patch > > > with Oracle as Metastore, txnhandler checkLock fail with > "checkLockWithRetry(181398,34773) : ORA-01795: maximum number of expressions > in a list is 1000" if the write table has more than 1000 partitions. > complete stacktrace > {code} > txn.TxnHandler (TxnHandler.java:checkRetryable(2099)) - Non-retryable error > in checkLockWithRetry(181398,34773) : ORA-01795: maximum number of > expressions in a list is 1000 > (SQLState=42000, ErrorCode=1795) > 2018-06-25 15:09:35,999 ERROR [pool-7-thread-197]: > metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(203)) - > MetaException(message:Unable to update transaction database > java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in > a list is 1000 > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) > at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195) > at > oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876) > at > oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) > at > oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498) > at > oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) > at > com.jolbox.bonecp.StatementHandle.executeQuery(StatementHandle.java:464) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.checkLock(TxnHandler.java:2649) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.checkLockWithRetry(TxnHandler.java:1126) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.lock(TxnHandler.java:895) > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.lock(HiveMetaStore.java:6123) > at sun.reflect.GeneratedMethodAccessor90.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147) > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105) > at com.sun.proxy.$Proxy11.lock(Unknown Source) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$lock.getResult(ThriftHiveMetastore.java:12012) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$lock.getResult(ThriftHiveMetastore.java:11996) > at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) > at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) > at > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor$1.run(HadoopThriftAuthBridge.java:551) > at > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor$1.run(HadoopThriftAuthBridge.java:546) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1866) > at > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor.process(HadoopThriftAuthBridge.java:546) > at > org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe
[jira] [Commented] (HIVE-20080) TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more than 1000 partitions
[ https://issues.apache.org/jira/browse/HIVE-20080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16534513#comment-16534513 ] Hive QA commented on HIVE-20080: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 59s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 42s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 20s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 3s{color} | {color:blue} standalone-metastore in master has 226 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 56s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 0m 49s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 38s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 38s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 21s{color} | {color:red} standalone-metastore: The patch generated 4 new + 534 unchanged - 2 fixed = 538 total (was 536) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 3m 12s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 53s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 12s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 19m 35s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-12418/dev-support/hive-personality.sh | | git revision | master / ef53d69 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-12418/yetus/diff-checkstyle-standalone-metastore.txt | | modules | C: standalone-metastore U: standalone-metastore | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-12418/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more > than 1000 partitions > > > Key: HIVE-20080 > URL: https://issues.apache.org/jira/browse/HIVE-20080 > Project: Hive > Issue Type: Bug > Components: Transactions >Affects Versions: 2.1.0 >Reporter: Rajkumar Singh >Assignee: Rajkumar Singh >Priority: Major > Labels: pull-request-available > Attachments: HIVE-20080.patch > > > with Oracle as Metastore, txnhandler checkLock fail with > "checkLockWithRetry(181398,34773) : ORA-01795: maximum number of expressions > in a list is 1000" if the write table has more than 1000 partitions. > complete stacktrace > {code} > txn.TxnHandler (TxnHandler.java:checkRetryable(2099)) - Non-retryable error > in checkLockWithRetry(181398,34773) : ORA-01795: maximum number of > expressions in a list is 1000 > (SQLState=42000, ErrorCode=1795) > 2018-06-25 15:09:35,999 ERROR [pool-7-thread-197]: > metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(203)) - > MetaException(message:Unable to update transaction database > java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in > a list is 1000 > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) > at o
[jira] [Commented] (HIVE-20080) TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more than 1000 partitions
[ https://issues.apache.org/jira/browse/HIVE-20080?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16534556#comment-16534556 ] Hive QA commented on HIVE-20080: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12930416/HIVE-20080.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 14646 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestBlobstoreCliDriver.testCliDriver[ptf_parquetfile] (batchId=264) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/12418/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/12418/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-12418/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12930416 - PreCommit-HIVE-Build > TxnHandler checkLock direct sql fail with ORA-01795 , if the table has more > than 1000 partitions > > > Key: HIVE-20080 > URL: https://issues.apache.org/jira/browse/HIVE-20080 > Project: Hive > Issue Type: Bug > Components: Transactions >Affects Versions: 2.1.0 >Reporter: Rajkumar Singh >Assignee: Rajkumar Singh >Priority: Major > Labels: pull-request-available > Attachments: HIVE-20080.patch > > > with Oracle as Metastore, txnhandler checkLock fail with > "checkLockWithRetry(181398,34773) : ORA-01795: maximum number of expressions > in a list is 1000" if the write table has more than 1000 partitions. > complete stacktrace > {code} > txn.TxnHandler (TxnHandler.java:checkRetryable(2099)) - Non-retryable error > in checkLockWithRetry(181398,34773) : ORA-01795: maximum number of > expressions in a list is 1000 > (SQLState=42000, ErrorCode=1795) > 2018-06-25 15:09:35,999 ERROR [pool-7-thread-197]: > metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(203)) - > MetaException(message:Unable to update transaction database > java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in > a list is 1000 > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) > at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195) > at > oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:876) > at > oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) > at > oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498) > at > oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) > at > com.jolbox.bonecp.StatementHandle.executeQuery(StatementHandle.java:464) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.checkLock(TxnHandler.java:2649) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.checkLockWithRetry(TxnHandler.java:1126) > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.lock(TxnHandler.java:895) > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.lock(HiveMetaStore.java:6123) > at sun.reflect.GeneratedMethodAccessor90.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147) > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105) > at com.sun.proxy.$Proxy11.lock(Unknown Source) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$lock.getResult(ThriftHiveMetastore.java:12012) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$lock.getResult(ThriftHiveMetastore.java:11996) > at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) > at org.apache.thrift.TBaseProcessor.proc