question Re: Updated instructions for hive ODBC setup? in Archives of Support Questions (Read Only)

Updated instructions for hive ODBC setup?

Dominika — Sat, 14 May 2016 03:22:09 GMT

Where can I find updated instructions for Hive ODBC setup? I am following this tutorial http://hortonworks.com/hadoop-tutorial/hello-world-an-introduction-to-hadoop-hcatalog-hive-and-pig/and trying to fulfill the pre-requisite step at http://hortonworks.com/hadoop-tutorial/how-to-install-and-configure-the-hortonworks-odbc-driver-on-mac-os-x/ which is marked as "DEPRECATED".

Still, I tried following these deprecated instructions, got pass the issue described at https://community.hortonworks.com/articles/1575/installing-hive-odbc-with-iodbc-35210-on-mac-os-x.html

But now I can't access Hive ODBC DSN in Excel. Tried adding it manually, but to no avail. iODBC seems to see the DSN and is able to connect to it just fine. I am wondering if this is an Excel problem on Mac (I am using Excel 15.21)?

Either way, it would be great if someone could provide non-deprecated instructions.

Re: Updated instructions for hive ODBC setup?

cstanca — Thu, 19 May 2016 01:54:42 GMT

@ Dominika B

The Hortonworks Hive ODBC Driver for OSX 10.11 (El Capitan) failing to install bug has been tracked on HWX's Jira Engineering since November 2015: https://hortonworks.jira.com/browse/BUG-47990. This issue has been escalated to Simba. They have released an updated ODBC driver called 2.1.x which is not yet on their website. Their latest on the website is 2.0.3. The 2.1.x version provided to Hortonworks and certified with HDP 2.3.2 addresses inability to install properly on OSX El Capitan. If you are an Hortonworker, you could download the driver (2.1.2.1002) at:

https://simba.app.box.com/s/2e1m5sjimcrm0m5gsnirhpxuduw0aoo7.

Setup instructions:

https://hortonworks.com/wp-content/uploads/2016/03/Hortonworks-Hive-ODBC-Driver-User-Guide.pdf, page 33.

http://cdn.simba.com/products/Hive/doc/Simba_Hive_ODBC_InstallGuide.pdf

Re: Updated instructions for hive ODBC setup?

cstanca — Sun, 22 May 2016 01:17:41 GMT

@Dominika B

Let me know if the above instructions helped. Vote response.

Re: Updated instructions for hive ODBC setup?

Dominika — Tue, 24 May 2016 00:42:20 GMT

Thanks, Constantin! I'll give it a try.

Re: Updated instructions for hive ODBC setup?

srai1 — Thu, 02 Jun 2016 04:34:31 GMT

Any luck finding a solution to this issue ? I got similar issues with trying to make excel talk to hive over odbc

https://community.hortonworks.com/questions/25738/unable-to-connect-excel-2016-for-mac-to-hive.html