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

Trouble verifying Hive functionality on Azure HDP Sandbox

I was trying to run a micro benchmark and believe I have a hive connectivity failure. As maria_dev who is now part of the hive, hadoop and hdfs groups, is my user. This is what I see on trying to connect to hive.

[maria_dev@sandbox root]$ hive

Logging initialized using configuration in file:/etc/hive/2.5.0.0-1245/0/hive-log4j.properties

...and it hangs. I get the same issue when executing this as hive user after sudo'ing from root.

If someone can correct me or provide a pointer to validate that maria_dev can execute hive commands, I would appreciate it.

Thanks. - Colin

3 REPLIES 3

Re: Trouble verifying Hive functionality on Azure HDP Sandbox

Mentor

In 2.5 Sandbox, the purpose of the VM is to host a docker container that hosts Sandbox HDP services. You've just logged into host machine, now you need to log into container. http://hortonworks.com/hadoop-tutorial/learning-the-ropes-of-the-hortonworks-sandbox/

Also, please use beeline for Hive, hive shell is deprecated

Re: Trouble verifying Hive functionality on Azure HDP Sandbox

Artem. Thank you for your time, but I was logged into the container with the HDP bundle and completed almost all of the HDP tutorials related to Spark. I don't think you directly answered the question which is why hive I am not able to connect to hive directly. I'm calling a BigBench which makes a call to hive that hangs and thus won't complete. I traced the error down to this lack of connectivity where I stand now. thanks. - Colin

Re: Trouble verifying Hive functionality on Azure HDP Sandbox

Rising Star

@Colin Cunningham can you please have a look in the logs and check if there is anything amiss? Also is this on the basebox (with the default services started)? It might be something to do with available RAM ( unlikely but worth checking out ).

Another thing you can try is using beeline instead of the hive cli:

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_dataintegration/content/beeline-vs-hive-...