question Re: Hive will not start - stuck hanging in Support Questions

Hive will not start - stuck hanging

fabienne_chan — Mon, 19 Aug 2019 10:29:54 GMT

Relatively new to Hive/Hadoop. For the past two days,

I haven't been able to launch Hive and it's been stuck hanging after I try to start it from PuTTy. It hangs on

WARNING: Use "yarn jar" to launch YARN applications.
Logging initialized using configuration in file:/etc/hive/2.4.0.0-169/0/hive-log4j.properties

I've tried killing all Yarn Application tasks but that doesn't work. I've tried restarting my Ambari environment. I've tried debugging at Hive Launch but it just goes on forever. Launching in MapReduce (as opposed to Tez) gets it launched, but it isn't able to perform any operators after that (e.g. create table/ select count(*)). This is what it looks like when I debug at Hive launch (it never ends!):

I'd appreciate if someone could help me out or point me in some direction! Thanks

Re: Hive will not start - stuck hanging

rajkumar_singh — Sun, 09 Oct 2016 03:26:18 GMT

@Fabienwith the ambari dashboard view it looks it's a single node cluster and your nodemanger is down, can you restart it and run the query again.

Re: Hive will not start - stuck hanging

fabienne_chan — Sun, 09 Oct 2016 05:11:48 GMT

Hi Rajkumar, do you mind telling how I can restart the node/nodemanager?

Re: Hive will not start - stuck hanging

rajkumar_singh — Mon, 10 Oct 2016 01:12:54 GMT

@Fabien

in ambari click on hosts (upper pane of the UI) then click on the hostname, it will list you all the services along with the status.. you will find nodemanger here. click on the dropdown by selecting start.. it will start the nodemanager

Re: Hive will not start - stuck hanging

fabienne_chan — Mon, 19 Aug 2019 10:29:40 GMT

@Rajkumar Singh, thanks for the guidance. I can't find the "dropdown by selecting start". I see Nodemanager, but can't find the start option. See below.

Thanks

Re: Hive will not start - stuck hanging

rajkumar_singh — Mon, 10 Oct 2016 05:52:09 GMT

@Fabien

could you please try login with the admin user instead of maria_dev.

Re: Hive will not start - stuck hanging

fabienne_chan — Mon, 10 Oct 2016 05:59:34 GMT

@Rajkumar Singh user/pass: admin/admin doesn't work. I've been using maria_dev the entire time. Is there another way around this?

Re: Hive will not start - stuck hanging

rajkumar_singh — Mon, 10 Oct 2016 06:02:46 GMT

@Fabien

could you please try these steps to login ambari using admin

open a terminal do

ssh root@127.0.0.1 -p 2222

ambari-admin-password-reset // update admin passwd ambari-agent restart

now open ambari ui and login using admin/<passwd you setted>