Skip to main content
vlallana
Bronze ⭐️⭐️⭐️
May 13, 2024
Question

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

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?

3 replies

VidyaSargur
Community Manager
Community Manager
May 14, 2024

@vlallana, Welcome to our community! To help you get the best possible answer, I have tagged our Impala experts @ChethanYM @mszurap @ShankerSharma who may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

Translate
Regards, Vidya Sargur, Community Manager Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.
ChethanYM
Gold ⭐️
Gold ⭐️
May 14, 2024

@vlallana 

Its a generic error you just need to compare the configurations/settings between prod and dev clusters and check the Impala server status and it is ready to accept the connections.
try to use the latest available driver and check if there is any network connectivity issue, if everything good enable the driver trace level logging[1] and repro the issue then review the logs for more details.

Regards,

Chethan YM

[1]. https://docs.cloudera.com/documentation/other/connectors/impala-odbc/2-6-11/Cloudera-ODBC-Driver-for-Impala-Install-Guide.pdf

 

Translate
VidyaSargur
Community Manager
Community Manager
May 23, 2024

@vlallana, Did the response assist in resolving your query? If it did, kindly mark the relevant reply as the solution, as it will aid others in locating the answer more easily in the future. 

Translate
Regards, Vidya Sargur, Community Manager Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.