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.
- 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))
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.
- 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)
- 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
- The default OpenSSL library version has been updated to 1.0.2h.*
- 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 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.12
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
- 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)
- Apache Hadoop Hive
- Cloudera’s Distribution Including Apache Hadoop (CDH)
- MapR Distribution for Apache Hadoop
- 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