Microsoft Download Center Archive
![]() | Microsoft® Hive ODBC Driver |
Microsoft® Hive ODBC Driver is a connector to Apache Hadoop Hive available as part of HDInsight clusters. Microsoft® Hive ODBC Driver enables Business Intelligence, Analytics and Reporting on data in Apache Hive.
- 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 this 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.
Files
![]() | Status: LiveThis download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center. |
File | Size |
---|---|
![]() SHA1: 90d9fa2846ec50fd4e54954fb28ba4975a6fb6bb | 14.86 MB |
![]() SHA1: 968f5a650e761091df353a7bf3bb2312bdbe082a | 18.16 MB |
File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.
System Requirements
Operating Systems: Windows 10, Windows 7, Windows 8, Windows Server 2008 R2, Windows Server 2012
- Microsoft® Hive ODBC Driver is supported with either of the following HDInsight versions:
- Windows Azure HDInsight Service cluster versions 1.6 or greater.
- Windows Azure HDInsight Emulator version 1.0.0.0 or greater.
Installation Instructions
- 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.