Hive Connection to Kerberized cluster

Talend Version          6.3.1

Summary

Whenever you try to establish a connection to Hive using Talend Studio, the connection fails with the following error:

java.sql.SQLException: java.util.concurrent.ExecutionException: java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://XX.XX.XX.XX:10001/default;principal=hive/myhost.xyz.com@REALM.COM: Invalid status 72
Additional Versions  
Product Talend Studio
Component tHiveConnection
Problem Description

The following error is seen in Talend Studio when you try to establish a connection to Hive:

Connection failure. You must change the Database Settings. java.sql.SQLException: java.util.concurrent.ExecutionException: java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://XX.XX.XX.XX:10001/default;principal=hive/myhost.xyz.com@REALM.COM: Invalid status 72
Problem root cause transportMode=http;httpPath=cliservice is not configured.
Solution or Workaround

Make sure to add the following parameters in the Hive connection properties in Talend Studio to resolve this issue.

transportMode=http;httpPath=cliservice

JIRA ticket number  
Version history
Revision #:
4 of 4
Last update:
‎10-05-2017 11:10 AM
Updated by:
 
Contributors