Skip to main content
MOMIE2005
Bronze ⭐️⭐️⭐️
Jun 14, 2022 9:42 PM UTC
Question

odbc ssis hive failing

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?

 

2 replies

ChethanYM
Gold ⭐️
Gold ⭐️
Jun 23, 2022 4:04 PM UTC

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

 

 

Translate
VidyaSargur
Community Manager
Community Manager
Jul 4, 2022 10:10 AM UTC

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

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