Member since
08-01-2017
1
Post
0
Kudos Received
0
Solutions
08-01-2017
11:50 AM
Hi Everyone, Sub: dbVisualizer to be used for querying hive tables I have setup Kerberos(MIT) Authentication. I have downloaded hive jdbc jars (hive_jdbc_2.5.17.1047) from cloudera connectors. I tired to connect Hive metastore tables though DbVisualizer using Kerberos Authentication mechanism but getting below errors in dbVisualizer. I tried with different hive JDBC urls and still getting errors 1. jdbc:hive2://<Servername.domain.com>:10000; 2 jdbc:hive2://<Servername.domain.com>:10000/default;principal=hive/<Servername2.domain.com>@HADOOP.yyy.XXXX.COM 3. jdbc:hive2://<Servername.domain.com>:10000;AuthMech=1;KrbRealm=HADOOP.yyy.XXXX.COM;KrbHostFQDN=<Servername2.domain.com>;KrbServiceName=hive Error: Log: 1. 2017-07-24 11:24:25.462 INFO 154 [ExecutorRunner-pool-3-thread-2 - H.?] Exception while connecting Hive2 java.sql.SQLException: [Cloudera][HiveJDBCDriver](500164) Error initialized or created transport for authentication: java.net.ConnectException: Connection timed out: connect. at com.cloudera.hiveserver2.hivecommon.api.HiveServer2ClientFactory.createTransport(Unknown Source) Caused by: com.cloudera.hiveserver2.support.exceptions.GeneralException: [Cloudera][HiveJDBCDriver](500164) Error initialized or created transport for authentication: java.net.ConnectException: Connection timed out: connect. 2. [Cloudera][HiveJDBCDriver](500164) Error initialized or created transport for authentication: Peer indicated failure: Unsupported mechanism type PLAIN
... View more
Labels:
- Labels:
-
Apache Hive