Reply
New Contributor
Posts: 2
Registered: ‎04-06-2015

Hive hangs at kill job command.

Hi,

I am using CDH 5.2. I have a single node setup of cloudera. I am trying to retrive a single column from a table in hive database using hive editor in Hue web interface. When I fire the query, the job hangs, and does not proceed to map reduce. 

Please note that, there is no error logged in any of the log files (Node manager log, Resource Manager log or hive log). There are just INFO and warning messages.

I am using hiveserver2 on port 17000.

 

Command I am trying to execute - select emp_id from emp3;

 

Screenshot of the Hue Log -

 

Capture.JPG

 

New Contributor
Posts: 1
Registered: ‎02-24-2016

Re: Hive hangs at kill job command.

I have the same problem. Have you figured it out yet? I really need help.

New Contributor
Posts: 2
Registered: ‎06-02-2016

Re: Hive hangs at kill job command.

Did you ever figure this out?  I am having the exact same problem on a single node cluster.  The query starts to execute, but then hangs at the "Kill Command."  

New Contributor
Posts: 2
Registered: ‎06-02-2016

Re: Hive hangs at kill job command.

I was finally able to get this to work by increasing the yarn.nodemanager.resource.memory-mb value from 1 GB (the default) to 6 GB.  Apparently this is a resource issue, but there are no warnings that I could find that state this clearly.

RSS
New Contributor
Posts: 2
Registered: ‎11-11-2018

Re: Hive hangs at kill job command.

Can you tell where to find and change yarn.nodemanager.resource.memory-mb property? Facing the same issue.

Announcements