Cloudera Community

Welcome to the Cloudera Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Advanced Search
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Unable to locate SQLGetPrivateProfileString function.

avatar
author-rank sarvesh
New Contributor

Created on ‎08-17-2015 12:01 AM - edited ‎08-17-2015 08:47 AM

Hi ,

 

 

i am getting below given error while connecting to cloudera hive using cloudera hive odbc driver.

 

[Cloudera][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function.[DataDirect][ODBC lib] Driver's SQLSetConnectAttr failed
Database driver error...
Function Name : Connect
Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [hive] and connection string [Cloudera_Hive].]

 

ODBC.ini file entry:-

[ODBC Data Sources]
Sample Cloudera Hive DSN 32=Cloudera Hive ODBC Driver 64-bit
[Cloudera_Hive]
Driver=/opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
HOST=52.25.153.146
PORT=10000
Schema=default
HiveServerType=2
HS2AuthMech=2
FastSQLPrepare=0
UseNativeQuery=0
UserName=hive
Trace=Yes
TraceFile=/tmp/odbc.log

 

I have also configured the below given variable in .profile path.


LD_PRELOAD=/Informatica/ODBC7.1/lib/libodbcinst.so

 

but still i am getting the same issue.

so please provide the resolution for the same.

 

regards

sarvesh

 

2,989
0 Kudos
1
Who agreed with this topic