Reply
New Contributor
Posts: 6
Registered: ‎02-12-2017

Hive Credential for Quick Start Cloudera 5.8

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

Cloudera Employee
Posts: 624
Registered: ‎03-23-2015

Re: Hive Credential for Quick Start Cloudera 5.8

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?

New Contributor
Posts: 6
Registered: ‎02-12-2017

Re: Hive Credential for Quick Start Cloudera 5.8

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

New Contributor
Posts: 6
Registered: ‎02-12-2017

Re: Hive Credential for Quick Start Cloudera 5.8

We are using JDBC to connect.

Highlighted
Cloudera Employee
Posts: 624
Registered: ‎03-23-2015

Re: Hive Credential for Quick Start Cloudera 5.8

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?

Cloudera Employee
Posts: 624
Registered: ‎03-23-2015

Re: Hive Credential for Quick Start Cloudera 5.8

Also, any errors from HiveSever2 side?

New Contributor
Posts: 6
Registered: ‎02-12-2017

Re: Hive Credential for Quick Start Cloudera 5.8

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.

Cloudera Employee
Posts: 624
Registered: ‎03-23-2015

Re: Hive Credential for Quick Start Cloudera 5.8

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.

New Contributor
Posts: 6
Registered: ‎02-12-2017

Re: Hive Credential for Quick Start Cloudera 5.8

still cannot generate logs. is there any other way?

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

Cloudera Employee
Posts: 624
Registered: ‎03-23-2015

Re: Hive Credential for Quick Start Cloudera 5.8

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?