Certificate verification failed while connecting to Cloudera Impala connector.

Certificate verification failed while connecting to Cloudera Impala connector.

While connecting to the Impala data source via ODBC connection i.e. using system/user ODBC with SSL, the connection is working but with Impala connector connection, it is throwing below error
 

The data source does not exist or it does not respond.
External error:
ERROR [HY000] [Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: SSL_connect: certificate verify failed
ERROR [HY000] [Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: SSL_connect: certificate verify failed

Check below points on both Spotfire Analyst and Node Manager machines to resolve above error :

1) In the User/System DSN, we can add a certificate path from any drive location, for example:  D:\TIBCO_bundle.pem whereas the Impala connector picks the required certificate always from the driver installation path(Example: C:\Program Files\Cloudera ODBC Driver for Impala\lib). So, make sure that the correct certificate is present inside the driver installation directory.

2) It is also possible, that multiple certificate files are present inside the installation directory of Impala driver but TIBCO Spotfire Impala connector always makes use of certificate having the name 'cacerts.pem'. https://www.cloudera.com/documentation/enterprise/5-6-x/topics/impala_ssl.html