Table of Contents:

    Overview

    Progress DataDirect’s ODBC Driver for Amazon EMR Hive offers a high-performing, secure and reliable connectivity solution for ODBC applications to access Amazon EMR 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.

    • Extensively tested for any ODBC application connecting to Amazon EMR Hive
    • Wire protocol enables easy configuration for quick launch
    • Makes connecting a wide array of data sources easier, faster and simpler

    What's Included

    • Apache Hadoop Hive
    • Amazon EMR Hive
    • Cloudera CDH Hive
    • Hortonworks Hive
    • IBM BigInsights Hive
    • MapR Hive
    • Pivotal HD Hive 

    Features

    Fast

    Superfast data loading and extraction that reduces the time and cost of running enterprise infrastructures 

    Enterprise Features

    Extensive support of data types to enable the full use of Greenplum functionality 

    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

    Supports the latest TLS protocols for data encryption, secure authentication methods for connections and HTTP Proxy for client security while connecting to cloud deployments 

    Robust

    Ensure high availability via application failover and workload balancing without changing application code 

    Easy to Use

    True standards compliance with ODBC and JDBC 

    Versatile

    Supported on every major platform and certified to work with leading applications such as Power BI, Tableau, Informatica, Cognos, SAS, Business Objects and more 

    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 1.0, 2.0, 3.0 and higher
    • Supports Apache Hive version against the following distributions:
      • Amazon Elastic MapReduce (Amazon EMR), version 4.0 and higher
      • Cloudera's Distribution Including Apache Hadoop (CDH), version CDH5.4 and higher
      • Hortonworks Distribution for Apache Hadoop, version 2.3 and higher
      • IBM BigInsights, version 4.0 and higher
      • MapR Distribution for Apache Hadoop, version 5.0 and higher
      • Pivotal HD Enterprise (PHD), version 3.0 and higher
    • Operating System Support

      AIX (32- and 64-bit)

      • AIX, version 5.3, 6.1, 7.1 and higher

      HP

      • HP-UX IPF (32- and 64-bit), 11i Version 2.0 (B.11.23) and higher
      • HP-UX PA-RISC (32-bit only), Version 11 and higher

      Linux x86 (32- and 64-bit for AMD and Intel processors)

      • CentOS Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
      • Debian Linux x86, version 7.0, 8.0 and higher
      • Oracle Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
      • Red Hat Enterprise Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
      • SUSE Linux Enterprise Server Linux x86, version 10, 11, 12, 15 and higher
      • Ubuntu Linux x86, version 14.04, 16.04, 18.04 and higher

      Solaris (32- and 64-bit)

      • Solaris x86 version 10 (Solaris 5.10), 11 and higher
      • Solaris on SPARC, version 8 (Solaris 5.8), 9, 10, 11 and higher

      Windows (32- and 64-bit)

      • Windows (x86), version 7, 8.1, 10 and higher
      • Windows Server (x86), version 2008, 2012, 2016, 2019 and higher

      Driver/Client Software Requirements

      • No Requirements

    Connect any application to any data source anywhere

    Explore all DataDirect Connectors

    A product specialist will be glad to get in touch with you

    Contact Us