Mapr Hive Odbc Driver For Mac
.ODBC is one of the most established APIs for connecting to and working with databases. Microsoft® Hive ODBC Driver provides HiveQL access from ODBC based applications to HDInsight Apache Hadoop Hive. This driver is available for both 32 and 64 bit Windows platform.See page for instructions on how to configure a DSN with this driver and use it to import data from Hive into Excel.Detailed documentation in the form of PDF files is also installed with the driver in the location specified during installation.There are two versions of this installation package (32-bit and 64-bit). You should install the version that matches the version of the application where you will be using the ODBC driver. Both packages can be installed on the same machine if you need both versions of the driver.You will need administrator privileges to install the driver.To install the ODBC driver:.
Download the installation package, double click on it to start the installation. Accept the license terms. Open the ODBC Data Source Administrator from the Control Panel. Create a ODBC DSN that you can use to connect from your ODBC application.
Page 1 of 20 Installing and Configuring the Hortonworks ODBC driver on Mac OS X Installing and Configuring the Hortonworks ODBC driver on Mac OS X May 28, 2013 Summary This document describes how to install and configure the Hortonworks ODBC driver on Mac OS. Ntpnp pci0025 driver for mac os. On the Add-Ons page, scroll down to Hortonworks Hive ODBC Driver (Windows + Mac. Microsoft® Hive ODBC Driver provides HiveQL access from ODBC based applications to HDInsight Apache Hadoop Hive. This driver is available for both 32 and 64 bit Windows platform. See this page for instructions on how to configure a DSN with this driver and use it to import data from Hive into Excel.
Goal:How to install and configure MapR Hive ODBC driver on Linux.This article gives detailed step-by-step instructions as a supplement to this.Env:CentOS 6.5 64bitMapR 5.2Hive 2.1MapRHiveODBC-2.1.8.1005-1.x8664libiodbc-3.52.7-1.el6.x8664Solution:1. Download and install MapR Hive ODBC Driver from based on the OS version.For example, this test environment is on CentOS 6.5:wget -ivh MapRHiveODBC-2.1.8.1005-1.el6.x8664.rpmThe location after the installation:. /opt/mapr/hiveodbc/ErrorMessages – Error messages files directory. /opt/mapr/hiveodbc/Setup – Sample configuration files directory.
/opt/mapr/hiveodbc/lib/64 – 64-bit shared libraries directoryODBC driver managers use configuration files to define and configure ODBC data sources and drivers. By default, the following configuration files residing in the user’s home directory are used:.odbc.ini – The file used to define ODBC data sources (required).odbcinst.ini – The file used to define ODBC drivers (optional).mapr.hiveodbc.ini – The file used to configure the MapR ODBC Driver with SQL Connector for Apache Hive (required)2. Configure the EnvironmentEnvironment variables ODBCINI and ODBCSYSINI can be used to specify different locations for the odbc.ini and odbcinst.ini configuration files.cp /opt/mapr/hiveodbc/Setup/odbc.ini /cp /opt/mapr/hiveodbc/Setup/odbcinst.ini /export ODBCINI=/odbc.iniexport ODBCSYSINI=/odbcinst.iniFor version 2.1.8 and above, you must also set MAPRHIVEINI to point to the mapr.hiveodbc.ini file in the user's home directory:export MAPRHIVEINI=/etc/.mapr.hiveodbc.iniConfigure LDLIBRARYPATH:export LDLIBRARYPATH=/opt/mapr/hiveodbc/lib/64:/usr/lib64/3.