try connect to hive DB

amielke — Mon, 25 Mar 2019 20:12:51 GMT

We use DB-Connect v 3.1.3 and we try to connec to the HiveDB and get following Error:
Could not open client transport with JDBC Uri: jdbc:hive2://hostname:port/;useSSL=true;sslTrustStore=/opt/splunk/etc/apps/splunk_app_db_connect/certs/store.jks;trustStorePassword=***PW***;transportMode=http;httpPath=gateway/default/hive: Could not create http connection to jdbc:hive2://hostname:port/;useSSL=true;sslTrustStore=/opt/splunk/etc/apps/splunk_app_db_connect/certs/store.jks;trustStorePassword=***PW***;transportMode=http;httpPath=gateway/default/hive. org.apache.http.NoHttpResponseException: The target server failed to respond

(hostname, port and ***PW*** are only placeholder!)

The Server is via IP and Port accessible via ping and netcat.

Any Idea?

Re: try connect to hive DB

lroynsky — Thu, 22 Aug 2019 16:52:08 GMT

I don't know if this will help, but I had trouble with cert mismatching causing the issue. Here are the values I'm using for the custom JDBC URL.

AuthMech=3 (default is 0)
transportMode=http
SSL=1
httpPath=gateway/default/hive2
CAIssuedCertsMismatch=1
AllowSelfSignedCerts=1

This document should help and has all available attributes: https://www.cloudera.com/documentation/other/connectors/hive-jdbc/latest/Cloudera-JDBC-Driver-for-Apache-Hive-Install-Guide.pdf

topic Re: try connect to hive DB in All Apps and Add-ons

try connect to hive DB

Re: try connect to hive DB