Member since
11-09-2022
1
Post
0
Kudos Received
0
Solutions
01-04-2023
04:22 PM
Hi, We installed Cloudera ODBC Driver for Apache Hive 2.6.13.1013 on a Linux gateway server with REDHAT 7 and Oracle Database Gateway for ODBC 19c. We have to connect Oracle Database using a dblink to Linux Gateway server and then to Apache Hive server. After all configurations the connection using dblink fails with error: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Cloudera][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect. {HY000,NativeErr = 1100} ORA-02063: preceding 2 lines from DATALAKE odbc.ini configuration from Linux gateway server: [ODBC Data Sources] DATALAKE=Cloudera Hive ODBC Driver 64-bit [DATALAKE] Driver=/opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so HiveServerType=2 Host=dataplatform.grupocgd.com Port=10000 SSL=1 schema=default ServiceDiscoveryMode=0 AuthMech=3 ThriftTransport=1 ValidateServerCertificate=1 TrustedCerts=/opt/cloudera/hiveodbc/lib/64/cacerts.pem Can you help? Best regards, Sérgio Picamilho
... View more
Labels:
- Labels:
-
Apache Hive