Hive ODBC Connector on Mac OS X

System Requirements

  • Mac OS X version 10.6.8 or later
  • 100 MB of available disk space
  • iODBC 3.52.7 or above

The MapR ODBC Driver with SQL Connector for Apache Hive requires a Hadoop cluster with the Hive service installed and running. The MapR ODBC Driver with SQL Connector for Apache Hive is suitable for use with all versions of Hive. The driver supports both 32- and 64-bit client applications.

Download the MacOS Hive ODBC connector from https://package.mapr.com/tools/MapR-ODBC/MapR_Hive/MapRHive_odbc_2.1.9.1014/MapRHiveODBC.dmg

Installation

The MapR ODBC Driver with SQL Connector for Apache Hive driver files are installed in the following directories:

  • /opt/mapr/hiveodbc/ErrorMessages – Error messages files directory
  • /opt/mapr/hiveodbc/Setup – Sample configuration files directory
  • /opt/mapr/hiveodbc/lib/universal – Binaries directory

To install the MapR ODBC Driver with SQL Connector for Apache Hive:

  1. Double-click to mount the MapRHiveODBC.dmg disk image.
  2. Double-click MapRHiveODBC.pkg to run the Installer.
  3. Follow the instructions in the Installer to complete the installation process.
  4. When the installation completes, click Close.

Configuration

Setting the DYLD_LIBRARY_PATH Environment Variable

The DYLD_LIBRARY_PATH environment variable must include the paths to:

  • Installed ODBC driver manager libraries
  • Installed MapR ODBC Driver with SQL Connector for Apache Hive shared libraries

For example, if ODBC driver manager libraries are installed in /usr/local/lib, then set DYLD_LIBRARY_PATH as follows:

export DYLD_LIBRARY_PATH=/usr/local/lib/opt/mapr/hiveodbc/lib/universal

Refer to your Mac OS X shell documentation for details on how to set environment variables permanently.

Configure Hive ODBC Connections on Mac OS X

See Configuring ODBC Connections for Linux for details on creating ODBC connections.