ODBC Connection issues with SimbaHiveOdbc

[Former Member]

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

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

[Former Member]

Hi Khalid,

As you mentioned in this thread it seems that you have already resolved the "The error message LicFileNotFound could not be found" error where the driver is not able to find the error message string for the LicFileNotFound  error.

Regarding error where the driver is complaining that the license file cannot be found you might want to try placing the license file in either the current user's home directory or the driver lib directory (/simbadriver/simba/hiveodbc/lib/64).

In addition there seems to be a typo in the license file name. The file name should be SimbaApacheHiveODBCDriver.lic with lower case "r" in Driver.

Cheers,

Holman

[Former Member]

Hi Majadid,

Try moving your license file to /simbadriver/simba/hiveodbc/lib/64/ instead, as the license file needs to be co-located with the driver file.

Can you also correct your ErrorMessagesPath, as right now I don't believe it's pointing to the correct directory and that's why the error message you get is somewhat obtuse.

Cheers,

Kyle