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

Issue while test connection in Hive

Re: Issue while test connection in Hive

Super Mentor

@Ankit Saxena

As proxy is setup in your "env" so let ambari also use the same proxy.

Please edit the "/var/lib/ambari-server/ambari-env.sh" and add the "AMBARI_JVM_ARGS" variable to include the proxy information's.

-Dhttp.proxyHost=yourproxy  -Dhttp.proxyPort=8080

.

Then restart ambari server

Re: Issue while test connection in Hive

Hi

After adding variable value also getting the same error message:

AMBARI_PASSHPHRASE="DEV"
export AMBARI_JVM_ARGS=$AMBARI_JVM_ARGS' -Xms512m -Xmx2048m -XX:MaxPermSize=128m -Djava.security.auth.login.config=$ROOT/etc/ambari-server/conf/krb5JAASLogin.conf -Djava.security.krb5.conf=/etc/krb5.conf -Djavax.security.auth.useSubjectCredsOnly=false -Dhttp.proxyHost=ld****.***.***.corp -Dhttp.proxyPort=8080'
export PATH=$PATH:$ROOT/var/lib/ambari-server
export PYTHONPATH=$PYTHONPATH:$ROOT/usr/lib/python2.6/site-packages

Please let me how to proceed further.

Regards,

Ankit

Re: Issue while test connection in Hive

@Jay SenSharma

I am still facing the error can you please help.

Regards

Ankit

Re: Issue while test connection in Hive

Hi

In addition found DB url showing "jdbc:postgresql://ld4561.wdf.sap.corp:5432/hive1"

Is this correct.

Regards
Ankit

Re: Issue while test connection in Hive

Hi

In addition found DB url showing "jdbc:postgresql://ld4561.wdf.sap.corp:5432/hive1"

Is this correct.

Regards
Ankit

Re: Issue while test connection in Hive

@Jay SenSharma

I tried the solution related to proxy. But it didnt work. Can you please help if there can be some other solution.