Aggarwal-Raghav commented on PR #5920: URL: https://github.com/apache/hive/pull/5920#issuecomment-3038346724
Hi @Neer393, thanks for taking care of this. I know its a bad practice to put comment on closed PR but I have a question!! even after the patch, I'm still seeing the folloing error on HMS logs when I ran `drop scheduled query if exists drop4;`. The behaviour should be in sync with `drop database if exists` hence this error shouldn't be there IMO. ``` 2025-07-05 12:50:17,362 ERROR metastore.HMSHandler: Caught exception NoSuchObjectException(message:There is no scheduled query for: drop4@hive) at org.apache.hadoop.hive.metastore.ObjectStore.getScheduledQuery(ObjectStore.java:14573) 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.RawStoreProxy.invoke(RawStoreProxy.java:97) at jdk.proxy2/jdk.proxy2.$Proxy26.getScheduledQuery(Unknown Source) at org.apache.hadoop.hive.metastore.HMSHandler.get_scheduled_query(HMSHandler.java:10968) 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.$Proxy27.get_scheduled_query(Unknown Source) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$get_scheduled_query.getResult(ThriftHiveMetastore.java:27334) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$get_scheduled_query.getResult(ThriftHiveMetastore.java:27313) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:111) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:107) at java.base/java.security.AccessController.doPrivileged(AccessController.java:714) at java.base/javax.security.auth.Subject.doAs(Subject.java:525) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:119) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:250) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) at java.base/java.lang.Thread.run(Thread.java:1583) ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For additional commands, e-mail: gitbox-h...@hive.apache.org