question Re: 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)') in Support Questions

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)')

vlallana — Mon, 13 May 2024 11:07:30 GMT

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?

Re: 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)')

VidyaSargur — Tue, 14 May 2024 08:08:26 GMT

@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.

Re: 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)')

ChethanYM — Tue, 14 May 2024 08:25:35 GMT

@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

Re: 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)')

VidyaSargur — Thu, 23 May 2024 05:52:58 GMT

@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.