[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
Hans Bergsten
said
over 8 years ago
[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
anonymous