Neer393 commented on PR #5920: URL: https://github.com/apache/hive/pull/5920#issuecomment-3038919648
> @Neer393, that's not what I meant. There is no error on beeline side or any query failure, just that there is NoSuchObjectException ERROR log present in hivemetastore logs. In my opinion, with `if exists` clause, that ERROR log shoudn't be there. Ohh sorry I thought you are facing an issue with CLI I am not able to repro what you are seeing. When I run ```DROP SCHEDULED QUERY IF EXISTS xyz``` , I get no ERROR in HS2 logs I only see a WARN which was added by me as advised by @deniskuzZ ``` 2025-07-05 13:08:56,901 INFO org.apache.hadoop.hive.ql.Driver: [2eaf7f36-5924-4447-96f0-874d53993c7f2eaf7f36-5924-4447-96f0-874d53993c7f HiveServer2-Handler-Pool: Thread-72]: Compiling command(queryId=hive_20250705130856_21f6f8ec-46cf-4019-9c63-baf778d8ac79): drop scheduled query if exists xyz . . . Some more logs . 2025-07-05 13:08:57,953 INFO org.apache.hadoop.hive.ql.parse.ScheduledQueryAnalyzer: [2eaf7f36-5924-4447-96f0-874d53993c7f2eaf7f36-5924-4447-96f0-874d53993c7f HiveServer2-Handler-Pool: Thread-72]: scheduled query namespace:hive 2025-07-05 13:08:57,968 WARN org.apache.hadoop.hive.ql.parse.ScheduledQueryAnalyzer: [2eaf7f36-5924-4447-96f0-874d53993c7f2eaf7f36-5924-4447-96f0-874d53993c7f HiveServer2-Handler-Pool: Thread-72]: Unable to find Scheduled query xyz 2025-07-05 13:08:57,969 INFO org.apache.hadoop.hive.ql.Driver: [2eaf7f36-5924-4447-96f0-874d53993c7f2eaf7f36-5924-4447-96f0-874d53993c7f HiveServer2-Handler-Pool: Thread-72]: Semantic Analysis Completed (retrial = false) ``` Why does it show stack trace in your case I don't know @Aggarwal-Raghav can you verify once again ? -- 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
