question Re: Hive queries in Ambari stay in 'running'-status in Archives of Support Questions (Read Only)

Hive queries in Ambari stay in 'running'-status

michel_meulpold — Fri, 22 Jan 2016 23:52:49 GMT

Hi, I've installed a local HDP 2.3.2 Sandbox using VirtualBox. When I execute any query in Hive via Ambari (currently following Hello World tutorial) it most of the time keeps 'running' without results. Yarn job scheduler does not show any running jobs. I already saw a similar issue on this forum where it was solved by an Ambari restart, but in my case restarting does not solve it. What could be the problem?

Re: Hive queries in Ambari stay in 'running'-status

nsabharwal — Sat, 23 Jan 2016 03:53:18 GMT

@Michel Meulpolder

VM configuration matters a lot. Hope you have enough memory and resources.

Try running the same query using hive cli

su - hdfs

hive

run query from hive cli and see if its working or not.

Re: Hive queries in Ambari stay in 'running'-status

abajwa — Sat, 23 Jan 2016 07:59:56 GMT

It might be due to missing home directories in HDFS. Depending on how you run the queries, you can try running the below:

#needed to run queries from Hive view in Ambari
sudo -u hdfs hdfs dfs -mkdir /user/admin
sudo -u hdfs hdfs dfs -chown admin /user/admin

#needed to run hive from CLI, when logged in as root
sudo -u hdfs hdfs dfs -mkdir /user/root
sudo -u hdfs hdfs dfs -chown root /user/root

#needed to run beeline from CLI
sudo -u hdfs hdfs dfs -mkdir /user/anonymous
sudo -u hdfs hdfs dfs -chown anonymous /user/anonymous

Re: Hive queries in Ambari stay in 'running'-status

michel_meulpold — Sat, 23 Jan 2016 16:14:48 GMT

Thanks Neeraj. I did some more testing with my VM resources and also created another HDP Sandbox on Azure (A5 2 cores 14GB). It seems that the problem is browser-dependent since with all VM instances the problem randomly occurs while using Internet Explorer but not using Firefox. Anyhow, at least for now I can proceed, thanks again.

Re: Hive queries in Ambari stay in 'running'-status

michel_meulpold — Sat, 23 Jan 2016 16:16:24 GMT

Thanks Ali. I checked the directories and the above did not exist, but this does not seem to be the problem. When I use another browser it seems the queries run succesfully (see comment below).

Re: Hive queries in Ambari stay in 'running'-status

nsabharwal — Sat, 23 Jan 2016 19:52:45 GMT

@Michel Meulpolder

I have accepted this as best answer because you were able to proceed by changing the browser. Hope it's ok

Re: Hive queries in Ambari stay in 'running'-status

michel_meulpold — Sat, 23 Jan 2016 20:06:20 GMT

Thanks Neeraj