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.

Hive Credential for Quick Start Cloudera 5.8

Hive Credential for Quick Start Cloudera 5.8

New Contributor

Hi All,

 

I have Quick Start Cloudera 5.8 in my environment and i try to connect Hive from Informatica.

But it seems i don't have the credential for Hive. Can you guys help me.

 

Thank You

11 REPLIES 11

Re: Hive Credential for Quick Start Cloudera 5.8

Guru

Hi,


Can you please explain what you mean by "you don't have credential for Hive"? Do you use JDBC or ODBC drivers to connect to Hive? What errors do you see from the Informatica? Can you please provide Driver logs for me to have a look?

Re: Hive Credential for Quick Start Cloudera 5.8

New Contributor

I got below error when testing the connection to HIVE. 

 

Connection information is invalid
Test Connection failed. Test Connection failed. java.lang.NoClassDefFoundError: org/apache/log4j/BasicConfigurator

 

i just want to make sure i have the correct credential, but based from the error, i don't think i have the right one.

 

Thank You

Re: Hive Credential for Quick Start Cloudera 5.8

New Contributor

We are using JDBC to connect.

Re: Hive Credential for Quick Start Cloudera 5.8

Guru

The error does not seem to be anything related to credentials, looks like class was not found issue.

 

Since you are using JDBC, can you add the following to your JDBC connection string:

 

;LogLevel=6;LogPath=/path/to/a/directory

 

and then test the connection again, you will get a TRACE log under directory /path/to/a/directory, please show me the FULL error you get from the TRACE log, including some lines before and after the error.

 

Also please let me know the full connection string that you used.

 

Do you have kerberos enabled in your cluster?

Re: Hive Credential for Quick Start Cloudera 5.8

Guru

Also, any errors from HiveSever2 side?

Re: Hive Credential for Quick Start Cloudera 5.8

New Contributor

Here are the connection string = jdbc:hiveserver2://quickstart.cloudera:10000;LogLevel=6;LogPath=/error_log

 

But, there is no log created.

 

 i dont see any error from HiveServer2.

 

the kerberos is disabled.

Re: Hive Credential for Quick Start Cloudera 5.8

Guru

Please try below connection string instead:

 

 jdbc:hive2://quickstart.cloudera:10000/default;LogLevel=6;LogPath=/error_log

 

Pleaes make sure that /error_log directory is created first.

Re: Hive Credential for Quick Start Cloudera 5.8

New Contributor

still cannot generate logs. is there any other way?

based from the error, what could be possibly go wrong?

Re: Hive Credential for Quick Start Cloudera 5.8

Guru

Do you mean that the new Connection String still fails? What's the error? I would think it will be a different one.

 

Your previous connection string " jdbc:hiveserver2://quickstart.cloudera:10000;" was wrong, it should be "jdbc:hive2://quickstart.cloudera:10000/default"

 

Can you please paste on the new error you are getting?