IMPALA - Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
RobyPad
Participant
Posts: 4
Joined: Tue May 08, 2018 2:38 am

IMPALA - Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

Post 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
Last edited by RobyPad on Tue Jun 05, 2018 1:59 am, edited 1 time in total.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Welcome.

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

"You can never have too many knives" -- Logan Nine Fingers
RobyPad
Participant
Posts: 4
Joined: Tue May 08, 2018 2:38 am

Post 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...
RobyPad
Participant
Posts: 4
Joined: Tue May 08, 2018 2:38 am

Post by RobyPad »

I have resolved the problem with the update Cloudera from CDH 5.14.0 to CDH 5.14.2
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Awesome, thanks for posting an update.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply