Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ODBC Connection issues with SimbaHiveOdbc

I am trying to connect hana with hadoop using SimbaHiveOdbc driver and unix odbc driver.

I am following the sap hana academy video tutorials about smart data access.

I am following this one to configure simbaOdbc

HANA Live2!: Installing the HIVE ODBC Driver for Connecting to Hadoop from SAP HANA One


I followed each and every step and varified again and again

But I am facing following issues

[S1000][unixODBC][DSI] The error message LicFileNotFound could not be found in the en-US locale. Check that /simbaodbc/simba/hiveodbc/ErrorMessages//en-US/ODBCMessages.xml exists.


But I have placed my license  file at following address

/usr/sap/HDB/home/SimbaApacheHiveODBCDRiver.lic

here is my .customer.sh

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/unixodbc/usr/local/lib/

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/simbadriver/simba/hiveodbc/lib/64/

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib/

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib64/

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib64/

export ODBCINI=$HOME/.odbc.ini

here is my .odbc.ini

[HIVE]

Driver=/simbadriver/simba/hiveodbc/lib/64/libsimbahiveodbc64.so

Host=ip

Port=10000

HiveServerType=2

AuthMech=0

here is .simba.hiveodbc.ini

DriverManagerEncoding=UTF-16

ErrorMessagesPath=/simbaodbc/simba/hiveodbc/ErrorMessages/

LogLevel=0

LogPath=

SwapFilePath=/tmp

#  SimbaDM / unixODBC

ODBCInstLib=libodbcinst.so

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question