Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Unable to run Hive in command line after successfully install sandbox 2.6.3

Unable to run Hive in command line after successfully install sandbox 2.6.3

New Contributor

I have installed HDP 2.6.3 sandbox. Ambari is working fine. I tried some HiveQL in Ambari, its ok. But while i am trying to open hive in ssh, it stopped. Please see the screen shot. Need help to resolve this issue. hive1.jpg

4 REPLIES 4

Re: Unable to run Hive in command line after successfully install sandbox 2.6.3

Guru

Hi @Marshal Tito

If you are using a modern version of HDP, you may wish to try using the Beeline CLI. Here's an answer that can help get you started: https://community.hortonworks.com/questions/148531/run-hive-queries-in-command-shell-cmd-not-in-amba...

Re: Unable to run Hive in command line after successfully install sandbox 2.6.3

Master Collaborator

Can you look into the Yarn RM UI to see if there is any capacity to launch applications? Perhaps that's what may be blocking your CLI to initialize and offering you the prompt. You can also use beeline CLI as suggested by @Sonu Sahi if your queries don't interact with local resources on client host.

Re: Unable to run Hive in command line after successfully install sandbox 2.6.3

New Contributor

i had the same problem and i resolved by adding the number of session of hive.

or killing some process of yarn

yarn application -list; (to list the process yarn).

regards

Highlighted

Re: Unable to run Hive in command line after successfully install sandbox 2.6.3

New Contributor

Thank you all. Increasing HiveServer2 heap size and Metastore heap size my problem got resolved.

Don't have an account?
Coming from Hortonworks? Activate your account here