Hello All,
I am getting below error while creating Hive connection by Informatica 10.X Developer tool.
The connection working with SQL developer (http://192.168.1.9:10000/default).
OS: Linux
Hive Version: Hive 1.1.0-cdh5.13.1
Please advise
Hello,
Issue could be due to the version mismatch b/n client and server. What's the version of Ina BDM being used?
You can check if the Hadoop distribution version defined in the developerCore.ini file under client installation directory and the actual hadoop distribution version is same.
With Regards
Akshay
To resolve the issue, please do the following:
1. Close the Developer Client.
2. Edit the developerCore.ini to point to correct Hadoop distribution:
-DINFA_HADOOP_DIST_DIR=hadoop\cloudera_cdh5u3
3. Launch the Developer Client and test the Hive connection.
Hi Rama,
Can you check if below KB helps?
https://kb.informatica.com/solution/23/Pages/55/380022.aspx
Thanks,
Ninju
Informatica Support
Thank you for reply.
We are using informatica BDM version 10.4 and installed in Linux system.
hadoop version Output:
Hadoop 2.6.0-cdh5.13.1
Subversion http://github.com/cloudera/hadoop -r 0061e3eb8ab164e415630bca11d299a7c2ec74fd
Compiled by jenkins on 2017-11-09T16:34Z
Compiled with protoc 2.5.0
From source with checksum 16d5272b34af2d8a4b4b7ee8f7c4cbe
This command was run using /usr/lib/hadoop/hadoop-common-2.6.0-cdh5.13.1.jar
developerCore.ini file version as below
-vmargs
-Xmx768M
-Xms256M
-Xss512k
-XX:MaxMetaspaceSize=256M
-DINFA_HADOOP_DIST_DIR=hadoop\CDH_5.13
-DINFA_THIRDPARTY_LIB=.
-Dfile.encoding=UTF-8
-Declipse.registry.MultiLanguage=true
-DSSOCredentialRenewalTime=10
-XX:+HeapDumpOnOutOfMemoryError
-DINFA_JDBC_EXTERNAL_JARS=..\externaljdbcjars\*
Still getting same error.
Could you check if there is a version mismatch b/n hiveserver2 and the hive JDBC shipped with the infa product?
With Regards
Akshay
Hi Ramakrishna,
With the latest version, we need Metadata Access Service for any Hadoop object import. Have you configured an MAS in this domain?
Thanks,
Ninju
Hello Ninju,
The MAS service running as below.
And,As atteched in Pic2,we have seen some missing for Hive version 5.13.
Is this a problem?
Pic1:
Pic:2:
As mentioned, version mismatch b/n hiveserver2 (in hadoop environment) and hive JDBC shipped with the BDM product could be the cause.
Since BDM 10.4 has been integrated with CDH 5.13, I suspect newer version of JDBC driver is being used to connect to older version of hiveserver2.
Believe hive 1.1.0 is the version compatible with CDH 5.13. You can check the jar shipped with the BDM product under the installation directory.
Thanks and Regards
Akshay
Hi Ramakrishna,
CDH 5.13 is not supported with DEI 10.4 version. Can you please try with CDH 5.16/6.2/6.3 version? You could check the 10.4 PAM from below link:
https://network.informatica.com/docs/DOC-18443
Thanks,
Ninju
