SAP with Hive - Cloudera ODBC Driver - DSN Error 1100

[#1]

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.

[#2]

Another Question: other option can be Install jdbc?

[#3]

@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

[#4]

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