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
