DataDirect Connectors Powerful Hortonworks Hive ODBC driver

hortonworks
  • Wire protocol enables easy configuration for quick launch
  • Wide support for all Hadoop versions and major Hadoop platforms on the market
  • Fully tested to ensure strength and flexibility in real-work use
Table of Contents:

    Features

    SQL Up Leveling/ Full ANSI SQL Support

    SQL up-leveling provides the capability to write a SQL statement that can be executed across multiple databases, regardless of the databases’ SQL implementation. For example, a SQL statement written against Oracle will also be interoperable with DB2.

    Encryption SSL 3.0, TLS 1.0, 1.1, 1.2 Compliant

    We keep our SSL version upto date. Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy

    Performance Tuning

    Progress DataDirect management of packet-based network communication provides unsurpassed packet transport, network round trips and data buffering optimization. (socket management). Includes performance methodology for throughput and resource utillization (CPU/memory)

    TSANet Multi-Vendor Support Channel

    We live for your next big customer. Make sure your customers are successful with 24/7 partner support and access to expertise from our engineering teams, partnerships and leading technology companies such as Microsoft, Oracle, and IBM through our TSANet multi vendor support channel.

    Day 1 Support for any new versions

    Day One Support for disruptive technologies with frequent release cycles. With this strategy - the first of its kind for any data connectivity provider - Progress DataDirect on-premises ODBC and JDBC drivers will support any new versions of supported data sources.

    Cross-platform Support

    Use one ODBC driver for all versions of SQL that works across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX .


    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.0
    (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

    Supports Apache Hive version 1.0 and higher against the following distributions:

    • Amazon Elastic MapReduce (Amazon EMR), version 4.0 and higher
    • Apache Hadoop Hive
    • 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 4.1 and higher
    • Pivotal HD Enterprise (PHD)

    Operating System Support

    AIX (32- and 64-bit)

    • AIX, version 5.3 and higher

    HP

    • HP platforms are supported by the 7.1 version of the driver. For details, see the 7.1 driver section below.

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

    • CentOS Linux x86, version 4.0 and higher
    • Debian Linux x86, version 7.0 and higher
    • Oracle Linux x86, version 4.0 and higher
    • Red Hat Enterprise Linux x86, version 4.0 and higher
    • SUSE Linux Enterprise Server Linux x86, version 10 and higher
    • Ubuntu Linux x86, version 14.04 and higher 

    Solaris

    • Solaris platforms are supported by the 7.1 version of the driver. For details, see the 7.1 driver section below.

    Windows (32- and 64-bit)

    • Windows (x86), version 7 and higher
    • Windows Server (x86), version 2003 and higher
    • Windows Vista (x86)
    • Windows XP Professional (x86), SP2 or higher

    Driver/Client Software Requirements

    • No Requirements

    Progress DataDirect Connect XE and Connect64 XE for ODBC for Apache Hive Wire Protocol Driver Version 7.1.6
    (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

    • • HiveServer1 and HiveServer2

    Hive Version Support

    Supports Apache Hive version 0.7.1 and higher against the following distributions:

    • Amazon Elastic MapReduce (Amazon EMR), version 2.1.4 and higher
    • Apache Hadoop Hive
    • Cloudera's Distribution Including Apache Hadoop (CDH), version CDH3 update 4 and higher
    • Hortonworks Distribution for Apache Hadoop, version 1.3 and higher
    • IBM BigInsights, version 3.0 and higher
    • MapR Distribution for Apache Hadoop, version 1.2 and higher
    • Pivotal HD Enterprise (PHD), version 2.0.1 and higher

    Operating System Support

    AIX (32- and 64-bit)

    • AIX, version 5.3 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 and higher
    • Debian Linux x86, version 7.0 and higher
    • Oracle Linux x86, version 4.0 and higher
    • Red Hat Enterprise Linux x86, version 4.0 and higher
    • SUSE Linux Enterprise Server Linux x86, version 10 and higher
    • Ubuntu Linux x86, version 14.04 and higher 

    Solaris (32- and 64-bit)

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

    Windows (32- and 64-bit)

    • Windows (x86), version 7 and higher
    • Windows Server (x86), version 2003 and higher
    • Windows Vista (x86)
    • Windows XP Professional (x86), SP2 or higher

    Driver/Client Software Requirements

    • No Requirements

    Documentation


    Security Vulnerability Response Policy

    Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy

    Priority* Time Guideline Version(s)
    High Risk
    (CVSS 8+ or industry equivalent)
    30 days Active (i.e. latest shipping version) and all Supported versions
    Medium Risk
    (CVSS 5-to-8 or industry equivalent)
    180 days Active (i.e. latest shipping version)
    Low Risk
    (CVSS 0-to-5 or industry equivalent)
    Next major release or best effort Active (i.e. latest shipping version)

    * Priority is established based on the current version of the Common Vulnerability Scoring System (CVSS), an open industry standard for assessing the severity of computer system security vulnerabilities. For additional information on this scoring system, refer to https://en.wikipedia.org/wiki/CVSS.


    Related Resources

    Big_Data_Framework

    IN THE SPOTLIGHT

    Boost your Hortonworks Capabilities using our Big Data Solutions

    DataDirect offers a full range of data connectivity solutions for big data frameworks such as Hadoop and Apache Spark. Expose big data sets using industry standards for SQL and REST or integrate them with traditional data sources across RDBMS to Cloud.

    Explore our Big Data Solutions

    bg-air-dci-revamp
    Hortonworks Hive Connectors are Part of Progress Data Connectivity & Integration Solutions
    icon-info-b

    DataDirect Connectors

    Connect any data source to any application

    icon-contact-us-b

    Contact Us

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