Hive can't work with using keytab

One Star

Hive can't work with using keytab

Hi all,

  I got a issue with Hive connection using kerberos and keytab.I download the hadoop cluster infomations with CM and then config the Hive information, these two configrations are both checked successful. When I drop a tHiveconnection component with using the repository  in a standard job , I run the job but it goes wrong,and the log:


[statistics] connecting to socket on port 3334
[statistics] connected
[WARN ]: org.apache.hadoop.util.Shell - Did not find winutils.exe: HADOOP_HOME and hadoop.home.dir are unset. -see
[WARN ]: org.apache.hadoop.util.NativeCodeLoader - Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
[ERROR]: org.apache.hive.jdbc.HiveConnection - Error opening session
org.apache.thrift.TApplicationException: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=datalake_gluetechnology})
 at org.apache.thrift.TServiceClient.receiveBase(
 at org.apache.hive.service.rpc.thrift.TCLIService$Client.recv_OpenSession(
 at org.apache.hive.service.rpc.thrift.TCLIService$Client.OpenSession(
 at org.apache.hive.jdbc.HiveConnection.openSession(
 at org.apache.hive.jdbc.HiveConnection.<init>(
 at org.apache.hive.jdbc.HiveDriver.connect(
 at java.sql.DriverManager.getConnection(Unknown Source)
 at java.sql.DriverManager.getConnection(Unknown Source)
 at demo.copy_of_test_0_1.Copy_of_test.tHiveConnection_1Process(
 at demo.copy_of_test_0_1.Copy_of_test.runJobInTOS(
 at demo.copy_of_test_0_1.Copy_of_test.main(
[WARN ]: org.apache.hive.jdbc.HiveConnection - Failed to connect to
[ERROR]: org.apache.hive.jdbc.Utils - Unable to read HiveServer2 configs from ZooKeeper
Exception in component tHiveConnection_1 (Copy_of_test)
java.sql.SQLException: Could not open client transport for any of the Server URI's in ZooKeeper: Could not establish connection to 


I searched some messages from websites, it looks like the JDBC mismatchs the client from the server. I checked both of them are hive-jdbc-1.2.0.It is also a issue that I don't know how to uninstall the external modules in the talend.


Re: Hive can't work with using keytab


Can you please clarify in which Talend version/edition you are?  What's hive version you are connecting to? The connection to Hive fails.

Here is a related topic about "Uninstall-an-external-jar".

Let us know if it is OK with you.

Best regards



Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.