Created 12-19-2017 06:52 PM
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
Created 12-21-2017 09:56 PM
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...
Created 12-22-2017 07:19 PM
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.
Created 12-23-2017 07:16 AM
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
Created 12-26-2017 05:03 PM
Thank you all. Increasing HiveServer2 heap size and Metastore heap size my problem got resolved.