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.