Unable to connect HIVE through HANA system using isql -v HIVE

[Former Member]

Hi Mentors,

Recently iam also facing the same issue with connectivity from HANA -HADOOP

i have followed the HANA admin guide & SDA guide & installed the UNIX drivers(2.3.0)

• SIMBAdrivers
• Hortonworks driver

i was trying to fire isql -v
HIVE , HDP queries  but i get the same
error which u mentioned

  and usr/home contains
(.ODBC.ini ,simba.hiveodbc.ini. , hortonworks.hiveodbc.ini )

File contents

.ODBC.INI

[HIVE]

  #Description=Hortonworks Hive
ODBC Driver(64-bit)DSN

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

  HOST=ec2-54-153-2-16.us-west-1.compute.amazonaws.com

  HS2HostFQDN=ec2-54-153-2-16.us-west-1.compute.amazonaws.com

  PORT=10000

  Schema=default

  FastSQLPrepare=0

  UseNativeQuery=0

  HiveServerType=2

  HS2AuthMech=2

  UserName=hive

   .simba.hiveodbc.ini

DriverManagerEncoding=UTF-16

  ErrorMessagesPath=/_drivers/simba/hiveodbc/ErrorMessages/

  LogLevel=0

  LogPath=

  SwapFilePath=/tmp

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

#   SimbaDM / unixODBC

  ODBCInstLib=/usr/local/lib/libodbcinst.so

i tried all the ways to set environmental variables, i made all  directories sid adm as owner still i face the same error

Error [Simba]

<HOSTNAME.>:~> isql -vHIVE

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

[ISQL]ERROR: Could notSQLConnect

[Horton]

<HOSTNAME>~> isql -vHDP

  [S1000][unixODBC][Hortonworks][ODBC](11560) Unable to locate SQLGetPrivateProfileString function.

[ISQL]ERROR: Could notSQLConnect

PLEASE SUGGEST ME TO RESOLVE THE ISSUE

[Former Member]

Hi Mentors,

Can anyone please suggest me on this?

Thanks

ADMIN

[TomCenens]

Hi there, unknown person (would be much nicer to see a name there) but I'll suppose there is a regional or cultural aspect at hand here which makes it impossible for you to use your real name

I think it's best to look for a solution in the HortonWorks community actually since you're getting an error message that is HortonWorks specific.

Have you checked the HortonWorks forum already?

For example:

http://hortonworks.com/community/forums/topic/hive-odbc-php-sqlgetprivateprofilestring/

Kr

Tom

[Former Member]

Hi Tom,

Thanks a lot For your Reply After 6 days someone has replied.well my name is Pradeep iam from india

i have multiple passports installed on my workstation so couldnt able to post it from personal ID

well i belive i have checked all the Forums (even the one which u shared) no luck!!!

Have you tried installing the similar scenario.

i believe this has problem even with Simba Drivers.

Regards,

Pradeep

[TomCenens]

Hi Pradeep

Not yet, I'm willing to give it a spin but I need to find the time to do so then which proves to be difficult right now.

error message NoSQLGetPrivateProfileString could not be found in the en-US
locale. Check that[INSTALLDIR]/simba/hiveodbc/ErrorMessages//en-US/ODBCMessages.xml exists.

[ISQL]ERROR: Could notSQLConnect

Did you check if this XML exists?

Kr

Tom

[Former Member]

Hi Tom,

Thanks for your reply

Yes i can see the files in /Error Messages/en-us.

• ODBCmessages.xml
• SimbaHiveODBCmessages.xml

[TomCenens]

Any useful information inside the files which can help troubleshooting?