9
votes

I am trying to query Hortonworks Hive via ODBC Driver in Excel 2013.

I downloaded the driver here (32-bit):

http://hortonworks.com/downloads/

Hortonworks 2.5 Hive 2.5.0.0-1245

Then I add the config in ODBC Data Source Administrator (32-bit)

enter image description here

enter image description here

Everything seems fine.

Then when I go into Excel 2013 to build the query:

enter image description here

enter image description here

I got this error:

enter image description here

Anyone knows why?

1
This might help. Namely, "This error is related to the fact that you have 32-bit ODBC drivers which are not compatible with 64-bit Import Tool." - gobrewers14

1 Answers

0
votes

The problem is the Hive driver from Hortonworks. For some reason, it's not compatible with Excel or Power BI.

I downloaded Microsoft Hive ODBC from https://www.microsoft.com/en-us/download/details.aspx?id=40886 and everything works perfectly. Make sure to choose SASL and not HTTP when creating User DSN.