question Re: Unable to connect to Hive CLI through putty(ssh) in Archives of Support Questions (Read Only)

Unable to connect to Hive CLI through putty(ssh)

g_rao9704 — Fri, 07 Jul 2017 00:59:00 GMT

Hi Team,

I am using HDP 2.4 on HDinsight 3.6(azure) with HIVE 1.2.1.2.4 , I am unable to connect to hive CLI through putty but i am able to connect the hive view in ambari.

I was getting stuck in below stage

ssh-hadoop:~$ hive

WARNING: Use "yarn jar" to launch YARN applications.

Logging initialized using configuration in file:/etc/hive/2.4.2.0-258/0/hive-log4j.properties

Can you Please help me to get out this issue ASAP

Re: Unable to connect to Hive CLI through putty(ssh)

ssubhas — Fri, 07 Jul 2017 01:44:01 GMT

@rama

Try launching Hive cli as 'hive --hiveconf hive.execution.engine=mr".

Re: Unable to connect to Hive CLI through putty(ssh)

g_rao9704 — Fri, 07 Jul 2017 01:52:58 GMT

Thanks @Sindhu

It was working fine with hive --hiveconf hive.execution.engine=mr".

but why should we use this? instead "hive" which i was using since starting?

Re: Unable to connect to Hive CLI through putty(ssh)

kalaiselvan_moo — Fri, 07 Jul 2017 02:07:48 GMT

Hi,

Check free memory is present in the client node .

if it is a kerberized cluster , Ensure you have a valid ticket.

Still if you have not got clue, Launch the hive cli with debug mode and check the debug logs.

hive -hiveconf hive.log.file=debug_hive.log -hiveconf hive.log.dir=/tmp/hiveCLI -hiveconf hive.root.logger=DEBUG,DRFA

Re: Unable to connect to Hive CLI through putty(ssh)

kalaiselvan_moo — Fri, 07 Jul 2017 11:18:39 GMT

@rama

TEZ Engine first allocates memory in the cluster , then it lauches the hive cli, If you launching hive in TEZ engine, Check if any jobs in accepted state . This is the reason hive is not able to launch TEZ Engine , if you enable the debug the logs , you can able to see where it got stuck.

Re: Unable to connect to Hive CLI through putty(ssh)

nishsank — Sat, 02 May 2020 16:35:16 GMT

@ssubhas This did not work as well. Can you help me out. I am unable to connect to HIVE SERVICE in Putty.