[
https://issues.apache.org/jira/browse/HIVE-29602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18079097#comment-18079097
]
Raghav Aggarwal commented on HIVE-29602:
----------------------------------------
Attached before and after HIVE-29452 schematool run in my setup
> Schematool failure post HIVE-29452
> ----------------------------------
>
> Key: HIVE-29602
> URL: https://issues.apache.org/jira/browse/HIVE-29602
> Project: Hive
> Issue Type: Bug
> Reporter: Raghav Aggarwal
> Priority: Major
> Attachments: after.txt, before.txt
>
>
> Repro:
> First ran and it passed:
> {code:java}
> schematool -dbType mysql -initSchema {code}
> then ran and showing the following command and throwing the error for SYS DB
> {code:java}
> schematool -dbType hive -initSchema -metaDbType mysql {code}
> {code:java}
> 2026-05-07 19:30:38,210 ERROR handler.AbstractRequestHandler: GetTableHandler
> [62346ccb-2be4-4656-a51d-9efb11c0a70d-229]
> Failedjava.util.concurrent.ExecutionException:
> NoSuchObjectException(message:hive._dummy_database._dummy_table table not
> found) at
> org.apache.hive.com.google.common.util.concurrent.AbstractFuture.getDoneValue(AbstractFuture.java:503)
> at
> org.apache.hive.com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:462)
> at
> org.apache.hive.com.google.common.util.concurrent.AbstractFuture$TrustedFuture.get(AbstractFuture.java:79)
> at
> org.apache.hadoop.hive.metastore.handler.AbstractRequestHandler.getRequestStatus(AbstractRequestHandler.java:227)
> at
> org.apache.hadoop.hive.metastore.handler.AbstractRequestHandler.getResult(AbstractRequestHandler.java:284)
> at
> org.apache.hadoop.hive.metastore.handler.GetTableHandler.getTable(GetTableHandler.java:609)
> at
> org.apache.hadoop.hive.metastore.HMSHandler.get_table_req(HMSHandler.java:1431)
> at
> java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
> at java.base/java.lang.reflect.Method.invoke(Method.java:580) at
> org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:91)
> at
> org.apache.hadoop.hive.metastore.AbstractHMSHandlerProxy.invoke(AbstractHMSHandlerProxy.java:82)
> at jdk.proxy2/jdk.proxy2.$Proxy38.get_table_req(Unknown Source) at
> org.apache.hadoop.hive.metastore.client.ThriftHiveMetaStoreClient.getTable(ThriftHiveMetaStoreClient.java:2166)
> at
> org.apache.hadoop.hive.ql.metadata.HiveMetaStoreClientWithLocalCache.getTable(HiveMetaStoreClientWithLocalCache.java:190)
> at
> org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.getTable(SessionHiveMetaStoreClient.java:224)
> at
> org.apache.hadoop.hive.metastore.client.HookEnabledMetaStoreClient.getTable(HookEnabledMetaStoreClient.java:380)
> at
> java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
> at java.base/java.lang.reflect.Method.invoke(Method.java:580) at
> org.apache.hadoop.hive.metastore.client.SynchronizedMetaStoreClient$SynchronizedHandler.invoke(SynchronizedMetaStoreClient.java:69)
> at jdk.proxy2/jdk.proxy2.$Proxy39.getTable(Unknown Source) at
> org.apache.hadoop.hive.metastore.client.MetaStoreClientWrapper.getTable(MetaStoreClientWrapper.java:217)
> at
> java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
> at java.base/java.lang.reflect.Method.invoke(Method.java:580) at
> org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:232)
> at jdk.proxy2/jdk.proxy2.$Proxy39.getTable(Unknown Source) at
> org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1797) at
> org.apache.hadoop.hive.ql.parse.CalcitePlanner.getTableObjectByName(CalcitePlanner.java:5118)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:2385)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:2335)
> at
> org.apache.hadoop.hive.ql.parse.CalcitePlanner.genOPTree(CalcitePlanner.java:640)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:13224)
> at
> org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:481)
> at
> org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:358)
> at org.apache.hadoop.hive.ql.Compiler.analyze(Compiler.java:224) at
> org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:109) at
> org.apache.hadoop.hive.ql.Driver.compile(Driver.java:499) at
> org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:451) at
> org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:415) at
> org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:409) at
> org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126)
> at
> org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:205)
> at
> org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:268)
> at
> org.apache.hive.service.cli.operation.Operation.run(Operation.java:286)
> at
> org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:558)
> at
> org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:543)
> at
> org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:311)
> at
> org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:650)
> at
> java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
> at java.base/java.lang.reflect.Method.invoke(Method.java:580) at
> org.apache.hive.jdbc.HiveConnection$SynchronizedHandler.invoke(HiveConnection.java:2271)
> at jdk.proxy2/jdk.proxy2.$Proxy48.ExecuteStatement(Unknown Source)
> at
> org.apache.hive.jdbc.HiveStatement.runAsyncOnServer(HiveStatement.java:361)
> at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:299) at
> org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:517)
> at
> org.apache.hadoop.hive.metastore.MetaStoreSchemaInfo.getMetaStoreSchemaVersion(MetaStoreSchemaInfo.java:244)
> at
> org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.verifySchemaVersion(MetastoreSchemaTool.java:282)
> at
> org.apache.hadoop.hive.metastore.tools.schematool.SchemaToolTaskInit.execute(SchemaToolTaskInit.java:70)
> at
> org.apache.hadoop.hive.metastore.tools.schematool.MetastoreSchemaTool.run(MetastoreSchemaTool.java:486)
> at
> org.apache.hive.beeline.schematool.HiveSchemaTool.main(HiveSchemaTool.java:206)
> at
> java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
> at java.base/java.lang.reflect.Method.invoke(Method.java:580) at
> org.apache.hadoop.util.RunJar.run(RunJar.java:330) at
> org.apache.hadoop.util.RunJar.main(RunJar.java:245)Caused by:
> NoSuchObjectException(message:hive._dummy_database._dummy_table table not
> found) at
> org.apache.hadoop.hive.metastore.handler.GetTableHandler.getTableCore(GetTableHandler.java:251)
> at
> org.apache.hadoop.hive.metastore.handler.GetTableHandler.getTable(GetTableHandler.java:194)
> at
> org.apache.hadoop.hive.metastore.handler.GetTableHandler.execute(GetTableHandler.java:115)
> at
> org.apache.hadoop.hive.metastore.handler.GetTableHandler.execute(GetTableHandler.java:84)
> at
> org.apache.hadoop.hive.metastore.handler.AbstractRequestHandler.lambda$executeRequest$4(AbstractRequestHandler.java:146)
> at
> org.apache.hive.com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:111)
> at
> org.apache.hive.com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:58)
> at
> org.apache.hive.com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:75)
> at
> org.apache.hive.com.google.common.util.concurrent.MoreExecutors$DirectExecutorService.execute(MoreExecutors.java:260)
> at
> java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:145)
> at
> org.apache.hive.com.google.common.util.concurrent.AbstractListeningExecutorService.submit(AbstractListeningExecutorService.java:66)
> at
> org.apache.hive.com.google.common.util.concurrent.AbstractListeningExecutorService.submit(AbstractListeningExecutorService.java:36)
> at
> org.apache.hadoop.hive.metastore.handler.AbstractRequestHandler.executeRequest(AbstractRequestHandler.java:142)
> at
> org.apache.hadoop.hive.metastore.handler.AbstractRequestHandler.<init>(AbstractRequestHandler.java:130)
> at
> org.apache.hadoop.hive.metastore.handler.GetTableHandler.<init>(GetTableHandler.java:95)
> at
> java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:62)
> at
> java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:502)
> at
> java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:486)
> at
> org.apache.hadoop.hive.metastore.utils.JavaUtils.newInstance(JavaUtils.java:87)
> at
> org.apache.hadoop.hive.metastore.handler.AbstractRequestHandler.lambda$static$1(AbstractRequestHandler.java:88)
> at
> org.apache.hadoop.hive.metastore.handler.AbstractRequestHandler.offer(AbstractRequestHandler.java:202)
> at
> org.apache.hadoop.hive.metastore.handler.GetTableHandler.getTable(GetTableHandler.java:608)
> ... 57 more {code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
