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]

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

[#3]

Hi

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