Hive Connection to Kerberized cluster

TalendSolutionExpert — Fri, 09 Feb 2024 18:22:49 GMT

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

article Hive Connection to Kerberized cluster in Official Support Articles