Page 1 of 1

IMPALA - Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

Posted: Tue May 08, 2018 3:00 am
by RobyPad
:?:
Hi all,
with upgrade to CLOUDERA 5.14.0 i have some problems...

First of all, I updated the library "libclouderaimpalaodbc64.so" and when I try to connect to Impala, DS returns this message: "ODBC function "SQLConnect" reported: SQLSTATE = IM005: Native Error Code = 0: Msg = [DataDirect][ODBC lib] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed (CC_OdbcConnection::connect, file CC_OdbcConnection.cpp, line 582)"

What should I change in the file ".odbc.ini"?
Is there anything else that I should see?

Thanks so much,
Roberto

Posted: Tue May 08, 2018 6:48 am
by chulett
Welcome.

So, just to clarify - this was working previously with an earlier version of Cloudera but stopped when you "updated the library"?

Posted: Tue May 08, 2018 7:51 am
by RobyPad
Hi,

yes it works, but there is a QUERY that has a problem after the update.
I have tried to update the driver to see if it were that the problem...

Now I follow this guide: http://www.cloudera.com/documentation/o ... -Guide.pdf


Let's see if this solves it...

Posted: Mon Jun 04, 2018 7:35 am
by RobyPad
I have resolved the problem with the update Cloudera from CDH 5.14.0 to CDH 5.14.2

Posted: Mon Jun 04, 2018 8:48 am
by chulett
Awesome, thanks for posting an update.