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
 - unixODBC 2.2.12 or above
 
The Data Fabric ODBC Driver with SQL Connector for Apache Hive requires a Hadoop cluster with the Hive service installed and running. The Data Fabric 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.
Installation
The Data Fabric 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 Data Fabric ODBC Driver with SQL Connector for Apache Hive:
- Double-click to mount the 
MapRHiveODBC.dmgdisk image. - Double-click 
MapRHiveODBC.pkgto run the Installer. - Follow the instructions in the Installer to complete the installation process.
 - 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 Data Fabric 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.