Member since
05-13-2024
1
Post
1
Kudos Received
0
Solutions
05-13-2024
04:07 AM
1 Kudo
We are having some issues while trying to connect with Cloudera Impala through pyobdc in our production enviroment (not in development env, neither in pre-production env). We have configured our Driver ODBC for Impala with v2.6.11.1011-1, Kerberos 5 v1.18.2, pip v23.3 and pyodbc v4.0.38. The Impala odbc driver is installed without problem, the impala ports are open, the kerberos ports are open too, everything was validated with telnet. Our connection string is defined in the following way: connection_string_IaaS = f'''
DRIVER=/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so;
Host=(name of host);
Port=21050;
AuthMech=1;
Encrypt=no;
KrbRealm=(name of data source);
KrbFQDN=(name of host);
KrbServiceName=impala;
TrustedCerts=/opt/cloudera/impalaodbc/lib/64/cacerts.pem;
TSaslTransportBufSize=60536;
RowsFetchedPerBlock=4000;
SSP_BATCH_SIZE=60536''' Once we ensure the kerberos ticket is right, we try to establish the connection by making pyodbc.connect(connection_string_IaaS, autocommit=True) and we obtain the following error: pyodbc.Error: ('HY000', '[HY000] [Cloudera][DriverSupport] (1110) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct and confirm if SSL should be enabled for the connection. (1110) (SQLDriverConnect)') What could be causing it?
... View more
Labels: