Cloudera CDH Hive


Progress DataDirect for ODBC for Apache Hive Wire Protocol Driver

An asterisk (*) indicates support that was added in a hotfix or software patch subsequent to a release.

Version 8.0.1

Platform Certifications
  • Certified with Red Hat Enterprise 7.3
  • Certified with Windows Server 2016
  • Support is now generally available for the following platforms:
    • HP-UX IPF (32 and 64-bit)
    • HP-UX PA-RISC (32-bit)
    • Oracle Solaris x86 (32- and 64-bit)
    • Oracle Solaris on SPARC (32- and 64-bit)
Hive Version Certifications
  • Certified with Cloudera (CDH) 5.11, 5.12
Enhancements
  • The driver has been enhanced to support Apache ZooKeeper, including Kerberos authentication. It can be configured using the refreshed Host Name connection option and the new ZooKeeper Discovery and ZooKeeper Namespace connection options.*
  • The driver has been enhanced to support HTTP mode, which allows you to access Apache Hive data stores using HTTP/HTTPS requests. HTTP mode can be configured using the new Transport Mode and HTTP Path connection options.
  • The driver has been enhanced to support session cookie based authentication for HTTP connections. Cookie based authentication can be configured using the new Enable Cookie Authentication and Cookie Name connection options.
  • The driver has been enhanced to support HTTP connections to Apache Knox gateways.
  • The new Array Insert Size connection option provides a workaround for memory and server issues that can sometimes occur when inserting a large number of rows that contain large values.These issues are most likely to occur when connecting through Apache Knox. 
  • The driver has been updated with OpenSSL library version 1.0.2n, which addresses the following security vulnerabilities:
    • rsaz_1024_mul_avx2 overflow bug on x86_64 (CVE-2017-3738)
    • Read/write after SSL object in error state (CVE-2017-3737)
    • bn_sqrx8x_internal carry bug on x86_64 (CVE-2017-3736)
    • Malformed X.509 IPAddressFamily could cause OOB read (CVE-2017-3735)

    Version 1.0.2n also addresses the following vulnerabilities resolved by earlier versions of the library.

    For more information on the OpenSSL vulnerabilities resolved by this upgrade, refer to the corresponding OpenSSL announcements at https://www.openssl.org/news/vulnerabilities-1.0.2.html.
Changed Behavior
  • The Array Size (ArraySize) connection option has been renamed Array Fetch Size (ArrayFetchSize). The ArraySize attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.

Version 8.0.0

Certifications
  • Certified with Debian Linux 7.11, 8.5 (driver version 07.16.0375 (B0302, U0201))
  • Certified with Ubuntu Linux 14.04, 16.04 (driver version 07.16.0375 (B0302, U0201))
  • Certified with Apache Hive 2.0, 2.1 (driver version 07.16.0384 (B0337, U0221))
  • Certified with Cloudera (CDH) 5.4, 5.5, 5.6, 5.7, 5.8, 5.9, 5.10
Enhancements
  • The driver has been updated with OpenSSL library version 1.0.2k.*
    Note: OpenSSL library 1.0.2k has been replaced with version 1.0.2n.
  • The driver has been enhanced to optimize the performance of fetches.
  • The new Min Long Varchar Size connection option allows you to fetch SQL_LONGVARCHAR columns whose size is smaller than the minimum imposed by some third-party applications, such as SQL Server Linked Server.
  • The new Varchar Threshold connection option allows you to fetch columns that would otherwise exceed the upper limit of the SQL_VARCHAR type for some third-party applications, such as SQL Server Linked Server.
  • The new Max String Size connection option allows you to determine the maximum size of columns of the String data type that the driver describes through result set descriptions and catalog functions. This option replaces the Max Varchar Size connection option.
  • The new Catalog Mode connection option allows you to determine whether the driver uses native catalog functions to retrieve information returned by the SQLTables, SQLColumns, and SQLStatistics catalog functions. In the default setting, the driver employs a balance of native functions and driver-discovered information for the optimal balance of performance and accuracy when retrieving catalog information. This option replaces the Use Native Catalog Functions option.
  • The driver includes a new Tableau data source file (Windows only) that provides improved functionality when accessing your data with Tableau.
  • The driver and Driver Manager have been enhanced to support UTF-8 encoding in the odbc.ini and odbcinst.ini files.
  • The default OpenSSL library version has been updated to 1.0.2j.
    Note: OpenSSL library 1.0.2j has been replaced with version 1.0.2n.
Changed Behavior
  • The driver supports Hive versions 1.0 and higher. Support has been deprecated for earlier versions of Hive.
  • Support has been deprecated for the following distributions:
    • Cloudera's Distribution Including Apache Hadoop (CDH) 4.0, 4.1, 4.2, 4.5, 5.0, 5.1, 5.2, 5.3
  • The driver supports the HiveServer2 protocol and higher, and as a result:
    • Support for the HiveServer1 protocol has been deprecated
    • The Wire Protocol Version connection option has been deprecated
  • The Use Native Catalog Functions connection option has been replaced by the new Catalog Mode connection option. The UseNativeCatalogFunctions attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Max Varchar Size connection option has been replaced by the new Max String Size connection option. The MaxVarcharSize attribute will continue to be supported for this release, but will be deprecated in subsequent versions of the product.
  • The Authentication Method connection option has been refreshed with a new valid value for enabling Kerberos Authentication. To use Kerberos authentication with the driver, set AuthenticationMethod=4.
  • The default value for Crypto Protocol Version has been updated to TLSv1.2,TLSv1.1,TLSv1. This change improves the security of the driver by employing only the most secure cryptographic protocols as the default behavior.
  • The valid and default values for the String Describe Type connection have been updated:
    • Valid values: -10 (SQL_WLONGVARCHAR) | -9 (SQL_WVARCHAR)
    • Default value: -9 (SQL_WVARCHAR)

Version 7.1.6

Certifications
  • Certified with Windows 10
  • Certified with Red Hat Enterprise 7.1
  • Certified with CentOS Linux 7.1
  • Certified with Oracle Linux 7.1
  • Certified with SUSE Enterprise Server 12
  • Certified with Hive 1.0, 1.1, 1.2
  • Certified with Cloudera (CDH) 5.3, 5.4
Enhancements
  • The default OpenSSL library version has been updated to 1.0.2g.*
    Note: OpenSSL library 1.0.2g has been replaced with version 1.0.2n.
  • The default OpenSSL library version has been updated to 1.0.2f.
    Note: OpenSSL library 1.0.2f has been replaced with version 1.0.2n.
  • The driver has been enhanced to support row-level inserts when connected to Hive 0.14 or higher.
  • The Batch Mechanism connection option has been added to the driver. By setting Batch Mechanism to 2 (MultiRowInsert), you enable the driver to use a parameterized multi-row insert statement to execute batch inserts. MultiRowInsert is the default setting and provides substantial performance gains when performing batch inserts.
  • The new CryptoLibName and SSLLibName connection options allow you to 
     designate the OpenSSL libraries used when SSL is enabled.
  • The driver has been enhanced to support SSL encryption.
  • The Array Size connection option has been refreshed to allow specifying  the number of cells retrieved instead of rows. By determining the fetch size based on the number of cells, the driver can avoid out of memory errors when fetching from tables containing a large number of columns. 
Changed Behavior
  • The Authentication Method connection option has been refreshed with a new valid value for enabling Kerberos Authentication. To use Kerberos  authentication with the driver, set AuthenticationMethod=4.

Version 7.1.5

Certifications
  • Certified with Red Hat Enterprise 7.0
  • Certified with CentOS Linux 7.0
  • Certified with Oracle Linux 7.0
  • Certified with Cloudera (CDH) 5.2
  • Certified with Hive 0.13, 0.14
  • Certified with Apache Hive Sentry, which enables HiveServer2 administrators
    to enforce role‐based authorization for Apache Hadoop clusters.
Enhancements
  • The driver has been enhanced to support the Char data type
    when connected to Hive 0.13 and higher.
  • The driver has been enhanced to support the Decimal data type
    when connected to Hive 0.11 and higher.
  • The driver has been enhanced to support the Date and Varchar data types
    in Hive 0.12 and higher.

Version 7.1.4

Certifications
  • Certified with Windows 8.1
Enhancements
  • The new TCP Keep Alive connection option allows you to use TCP Keep Alive to maintain idle TCP connections.

Version 7.1.3

Certifications
  • Certified with CentOS Linux 4.x, 5.x, and 6.x
  • Certified with Oracle Linux 4.x, 5.x, and 6.x
  • Certified with Hive 0.11, 0.12
  • Certified with Cloudera 4.2, 4.5
Enhancements
  • The Use Native Catalog Functions connection option allows you to use native
    catalog functions to retrieve information returned by SQLTables, SQLColumns,
    and SQLStatistics catalog functions.
  • Support for Kerberos Authentication.

Version 7.1.2

Certifications
  • Certified with Oracle Solaris 11.1

Version 7.1.1

Certifications
  • Certified with Red Hat 6.3
  • Certified with Windows 8 and Windows Server 2012
  • Certified with Hive 0.10
  • Certified with Cloudera 4.1
Enhancements
  • Added support for HiveServer2.
  • When connected to HiveServer2, simultaneous connections per port
    are supported.
  • The new Wire Protocol Version connection option specifies the
    version of the Hive Server to which the driver will connect.
  • The String Describe Type connection option now allows you to describe
    string columns as SQL_WLONGVARCHAR or SQL_WVARCHAR.
Changed Behavior 
  • The Password connection attribute is now required for a connection
    to HiveServer2.
  • The User Name connection attribute is now required for a connection
    to HiveServer2.

Version 7.1.0

Certifications
  • Cloudera’s Distribution Including Apache Hadoop (CDH)
Features
  • Returns result set metadata for parameterized statements
    that have been prepared but not yet executed.
  • Supports parameter arrays, processing the arrays as a series of
    executions, one execution for each row in the array.
  • Provides a connection option that allows you to configure
    the driver to report that it supports transactions, although Hive does not support transactions. This provides a workaround for applications that do not operate with a driver that reports transactions are not supported.
  •  The driver provides support for the following standard SQL
    functionality:
    • Create Index, Create Table, and Create View
    • Insert
    • Drop Index, Drop Table, and Drop View

patch-whats-new

Read Next

What's new