Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: BDRM script on Linux fails after TLS is enabled on the HIVE server
Problem Description
1) TLS was enabled on Hive server. 

2) It requires using SSL= true, trust store and truststore password. 
(Note: Trust store password is removed from security reason). 

3) The connection string manually works but when bdrm shell script is run it fails. DMBDEHiveConnector MapReduce Job Failed with exception:
java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:1000/infa_household;principal=
hive/localhost@abc.com;ssl=true;sslTrustStore=/opt/cloudera/security/jks/truststore.jks;trustStorePassword=
password;saslQop=auth-conf: Invalid status 21 
at com.informatica.mdmbde.database.hive.HiveDatabaseAdapterImpl.createConnection(HiveDatabaseAdapterImpl.java:239) 
at com.informatica.
mdmbde.database.hive.HiveDatabaseAdapterImpl.initialize(HiveDatabaseAdapterImpl.java:162) 
at com.informatica.mdmbde.hive.driver.MDMBDEHiveEnabler.initializeHive(MDMBDEHiveEnabler.java:518) 
at com.informatica.mdmbde.hive.driver.MDMBDEHiveEnabler.runJob(MDMBDEHiveEnabler.java:154) at com.informatica.mdmbde.hive.driver.MDMBD
EHiveEnabler.main(MDMBDEHiveEnabler.java:122) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:498) 
at org.apache.hadoop.util.RunJar.run(RunJar.java:221) 
at org.apache.hadoop.util.RunJar.main(RunJar.java:136) Caused by: java.sql.SQLException: 
Could not open client transport with JDBC Uri: jdbc:hive2://localhost:100​0/infa_household;principal=hive/localhost@abc.COM​
Cause
The problem occurs because of a known issue (BDRM-2361) 
Solution
This is a known issue (BDRM-2361) which has been resolved in Master Data Management (MDM) - Relate 360 10.0 HotFix 9. To resolve this issue, upgrade to MDM - Relate 360 10.0 HotFix 9.

Workaround​

 
1) Look for a standalone.jar for hive in your machine (Ex: find / -name *-standalone.jar). Choose the one which is close to hive version 1.1.1
 
For example in cdh513kerb01 you will get /opt/cloudera/parcels/CDH-5.14.4-1.cdh5.14.4.p0.3/jars/hive-jdbc-1.1.0-cdh5.14.4-standalone.jar and in hdp26relate001/usr/hdp/2.6.5.0-292/hive/jdbc/hive-jdbc-1.2.1000.2.6.5.0-292-standalone.jar
 
2) Follow the below steps to execute run_hiveEnabler.sh in CDH when hive is SSL enabled:
 
cp /opt/cloudera/parcels/CDH-5.14.4-1.cdh5.14.4.p0.3/jars/hive-jdbc-1.1.0-cdh5.14.4-standalone.jar /usr/local/mdmbdrm-10.0/bin/
 
cd /usr/local/mdmbdrm-10.0/bin/
 
rm -rf hive-jdbc.jar
 
cp hive-jdbc-1.1.0-cdh5.14.4-standalone.jar hive-jdbc.jar
 
chmod 777 hive-jdbc.jar
More Information
Applies To
Product: Relate 360
Problem Type: Installation
User Type: Developer
Project Phase: Implement
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:7/10/2019 9:41 AMID:573979
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)