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 connect to Hive CLI through putty(ssh)

Solved Go to solution
Highlighted

Unable to connect to Hive CLI through putty(ssh)

Rising Star

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

@rama

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

4 REPLIES 4

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

@rama

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

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

Rising Star

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)

New Contributor

@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)

New Contributor

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