[jira] [Updated] (HIVE-29602) Schematool failure post HIVE-29452

["Raghav Aggarwal (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-29602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Raghav Aggarwal updated HIVE-29602:
-----------------------------------
    Attachment: after.txt
                before.txt

> 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)