Progress DataDirect Connect XE and Connect64 XE 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.
- 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.0, 1.1.0, 1.2.0
The drivers have been updated with OpenSSL library version 1.0.2h, which addresses the following security vulnerabilities*:
- "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)
Version 1.0.2h also addresses the following vulnerabilities resolved by earlier versions of the library.
Originally resolved by the version 1.0.2g upgrade:
- "missing Memory allocation success checks in doapr_outch function in
- "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)
Originally resolved by the version 1.0.2.f upgrade:
For more information on the OpenSSL vulnerabilities resolved by this upgrade,
refer to the corresponding OpenSSL announcements at
- 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)
- 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.
- 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.
- Certified with Red Hat Enterprise 7.0
- Certified with CentOS Linux 7.0
- Certified with Oracle Linux 7.0
- Certified with Amazon (AMI) 3.2‐3.3.1
- 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.
- 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.
- Certified with Windows 8.1
The new KeepAlive connection option allows you to
use TCP Keep Alive to maintain idle TCP connections.
- 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, 0.12.0
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.
- Certified with Oracle Solaris 11.1
- Certified with Red Hat 6.3
- Certified with Windows 8 and Windows Server 2012
- Certified with Hive 0.10.0
- Added support for HiveServer2.
- When connected to HiveServer2, simultaneous connections per port
- 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.
- The Password connection attribute is now required for a connection
- The UserName connection attribute is now required for a connection
- Amazon Elastic MapReduce (Amazon EMR)
- 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
- Create Index, Create Table, and Create View
- Drop Index, Drop Table, and Drop View