Support Questions
Find answers, ask questions, and share your expertise

cannot kill hive process in hortonworks sandbox

Highlighted

cannot kill hive process in hortonworks sandbox

Explorer

88449-capture.png

Hello,

I am using the guided tutorial on the sandbox, specifically "HDP>Develop with Hadoop>Apache Hive" . I am running a small query but it seems stuck and unable to kill the hive processes. I tried to find the hadoop job_id but it doesn't appear any job running. I tried restarting all services but still shows query is running in Tez view.

Also, the the dashboard, the "supervisor lines" is showing red now. What does that mean ?

Please see screen shots.

88450-capture1.png

Any idea how to fix that ?

Thanks!

2 REPLIES 2
Highlighted

Re: cannot kill hive process in hortonworks sandbox

Hi @A C ,

Depending on the query you're executing, it might not result in an actual job to be running on YARN. It depends of your parameters around "fetch tasks" in Hive.

Regarding supervisors, it's related to the Storm service, it's safe to ignore it.

HTH

Re: cannot kill hive process in hortonworks sandbox

Explorer

Thanks. Any suggestion on how to kill query processes in hive ?