Kill hive queries without exiting from hive shell

Question

Is there any way we can kill hive query without exiting from hive shell ?. For Example, I wrongly ran the select statement from some table which has million rows of data, i just wanted to stop it, but not exiting from the shell. If I pressed CTRL+Z, its coming out of shell.

leftjoin · Accepted Answer · 2019-03-11T18:45:54.250

7

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>

edited Mar 11 '19 at 18:45

answered Jan 12 '17 at 09:18

leftjoin

36,950
8
57
116

2

`hadoop job -kill ` is deprecated, use `mapred job -kill ` – vim Jan 21 '18 at 12:22

score 1 · Answer 2 · answered Jan 09 '17 at 12:29

1

First, look for Job ID by:

hadoop job -list

And then kill it by ID:

hadoop job -kill <JOB_ID>

answered Jan 09 '17 at 12:29

Hrabosch

1,541
8
12

score 1 · Answer 3 · edited Jan 23 '19 at 17:00

1

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.

edited Jan 23 '19 at 17:00

Robert

5,278
43
65
115

answered Jan 23 '19 at 16:37

ravi

15
3

Kill hive queries without exiting from hive shell

3 Answers3