question Re: SAP with Hive - Cloudera ODBC Driver - DSN Error 1100 in Support Questions

SAP with Hive - Cloudera ODBC Driver - DSN Error 1100

vciampa — Tue, 21 Apr 2026 07:16:56 GMT

Hi Community Team,

I have a Private Cloud Base Platform 7.1.7.SP1 with hive 3.1. I need to connect my SAP server (Windows server) to hive. I installed Cloudera ODBC driver 2.6.13 and when I configured the DSN, shows me an error

"ERROR 1100 SSL certificate verification failed because the certificate is missing or incorrect.

- I have the AUTO TLS/SSL installed in the cluster. Hive has enabled TLS/SSL.

My Questions:

- How I generate a certificate .jks to this server that is not part of the cluster CDP.

- What other steps I do to resolve this.

Thank for your support.

Re: SAP with Hive - Cloudera ODBC Driver - DSN Error 1100

vciampa — Wed, 29 Mar 2023 20:00:23 GMT

Another Question: other option can be Install jdbc?

Re: SAP with Hive - Cloudera ODBC Driver - DSN Error 1100

Shelton — Wed, 29 Mar 2023 23:47:06 GMT

@vciampa

I tried to recreate your scenarion using HDP and ODBC

ODBC screens

I created a hive database and table and used a non ssl connection as shown below as my HDP is not Secured, though the ODBS delivers a certificate in C:\Program Files\Cloudera ODBC Driver for Apache Hive\lib\cacerts.pem

Ping from Windows

DSN Config

ODBC config

SSL Config

Table creation

Connect test

So it does work for non-TLS but when I enable TLS I get the below because TLS is not enabled on my HDP cluster , I will try in install sa self signed certificate and revert

Geoffrey

Re: SAP with Hive - Cloudera ODBC Driver - DSN Error 1100

vciampa — Fri, 21 Apr 2023 14:27:39 GMT

@Shelton, wow apologies, now I´m reading, excellent test.

Could you do testing with TLS/SSL?

I still haven`t solved this.. 😞

Thank you for your support.