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.
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?
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.
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:
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?
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.
Please try below connection string instead:
Pleaes make sure that /error_log directory is created first.
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?