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.
To resolve the issue, please do the following:
1. Close the Developer Client.
2. Edit the developerCore.ini to point to correct Hadoop distribution:
3. Launch the Developer Client and test the Hive connection.
Thank you for reply.
We are using informatica BDM version 10.4 and installed in Linux system.
hadoop version Output:
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
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 the latest version, we need Metadata Access Service for any Hadoop object import. Have you configured an MAS in this domain?
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
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: