kill hive query where application id was not created
Category : Hive
Sometime when you run hive queries then it does not launch application or get hung due to some resources or any other reason.
Now in this case you have to kill query to resubmit it. So, please use following steps to kill hive query itself.
-
hive> select * from table1; Query ID = mapr_201804547_2ad87f0f5627 Total jobs = 1 Launching Job 1 out of 1
- Use “kill query” command, which is available from HDP 2.6.3:
KILL QUERY <queryid1>
Please feel free to give your feedback.
1 Comment
Vinod M
August 5, 2020 at 2:03 pmIts good command