Created on 12-10-2019 03:45 AM - edited on 12-22-2020 11:09 PM by VidyaSargur
This video contains a step by step process that shows how to connect to Hive running on a secure cluster while using a JDBC Uber driver from MS Windows.
Open the video on YouTube here
Prerequisites:
Kerberos Java Config
property udp_preference_limit = 1
DbVisualizer Setup
-Dsun.security.krb5.debug=true -Djavax.security.auth.useSubjectCredsOnly=false -Djava.security.krb5.conf=c:\windows\krb5.ini
Database Server = ( hostname of node running HiveServer2) Database = change from default to default;principal=hive/_HOST@DOMAIN.CO
Get Kerberos Session Ticket from DbVisualizer java JRE
kinit username
kinit -kt keytab username@DOMAIN.COM
klist
Restart DbVisualizer and test connection to Hive
Created on 03-29-2022 04:04 AM
hello team,
Thanks for this useful demo,
i'm still facing connectivity issue from DbViz to kerberised hdp
i'm using DbVisualiser 12.1.3
error message:
An error occurred while establishing the connection:
Long Message:
Could not open client transport with JDBC Uri: jdbc:hive2://<hiveserver2 host>:10000/default;AuthMech=1;KrbRealm=EXAMPLE.COM;KrbServiceName=hive;KrbHostFQDN=<HOST>;KrbAuthType=2;
: Invalid status 21
Also, could not send response: org.apache.hive.org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset by peer: socket write error
FYI: its working with non kerberised cluster
Thanks
Created on 03-29-2022 07:40 AM - edited 03-29-2022 07:41 AM
@aarif, Thanks for reaching out to us. You will have a better chance of getting responses if you can post your query in the Support Questions section. You can post your query there and provide the link to this article in your post. Experts who are following the components/labels will be able to help you quickly.