Kill hive queries without exiting from hive shell

You have two options:

press Ctrl+C and wait till command terminates, it will not exit from hive CLI, press Ctrl+C second time and the session will terminate immediately exiting to the shell
from another shell run
yarn application -kill <Application ID> or mapred job -kill <JOB_ID>

Go with the second option

yarn application -kill <Application ID>. Get the application ID by getting onto another session. This is the only way I think you would be able to kill the current query. I do use via beeline on hortonwork framework.

shell hive hiveql hivecli

First, look for Job ID by:

hadoop job -list

And then kill it by ID:

hadoop job -kill <JOB_ID>

CodeHunter

Kill hive queries without exiting from hive shell

Recent Posts

How can I color dots in a xy scatterplot according to column value?

How to update a claim in ASP.NET Identity?

What does {0} mean when initializing an object?

Accessing members of items in a JSONArray with Java

How to log SQL statements in Spring Boot?

Powershell Get-WebSite name parameter is ignored

How to detect scroll to bottom of html element

Java synchronized method

How to test controllers with CodeIgniter?

Detect Visual Composer

Matplotlib: Specify format of floats for tick labels

Rails join a list of strings with commas and "and" before the last