Support Questions
Find answers, ask questions, and share your expertise

Updated instructions for hive ODBC setup?

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/a... trying to fulfill the pre-requisite step at http://hortonworks.com/hadoop-tutorial/how-to-install-and-configure-the-hortonworks-odbc-driver-on-m... 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.ht...

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.

1 ACCEPTED SOLUTION

@ 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

View solution in original post

4 REPLIES 4

@ 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

@Dominika B

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

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

Guru

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

; ;