Amazon EMR Hive

Progress DataDirect Connect XE for JDBC for Apache Hive

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

Version 6.0.0

Certifications
  • Certified with Apache Hive 2.0, 2.1
    Driver version 5.1.4.000134 (F000295.U000128) 
Enhancements
  • The driver has been enhanced to optimize the performance of fetches.
  • The driver has been enhanced to support the Char, Date, Decimal, and Varchar data types.
  • 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 TransportMode and HTTPPath connection properties.
  • The driver has been enhanced to support cookie based authentication for HTTP connections. Cookie based authentication can be configured using the new EnableCookieAuthentication and CookieName connection properties.
  • The driver has been enhanced to support Apache Knox.
  • The driver has been enhanced to support Impersonation and Trusted Impersonation using the new ImpersonateUser property.
  • The BatchMechanism connection property has been added to the driver. By setting BatchMechanism to multiRowInsert, you enable the driver to execute a single insert for all the rows contained in a parameter array. MultiRowInsert is the default setting and provides substantial performance gains when performing batch inserts.
  • The new CatalogMode connection property allows you to determine whether the driver uses native catalog functions to retrieve information returned by DatabaseMetaData 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.
  • The new ArrayFetchSize connection property improves performance and reduces out of memory errors. ArrayFetchSize can be used to increase throughput or, alternately, improve response time in Web-based applications.
  • The driver has been enhanced to support SSL for Apache Hive 0.13.0 and higher, incorporating the addition of nine new connection properties.*
  • The driver's Kerberos functionality has been enhanced to support SASL-QOP data integrity and confidentiality.
  • Support for row-level inserts has been added to the driver.
  • The driver has been enhanced to support the Char, Decimal, Date, and Varchar data types.
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:
    • Amazon Elastic MapReduce (Amazon EMR) 2.1.4, 2.24-3.1.4 , 3.2-3.3.1, 3.2-3.7
  • The driver supports the HiveServer2 protocol and higher, and as a result:
    • Support for the HiveServer1 protocol has been deprecated
    • The WireProtocolVersion connection property has been deprecated
  • Added the RegisterStatementPoolMonitorMBean connection property. Note that the
    driver no longer registers the Statement Pool Monitor as a JMX MBean by default.
    You must set RegisterStatementPoolMonitorMBean to true to register the Statement Pool Monitor and manage statement pooling with standard JMX API calls.

Version 5.1.4

Certifications
  • Certified with Apache Hive 1.0, 1.1, and 1.2*
  • Certified with Apache Hive 0.13 and 0.14
  • Certified with the following Amazon EMR distributions:
    • Amazon AMI 3.7*
    • Amazon AMI 3.2-3.3.1
Enhancements
  • Support for row-level inserts has been added to the driver.

Version 5.1.2

Certifications
  • Certified with Apache Hive 0.10, 0.11, and 0.12
  • Certified with the following Amazon EMR distributions:
    • Amazon AMI 2.2.4-3.1.4
Enhancements
  • The driver has been enhanced to support the Kerberos authentication protocol with the addition of the AuthenticationMethod and ServicePrincipalName connection properties.

Version 5.1.1

GA Release Features
  • Support for Apache Hive 0.8 and higher
  • Support for Amazon EMR
  • Returns result set metadata for parameterized statements that have been prepared but not yet executed
  • Supports connection pooling
  • Includes the LoginTimeout connection property which allows you to specify the amount of time the driver waits for a connection to be established before timing out the connection request
  • Includes the TransactionMode connection property which allows you to configure the driver to report that it supports transactions, even though Hive does not support transactions. This provides a workaround for applications which do not operate with a driver that reports transactions are not supported.
  • The driver provides support for the following standard SQL functionality:
    • Create Table and Create View
    • Insert
    • Drop Table and Drop View
    • Batches in HiveServer2 connections
GA Release Certifications
  • Certified with Apache Hive 0.8 and 0.9
  • Certified with the following Amazon EMR distribution:
    • Amazon AMI 2.1.4



patch-whats-new

Read Next

What's new