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!

Admin Your Splunk Cloud, Your Way

Join us to maximize different techniques to best tune Splunk Cloud. In this Tech Enablement, you will get ...

Cloud Platform | Discontinuing support for TLS version 1.0 and 1.1

Overview Transport Layer Security (TLS) is a security communications protocol that lets two computers, ...

New Customer Testimonials

Enterprises of all sizes and across different industries are accelerating cloud adoption by migrating ...