Hive Credential for Quick Start Cloudera 5.8

[#1]

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

[#2]

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?

[#3]

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

[#4]

We are using JDBC to connect.

[#5]

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?

[#6]

Also, any errors from HiveSever2 side?

[#7]

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.

[#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.

[#9]

still cannot generate logs. is there any other way?

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

[#10]

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?