Start a new topic

Connecting to Hive jdbc using kerberos principle

[This topic is migrated from our old forums. The original author name has been removed]

What jars do i need add to the driver from the hive client lib to get connection using kerberos priciple. I am able to connect through beeline using the key I have added the following jars to the drivers hive-jdbc.jar hadoop-common.jar I am able to connect to other non secured hadoop cluster with same driver My URL is also correct. I am able to use this URL and login using beeline jdbc:hive2://host:10000/default;principal=hive/host@EXAMPLE.COM;kerberosAuthType=fromSubject But when I run through the dbvisualizer on Mac I am getting the following error. When click connect, the log message says 'connecting' and keep on going. No progress. Here is the debug window message 2016-05-14 18:51:19.415 FINE 292 [pool-4-thread-3 - D.ᅣチ] RootConnection: HiveDriver.connect("jdbc:hive2://host:10000/default;principal=hive/host.com@EXAMPLE.COM;;kerberosAuthType=fromSubject", {user=****************, password=********}) 2016-05-14 18:51:19.454 INFO 292 [pool-4-thread-3 - Q.flush] Debug is true storeKey false useTicketCache true useKeyTab false doNotPrompt false ticketCache is null isInitiator true KeyTab is null refreshKrb5Config is false principal is hdf@EXAMPLE.COM tryFirstPass is false useFirstPass is false storePass is false clearPass is false 2016-05-14 18:51:19.454 INFO 292 [pool-4-thread-3 - Q.flush] Acquire TGT from Cache 2016-05-14 18:51:19.455 INFO 292 [pool-4-thread-3 - Q.flush] >>>KinitOptions cache name is /tmp/krb5cc_213147831 2016-05-14 18:51:19.455 INFO 292 [pool-4-thread-3 - Q.flush] >> Acquire default native Credentials 2016-05-14 18:51:19.455 INFO 292 [pool-4-thread-3 - Q.flush] Using builtin default etypes for default_tkt_enctypes 2016-05-14 18:51:19.455 INFO 292 [pool-4-thread-3 - Q.flush] default etypes for default_tkt_enctypes: 2016-05-14 18:51:19.456 INFO 292 [pool-4-thread-3 - Q.flush] 17 2016-05-14 18:51:19.456 INFO 292 [pool-4-thread-3 - Q.flush] 16 2016-05-14 18:51:19.456 INFO 292 [pool-4-thread-3 - Q.flush] 23 2016-05-14 18:51:19.456 INFO 292 [pool-4-thread-3 - Q.flush] . 2016-05-14 18:51:19.458 INFO 292 [pool-4-thread-3 - Q.flush] >>> Found no TGT's in LSA 2016-05-14 18:51:19.458 INFO 292 [pool-4-thread-3 - Q.flush] Principal is hdf@EXAMPLE.COM 2016-05-14 18:51:19.458 INFO 292 [pool-4-thread-3 - Q.flush] null credentials from Ticket Cache 2016-05-14 18:51:19.458 INFO 292 [pool-4-thread-3 - Q.flush] Kerberos password for hdf@EXAMPLE.COM:
1 Comment

[This reply is migrated from our old forums.]

Re: Connecting to Hive jdbc using kerberos principle
Hi, I believe you need to ask for help in the Hive forums, as this is a driver issue that we have no control over. Best Regards, Hans
Login or Signup to post a comment