Cloudera Community
majeedk
user rank
New Contributor

Re: Kerberos authentication with hive JDBC driver

by New Contributor in Support Questions
‎01-26-2017 07:44 AM
‎01-26-2017 07:44 AM
 @saranvisa   The entire error message I see in Oracle SQL Developer is   An error was encountered performing the requested operation: [Cloudera][HiveJDBCDriver](500164) Error initialized or created transport for authentication: [Cloudera][HiveJDBCDriver](500169) Unable to connect to server: GSS initiate failed. Vendor code 500164   Does it mean it is not kerberos error message?   PS: Does having Hadoop cluster (Linux) on different domain than my client machine (Windows) have any bearing on connection? ... View more

Re: Kerberos authentication with hive JDBC driver

by New Contributor in Support Questions
‎01-26-2017 04:28 AM
‎01-26-2017 04:28 AM
Hi @saranvisa I have tried your suggestion but I am still getting error while trying to connect to Hive.   I copied the keytab file from hadoop cluster to my windows machine  (ktfile.keytab) I ran the following command from dir where I copied the keytab file    kinit -k -t ktfile.keytab USER@dev.mycompany.com   The above commands get a valid ticket and I can view thsi using MIT Kerberos app. After this If I try to connect to Hive database from SQL Developer I get following error.  Status : Failure -Test failed: [Cloudera][HiveJDBCDriver](500164) Error initialized or created transport for authentication: [Cloudera][HiveJDBCDriver](500169) Unable to connect to server: GSS initiate failed. I have noticed that the above kinit command appends data to my original keytab file and any subsequent attempts to run the kinit command to get a tickect results in following error.   kinit: Unsupported key table format version number while getting initial credentials       ... View more

Kerberos authentication with hive JDBC driver

by New Contributor in Support Questions
‎01-20-2017 04:17 AM
‎01-20-2017 04:17 AM
I am trying to connect to Hive database with Oracle SQL developer using Cloudera Hive JDBC drivers. I keep getting following error message   Status : Failure -Test failed: [Cloudera][HiveJDBCDriver](500164) Error initialized or created transport for authentication: [Cloudera][HiveJDBCDriver](500169) Unable to connect to server: GSS initiate failed.   My Hadoop environment has Hive version 1.2.1.2.3 Kerberos version 1.10.3-10 I am trying to connect to this Hive database from Windows 7 64-bit machine which has Sqldeveloper version 4.2.0.16.356.1154 Cloudera_Hive JDBC4 driver 2.5.18.1050 MIT Kerberos app version 4.1   Important: Windows machine I am connecting from is on a different domain as that of Hadoop cluster.   I have followed instructions from Using SQL Developer to access Apache Hive with kerberos authentication and steps I have performed are. Imported all the jar files to SQL Developer from the JDBC driver . Updated Java Crypto jars (local_policy.jar and US_export_policy.jap in sqldeveloper\jdk\jre\lib\security folder) with ones provided in UnlimitedJCEPolicy.zip. Created an environment variable  KRB5CCNAME whose value is set to C:\sqldeveloper\ktfile.keytab Installed MIT kerberos 4.1 64-bit app Acquired valid ticked (via kinit/hrough the app) Picture below shows the connection details Hive connection details were:     Host name: machine.test.group port: 10010 database: default Krbservicename: hive AuthMech: 1 KrbFQDN: machine.test.group KrbRealm:  dev.mycompany.com   Can someone please advise me what I can do to fix the issue and connect to Hive using JDBC drivers. ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎01-27-2017 02:40 AM
Community Statistics
Member Since ‎01-20-2017 04:18 AM
Last Visited ‎01-27-2017 02:40 AM
Posts 3