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....@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....@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
