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.
