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.dmg
disk image. - Double-click
MapRHiveODBC.pkg
to 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.