- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
How to kill a stalled query in Hive LLAP?
- Labels:
-
Apache Hadoop
-
Apache Hive
Created ‎05-03-2018 05:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is there a way to kill a stalled query that is running under LLAP? In regular Hive, you would kill the YARN container and call it a day. In LLAP, doing so would kill the daemons!
Created ‎08-06-2018 10:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't know if it still relevant for you but as far as i know it is possible to kill llap queries from HDP 2.6.3 and above.
Using the following:
1. Identify the query which needs to be killed
2. Using beeline, connect to LLAP
3. execute the command below in beeline
# kill query "<hive query ID>"
The command would be for example
# kill query "hive_20180104093525_f90a6496-42fc-46bb-8e4a-8edc638b193d"
I haven't tried it myself but it should do the trick.
