Apache Hive ODBC Driver
Select your platform
Table of Contents:
Overview
Progress DataDirect’s ODBC Driver for Apache Hadoop Hive offers a high-performing, secure and reliable connectivity solution for ODBC applications to access Apache Hadoop Hive data. Our ODBC driver can be easily used with all versions of SQL and across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX. Enjoy real-time analytics, reporting and business intelligence (BI) capabilities with your favorite tools such as Tableau, Power BI, Qlik, Excel, Cognos, Informatica, SAS, Board, MicroStrategy, SSIS, Oracle OBIEE and more.
- Wide support for all Hadoop versions and major Hadoop platforms on the market
- One driver supports all Hadoop distributions
- Get full support for any new version of Hive from day one
What's Included
- Apache Hive
- Amazon EMR Hive
- Cloudera CDH Hive
- Hortonworks Hive
- IBM BigInsights Hive
- MapR Hive
- Pivotal HD Hive
Features
Support for Windows Truststore for SSL Certificate Validation
Fast
Superfast data loading and extraction that reduces the time and cost of running enterprise infrastructures
Enterprise Features
Support for Advanced Security Features
Our Hive ODBC driver supports advanced security mechanisms including Kerberos, Knox, Sentry and Ranger for authentication and authorization across all your distributions.
Secure
Robust
Easy to Use
Versatile
Technical Specifications
All 32-bit versions of this driver are part of the Connect XE for ODBC Series. All 64-bit versions are part of the Connect64 XE for ODBC Series.
Progress DataDirect for ODBC for Apache Hive Wire Protocol Driver Version 8.0.1
(32- and 64-bit drivers are available for all supported databases and platforms unless otherwise noted.)
ODBC Version Support
- Compatible with ODBC 3.8 applications
Protocol Support
- HiveServer2
Hive Version Support
- Apache Hadoop Hive, version 3.0 and higher
- Supports Apache Hive version against the following distributions:
- Amazon Elastic MapReduce (Amazon EMR), version 7.3.0 and higher
- Cloudera Data Platform (CDP), version 7.1 and higher
- HPE Ezmeral Data Fabric, version 7.0 and higher
- Amazon Elastic MapReduce (Amazon EMR), version 7.3.0 and higher
- AIX, version 7.3 and higher
- AIX, version 7.1 and higher
- HP-UX IPF (32- and 64-bit), 11i version 3.0 (B.11.3x) and higher
- HP-UX PA-RISC (32-bit only), 11i version 3.0 (B.11.3x) and higher
- Debian Linux x86, version 12.0 and higher
- Oracle Linux x86, version 9.0 and higher
- Red Hat Enterprise Linux x86, version 8.0, 9.0 and higher
- SUSE Linux Enterprise Server Linux x86, version 12, 15 and higher
- Ubuntu Linux x86, version 20.04, 22.04 and higher
- Solaris x86 version 10 (Solaris 5.10), 11 and higher
- Solaris on SPARC, version 10, 11 and higher
- Windows (x86), version 10, 11 and higher
- Windows Server (x86), version 2016, 2019, 2022 and higher
- No Requirements
Operating System Support
AIX (32- and 64-bit)
HP
Note: For HP-UX PA-RISC, the 32-bit driver installers work only on 64-bit platforms. Please contact Technical Support if you want to use the driver on the 32-bit platforms.
Linux x86 (32- and 64-bit for AMD and Intel processors)
Solaris (32- and 64-bit)
Note: For Solaris and Solaris on SPARC, the 32-bit driver installers work only on 64-bit platforms. Please contact Technical Support if you want to use the driver on the 32-bit platforms.
Windows (32- and 64-bit)
Driver/Client Software Requirements
Sumit Sarkar
