Member since
11-25-2025
2
Posts
0
Kudos Received
0
Solutions
11-25-2025
02:57 AM
Thank you very much for trying to help. I’ve been stuck on this subject for the past two weeks, trying to improve queries on Impala. I’m currently on RHEL 9 and have unixODBC installed. I’ve configured my environment via /etc/profile.d/oracle.sh as follows: # Oracle Instant Client configuration export TNS_ADMIN=/opt/oracle/instantclient_12_2/network/admin export PATH=/opt/oracle/instantclient_12_2:$PATH export LD_LIBRARY_PATH=/opt/oracle/instantclient_12_2:/usr/lib64:$LD_LIBRARY_PATH # ODBC configuration export ODBCINI=/etc/odbc.ini export ODBCSYSINI=/etc # Cloudera Impala ODBC configuration export CLOUDERAIMPALAINI=/opt/cloudera/impalaodbc/lib/64/cloudera.impalaodbc.ini I’ve tested with: `isql Impala_KRB14 user password` and it connects successfully, but queries are taking too long. I’m looking for guidance on how to optimize these queries effectively. Here are the version of installed packages: unixODBC 2.3.9 DRIVERS............: /etc/odbcinst.ini SYSTEM DATA SOURCES: /etc/odbc.ini FILE DATA SOURCES..: /etc/ODBCDataSources USER DATA SOURCES..: /etc/odbc.ini SQLULEN Size.......: 8 SQLLEN Size........: 8 SQLSETPOSIROW Size.: 8 rpm -qa | grep cyrus-sasl cyrus-sasl-lib-2.1.27-21.el9.x86_64 cyrus-sasl-gssapi-2.1.27-21.el9.x86_64 cyrus-sasl-plain-2.1.27-21.el9.x86_64 cyrus-sasl-2.1.27-21.el9.x86_64
... View more