I’ve installed the Cloudera ODBC driver on our AWS LINUX. I am following all the instructions in the associated guide and after configuring the odbc.ini as follows:
[ODBC Data Sources]
CDLPROD DSN=Cloudera ODBC Driver for Impala 64-bit
CDLQA DSN=Cloudera ODBC Driver for Impala 64-bit
[CDLPROD]
Driver=/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
Host=edlimpalaprod.jnj.com
Port=21050
AuthMech=3
UseSASL=1
TrustedCerts=/opt/cloudera/impalaodbc/lib/64/cacerts.pem
UID=sagbcsbp@JNJ.COM
PWD=XXXXXX
TSaslTransportBufSize = 1000
[CDLQA]
Driver=/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
Host=edlimpalaqa.jnj.com
Port=21050
AuthMech=3
UseSASl=1
TrustedCerts=/opt/cloudera/impalaodbc/lib/64/cacerts.pem
UID=sagbcsbq@JNJ.COM
PWD=XXXXXX
TSaslTransportBufSize = 1000
I am trying to test the DSN connection using the following command from /usr/local/odbc:
isql -v CDLPROD
[S1000][unixODBC][Cloudera][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect.
[ISQL]ERROR: Could not SQLConnect
Would someone be able to help me resolve this issue? It would be greatly appreciated.
... View more
