DBVisualizer configuration with hive in kerberos env

[Kumar Jayapal <kj...@gmail.com>]

Hi All,

Did any one integrate DBVisualizer  with hive in a KRB cluster.

I followed the steps given at the site still not able to make a connection
to hive.

https://community.hortonworks.com/articles/32586/integrating-dbvisualizer-with-kerberized-hive.html


I am using hive 0.13.1+cdh5.3.3+350

2016-06-22 10:19:36.222 FINE    23 [ExecutorRunner-pool-3-thread-2 - G.?]
Connecting: DBVHIVE_Kerberos
2016-06-22 10:19:36.224 FINE    23 [ExecutorRunner-pool-3-thread-2 - L.?]
Loading class using dynamic ClassLoader: com.cloudera.hive.jdbc4.HS2Driver
2016-06-22 10:19:36.224 FINE    23 [ExecutorRunner-pool-3-thread-2 - L.?]
Loading class using dynamic ClassLoader: com.cloudera.hive.jdbc4.HS2Driver
2016-06-22 10:19:36.225 FINE    23 [pool-5-thread-3 - D.?] RootConnection:
HS2Driver.acceptsURL("jdbc:hive2://
dssh91.org.abc.net:10000/default;AuthMech=1;principal=hive/dssh91.org.abc.net@D007.ORG.ABC.NET
")
2016-06-22 10:19:36.226 FINE    23 [pool-5-thread-3 - D.?] RootConnection:
HS2Driver.connect("jdbc:hive2://
dssh91.org.abc.net:10000/default;AuthMech=1;principal=hive/dssh91.org.abc.net@D007.ORG.ABC.NET",
{user=*****, password=**********})
2016-06-22 10:19:36.228 FINE    23 [pool-5-thread-3 - D.?] RootConnection:
EXCEPTION -> java.sql.SQLException: [Simba][HiveJDBCDriver](500310) Invalid
operation: Unable to obtain Principal Name for authentication ;
java.sql.SQLException: [Simba][HiveJDBCDriver](500310) Invalid operation:
Unable to obtain Principal Name for authentication ;
at
com.cloudera.hive.hivecommon.api.HiveServer2ClientFactory.createTransport(HiveServer2ClientFactory.java:224)
at
com.cloudera.hive.hive.api.ExtendedHS2Factory.createClient(ExtendedHS2Factory.java:38)
at
com.cloudera.hive.hivecommon.core.HiveJDBCConnection.connect(HiveJDBCConnection.java:597)
at
com.cloudera.hive.jdbc.common.BaseConnectionFactory.doConnect(BaseConnectionFactory.java:219)
at
com.cloudera.hive.jdbc.common.AbstractDriver.connect(AbstractDriver.java:216)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.onseven.dbvis.h.B.D.?(Z:1548)
at com.onseven.dbvis.h.B.F$A.call(Z:1369)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
Caused by: com.cloudera.hive.support.exceptions.GeneralException:
[Simba][HiveJDBCDriver](500310) Invalid operation: Unable to obtain
Principal Name for authentication ;
... 14 more

Any help is appreciated....




Thanks
Jay