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

Certifications
  • Certified with Red Hat Enterprise 7.3* (driver version 08.00.0102 (B0257, U0172))
  • Certified with Cloudera (CDH) 5.11, 5.12* (driver version 08.00.0081 (B0241, U0158))
  • Certified with Windows Server 2016* (driver version 08.00.0055 (B0221, U0144))
  • 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, which addresses the following security vulnerabilities:*
    • Truncated packet could crash via OOB read (CVE-2017-3731)
    • BN_mod_exp may produce incorrect results on x86_64 (CVE-2017-3732)
    • Montgomery multiplication may produce incorrect results (CVE-2016-7055)

    Version 1.0.2k also addresses the following vulnerabilities resolved by earlier versions of the library:

    • "Missing CRL sanity check" (CVE-2016-7052)
    • "OCSP Status Request extension unbounded memory growth" (CVE-2016-6304)
    • "SWEET32 Mitigation" (CVE-2016-2183)
    • "OOB write in MDC2_Update()" (CVE-2016-6303)
    • "Malformed SHA512 ticket DoS" (CVE-2016-6302)
    • "OOB write in BN_bn2dec()" (CVE-2016-2182)
    • "OOB read in TS_OBJ_print_bio()" (CVE-2016-2180)
    • "Pointer arithmetic undefined behaviour" (CVE-2016-2177)
    • "Constant time flag not preserved in DSA signing" (CVE-2016-2178)
    • "DTLS buffered message DoS" (CVE-2016-2179)
    • "DTLS replay protection DoS" (CVE-2016-2181)
    • "Certificate message OOB reads" (CVE-2016-6306)
    • "Padding oracle in AES-NI CBC MAC check" (CVE-2016-2107)
    • "EVP_EncodeUpdate overflow" (CVE-2016-2105)
    • "EVP_EncryptUpdate overflow" (CVE-2016-2106)
    • "ASN.1 BIO excessive memory allocation" (CVE-2016-2109)
    • "EBCDIC overread" (CVE-2016-2176)
    • "missing Memory allocation success checks in doapr_outch function in
      crypto/bio/b_print.c" (CVE‐2016‐2842)
    • "Cross‐protocol attack on TLS using SSLv2 (DROWN)" (CVE‐2016‐0800)
    • "memory issues in BIO_*printf functions" (CVE‐2016‐0799)
    • "Memory leak in SRP database lookups" (CVE‐2016‐0798)
    • "Double‐free in DSA code" (CVE‐2016‐0705)
    • "Side channel attack on modular exponentiation" (CVE-2016-0702)
    • Provides stronger cryptographic assurance against the "Logjam" vulnerability (CVE‐2015‐4000)
    • "DH small subgroups" (CVE‐2016‐0701)
    • "SSLv2 doesn't block disabled ciphers" (CVE‐2015‐3197)
    • "BN_mod_exp may produce incorrect results on x86_64" (CVE‐2015‐3193)
    • "Certificate verify crash with missing PSS parameter"(CVE‐2015‐3194)
    • "X509_ATTRIBUTE memory leak" (CVE‐2015‐3195)
    For more information on the OpenSSL vulnerabilities resolved by this upgrade, refer to the corresponding OpenSSL announcements at https://www.openssl.org/news/openssl-1.0.2-notes.html.
  • 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.
  • he 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.
Changed Behavior
  • Support has been deprecated 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)
  • 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.*
  • The default OpenSSL library version has been updated to 1.0.2f.
  • The driver has been enhanced to support row-level inserts when connected to Hive 0.14 or higher.
  • The BatchMechanism connection option has been added to the driver. By setting BatchMechanism 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 ArraySize 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 AuthenticationMethod 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 KeepAlive 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 UseNativeCatalogFunctions 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 WireProtocolVersion 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 UserName 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