All Apps and Add-ons

try connect to hive DB

amielke
Communicator

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?

0 Karma

lroynsky
Explorer

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

0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...