question Re: Unable to Kill Session in Hive in Archives of Support Questions (Read Only)

Unable to Kill Session in Hive

haisure — Mon, 19 Aug 2019 12:24:36 GMT

have tried to run a select script in Hive, since it took time to fetch result tried modifying the query for limiting the result set. I have tried stopping the query/kill session, but the session remains unresponsive, can you let me know how to kill the session ?

Re: Unable to Kill Session in Hive

nsabharwal — Thu, 24 Dec 2015 20:47:56 GMT

@Suresh Raju

On Amabari Dashboard , click Yarn --> Quick Link --> RM UI

Notice the running jobs and find the application id related to your job

yarn application -kill <application id>

Re: Unable to Kill Session in Hive

haisure — Mon, 19 Aug 2019 12:24:29 GMT

Tried checking for job ID under RM UI, but there is no application ID visible now ? but the Hive history still displaying the query status as 'Running'

Re: Unable to Kill Session in Hive

nsabharwal — Mon, 19 Aug 2019 12:24:15 GMT

@Suresh Raju I was able to reproduce this in my sandbox.

You can click Dashboard or refresh or load Hive view again to get it clear.

Re: Unable to Kill Session in Hive

haisure — Fri, 25 Dec 2015 01:09:06 GMT

@Neeraj Sabharwal, have tried refreshing the hive, completely switching off and re-starting it multiple times. am still getting the same running status (more than 5 hours now), am I missing something in the configuration or installation ?

Re: Unable to Kill Session in Hive

nsabharwal — Fri, 25 Dec 2015 01:11:51 GMT

@Suresh Raju Please paste screen shot or entries from /var/log/ambari-server/ambari-server.log

Re: Unable to Kill Session in Hive

haisure — Mon, 19 Aug 2019 12:24:07 GMT

@Neeraj Sabharwal - attached ambari-server-log.txt. for your reference, let me know if you are expecting any specific keyword or details from the log file? as its very huge i couldn't able to take more screenshots or copy logs.

Re: Unable to Kill Session in Hive

nsabharwal — Fri, 25 Dec 2015 23:34:35 GMT

@Suresh Raju I dont see anything related to Hive view. Are you still seeing the issue? Restart ambari server if you are still seeing the issue and check logs

Re: Unable to Kill Session in Hive

haisure — Wed, 06 Jan 2016 00:14:17 GMT

Thanks @Neeraj Sabharwal , the issue is completely resovled now.!!!

Re: Unable to Kill Session in Hive

nsabharwal — Wed, 06 Jan 2016 00:29:03 GMT

@Suresh Raju Cool. As part of best practive , please accept the best answer.

Re: Unable to Kill Session in Hive

aervits — Wed, 03 Feb 2016 03:26:31 GMT

@Suresh Raju are you still having issues with this? Can you accept best answer or provide your own solution?

Re: Unable to Kill Session in Hive

zssspagobi — Fri, 08 Jul 2016 17:10:05 GMT

I am also facing same issue of queries not stopping executing in ambari

I have restarted my ambari but still naot resolved

Here are my ambar-server.log

Processing file: /var/lib/ambari-server/resources/stacks/HDP/2.4/services/../../../../common-services/AMBARI_METRICS/0.1.0/package/files/service-metrics/YARN.txt Processing file: /var/lib/ambari-server/resources/stacks/HDP/2.4/services/../../../../common-services/AMBARI_METRICS/0.1.0/package/files/service-metrics/AMBARI_METRICS.txt Processing file: /var/lib/ambari-server/resources/stacks/HDP/2.4/services/../../../../common-services/AMBARI_METRICS/0.1.0/package/files/service-metrics/HOST.txt Processing file: /var/lib/ambari-server/resources/stacks/HDP/2.4/services/../../../../common-services/AMBARI_METRICS/0.1.0/package/files/service-metrics/FLUME.txt Processing file: /var/lib/ambari-server/resources/stacks/HDP/2.4/services/../../../../common-services/AMBARI_METRICS/0.1.0/package/files/service-metrics/HDFS.txt Processing file: /var/lib/ambari-server/resources/stacks/HDP/2.4/services/../../../../common-services/AMBARI_METRICS/0.1.0/package/files/service-metrics/KAFKA.txt

Please help me