Unable to Kill Session in Hive

[#1]

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 ?

[#2 · Accepted solution]

@Suresh Raju

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

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

login into one of the nodes as hive or hdfs users

yarn application -kill <application id>

[#3]

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'

[#4]

@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.

[#5]

@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 ?

[#6]

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

[#7]

@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.

[#8]

@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

[#9]

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

[#10]

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