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!

Cultivate Your Career Growth with Fresh Splunk Training

Growth doesn’t just happen—it’s nurtured. Like tending a garden, developing your Splunk skills takes the right ...

Introducing a Smarter Way to Discover Apps on Splunkbase

We’re excited to announce the launch of a foundational enhancement to Splunkbase: App Tiering.  Because we’ve ...

How to Send Splunk Observability Alerts to Webex teams in Minutes

As a Developer Evangelist at Splunk, my team and I are constantly tinkering with technology to explore its ...