Created on 01-20-2017 04:17 AM - edited 09-16-2022 03:55 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
I am trying to connect to this Hive database from Windows 7 64-bit machine which has
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.
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.