Configuring the Hive ODBC Driver for Mac

I have downloaded (from http://public-repo-1.hortonworks.com/HDP-1.2.0/hive-odbc/1.2.0.1005/Mac_OS_X/hive-odbc-native.dmg) and installed the Hive ODBC driver for Mac but I cant find any documents of how to configure the driver and no driver is listed under the ODBC Administrator utility or when I try to create a new Query in Excel 2011. Any guides anywhere? thanks in advance

Topic

[tedrMember]

Hi John,

It would appear that we have a glaring hole in our documentation. I’ll try to hunt this information down and give you a link.

Thanks,
Ted.

[John SotiropoulosMember]

Hi Yi
thanks for your reply. Your suggestion was useful in starting your server-side Hive ODBC interface. I can use this to connect from Windows as explained in your doc http://hortonworks.com/wp-content/uploads/2012/10/Hortonworks-Hive-ODBC-Driver-User-Guide.pdf but i cannot find anything on how to connect from my macbook using your ODBC driver you supply.

When i run the MAC OSX ODBC administrator the Hive Driver (i succesfully installed from your downloads, see prev post ) is not listed. I can’t see it in Excel for Mac OS X either. How can I use the Mac driver from my MacBook laptop?

Thanks again, John

[yi zhangMember]

Hi John,

Can you try starting hiveserver on port 10000? Assumed that the ODBJ driver is configured on port 10000
#hive –service hiveserver –hiveconf HIVE_PORT=10000 (there are two dashes before word service)

Thanks,
Yi

[Author]

Replies