question Re: odbc ssis hive failing in Support Questions

odbc ssis hive failing

MOMIE2005 — Fri, 16 Sep 2022 14:46:21 GMT

HELLO,

IM TRYing to refresh automatically via ssis package a cube ssas tabular which is connected to hive via ODBC cloudera latest driver.

When I´m manually processing my cube It works without any problems , but when I´m using SSIS to automate the process I have this error message (It worked in ssis fine just this 4 days I have this problem)

Analysis Services Execute DDL Task] Error: The JSON DDL request failed with the following error: Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [HY000] [Cloudera][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_read: errno = 9. ERROR [HY000] [Cloudera][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_read: errno = 9.. OLE DB or ODBC error: The command has been canceled.. OLE DB or ODBC error: The command has been canceled.. OLE DB or ODBC error: The command has been canceled..

Can you please help me?

Re: odbc ssis hive failing

ChethanYM — Thu, 23 Jun 2022 16:04:06 GMT

Hello,

You need to enable trace level logging for ODBC driver and should check the logs after reproducing the issue.

Check if you have any socket timeout errors in the trace logs if yes refer the below doc to set the socket timeout.

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

Regards,

Chethan YM

Re: odbc ssis hive failing

VidyaSargur — Mon, 04 Jul 2022 10:10:04 GMT

@MOMIE2005 Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.