Hello, I am working on a CDP 7.1.9 environment and I am currently testing the Impala ODBC connection using the Cloudera Impala ODBC Driver 2.8.4 on a Unix system with unixODBC. The configuration is as follows: ODBC driver installed and registered in /etc/odbcinst.ini:   [Cloudera ODBC Driver for Impala 64-bit] Description=Cloudera Impala ODBC Driver (64-bit) Driver=/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so UsageCount=1   DSN configured in /etc/odbc.ini SSL certificates correctly configured and integrated into the OS trust store Trying to connect using LDAP authentication (username/password)         [Impala_CDP] Driver=/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so Host=**************** Port=21050 Schema=************* AuthMech=3 SSL=1 TrustedCerts=/etc/pki/ca-trust/extracted/pem/tls-ca-bundle.pem LogLevel=6 LogPath=/tmp/impala2.log However, the connection fails with the following error: isql -v Impala_CDP user "mdp" [28000][unixODBC][Cloudera][ThriftExtension] (2) Error occurred during authentication. [ISQL]ERROR: Could not SQLConnect Relevant logs from the driver show that SSL verification is successful, but authentication fails. The same credentials are working in another environment where authentication is successful. tail -f clouderaodbcdriverforimpala_connection_0.log mars 30 16:20:46.379 DEBUG 3705746048 Simba::ThriftExtension::TETSaslClientTransport::TETSaslClientTransport: +++++ exit +++++ mars 30 16:20:46.391 DEBUG 3705746048 DriverSupport::DSSSLUtils::SslDefaultVerifyCertCallback: The X509_STORE_CTX_get_error of SSL verification is: 0 mars 30 16:20:46.391 DEBUG 3705746048 DriverSupport::DSSSLUtils::SslVerifyCertCallback: Error depth: 1 mars 30 16:20:46.391 DEBUG 3705746048 DriverSupport::DSSSLUtils::SslDefaultVerifyCertCallback: The X509_STORE_CTX_get_error of SSL verification is: 0 mars 30 16:20:46.391 DEBUG 3705746048 DriverSupport::DSSSLUtils::SslVerifyCertCallback: Error depth: 0 mars 30 16:20:46.394 TRACE 3705746048 Simba::ThriftExtension::TEHttpApiRetryEmulationTestSettings::~TEHttpApiRetryEmulationTestSettings: +++++ enter +++++ mars 30 16:20:46.394 TRACE 3705746048 Simba::ImpalaODBC::ImpalaTCLIServiceClientFactory::~ImpalaTCLIServiceClientFactory: +++++ enter +++++ mars 30 16:20:46.395 TRACE 3705746048 Simba::ImpalaODBC::ImpalaConnection::SetProperty: +++++ enter +++++ mars 30 16:20:46.395 ERROR 3705746048 Simba::ODBC::Connection::SQLConnectW: [Cloudera][ThriftExtension] (2) Error occured during authentication. mars 30 16:20:46.395 TRACE 3705746048 Simba::ThriftExtension::TEHttpApiRetryEmulationTestSettings::~TEHttpApiRetryEmulationTestSettings: +++++ enter +++++ Could you please help clarify and resolve this issue:  Any specific configuration required for LDAP authentication with this driver? If there are known compatibility issues between CDP 7.1.9 and this ODBC driver version? Thank you for your support. ... View more

Hello everyone, I’m currently facing a performance issue with Cloudera Impala when using it through the ODBC driver. Here is my environment: CDH: 6.2 Impala: 3.2.0 (Impala 2.7.1 ODBC Driver) Integration: SAS 9.4 M7 (SAS Access to Impala) Authentication: Active Directory (user/mdp) Security: SSL enabled I have configured my /etc/odbc.ini as follows: [Impala_KRB14] Description=ODBC Cloudera Impala SSL Node 14 Driver=/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so HOST=""""""""" ##hidden PORT=21050 Database=""""""""""" ##hidden AuthMech=3 SSL=1 TrustedCerts=/etc/pki/ca-trust/extracted/pem/tls-ca-bundle.pem LogLevel=2 LogPath=/tmp/impala_odbc.log SSP_BATCH_SIZE=60536 RowsFetchedPerBlock=60536 TSaslTransportBufSize=4000 I also tried adding several ODBC options/tuning as seen in the odbc.ini parameters, but unfortunately I did not see any performance improvement. The issue is mainly that: Opening a table through SAS takes a long time Even simple queries like SELECT ... WHERE ... are very slow I would like to understand: How can I properly tune the Impala ODBC driver to improve query performance? Are there any known issues or recommended configurations for improving performance with SAS 9.4 M7 and Impala 3.2 on CDH 6.2? What logs or debug options can I enable to provide more details if needed? Changing into Impala ODBC Connector 2.8.4 does it really help ? Any help or guidance would be highly appreciated. ... View more