Support Questions

Find answers, ask questions, and share your expertise

Who agreed with this topic

dbVisualizer to be used for querying hive but getting error while accessing Hive metastore tables

New Contributor

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 

 

 

 

 

Who agreed with this topic