Cloudera Impala

Progress DataDirect Connect XE and Connect64 XE for ODBC for Impala Wire Protocol Driver

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

Version 7.1.6

Certifications
  • Certified with Cloudera Impala Server 3.2*
    Driver version 07.16.0366 (B0547, U0397)
  • Certified with SUSE Enterprise Server 15*
    Driver version 07.16.0341 (B0510, U0363)
  • Certified with Ubuntu Linux 18.04*
    Driver version 07.16.0341 (B0510, U0363)
  • Certified with Red Hat Enterprise 8.0*
    Driver version 07.16.0341 (B0510, U0363)
  • Certified with Red Hat Enterprise 7.3*
    Driver version 07.16.0296 (B0319, U0212)
  • Certified with Windows Server 2016*
    Driver version 07.16.0296 (B0319, U0212)
  • Certified with Debian Linux 7.11*, 8.5*
    Driver version 07.15.0261 (B0251, U0174)
  • Certified with Ubuntu Linux 14.04*, 16.04*
    Driver version 07.15.0261 (B0251, U0174)
  • 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 Cloudera Impala Server 2.2, 2.3*, 2.4*, 2.5*, 2.6*
    Driver version 07.16.0296 (B0319, U0212)
  • Certified with Apache Sentry for Impala 1.1 and higher. Sentry enables
    administrators to control access to data and metadata stored on an Hadoop
    cluster by defining user roles and permissions.
Enhancements
  • The default version of the OpenSSL library has been upgraded to version 1.1.1g, which fixes the following security vulnerabilities:*
    • Segmentation fault in SSL_check_chain (CVE-2020-1967)
    • rsaz_512_sqr overflow bug on x86_64 (CVE-2019-1551)

    Version 1.1.1g also addresses vulnerabilities resolved by earlier versions of the library. For more information on the installed library files, refer to the readme.
    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.1.1.html.

  • The drivers using base version B0649 and later have been enhanced to include timestamp in the internal packet logs by default. If you want to disable the timestamp logging in packet logs, set PacketLoggingOptions=1. The internal packet logging is not enabled by default. To enable it, set EnablePacketLogging=1.*
  • OpenSSL library 1.0.2r has been replaced with version 1.0.2u. In addition to fixing multiple new vulnerabilities, version 1.0.2u also addresses the vulnerabilities resolved by version 1.0.2r.*
    Version 1.0.2u of the OpenSSL library fixes the following security vulnerabilities:
    • x64_64 Montgomery squaring procedure used in exponentiation with 512-bit moduli (CVE-2019-1563)
    • Padding Oracle in PKCS7_dataDecode and CMS_decrypt_set1_pkey (CVE-2019-1563)
    • Compute ECC cofactors if not provided during EC_GROUP construction (CVE-2019-1547)
    • Installation paths in diverse Windows builds (CVE-2019-1552)

    Note: By default, the driver will attempt to load version 1.1.1 of the library; however, if the library cannot be loaded, the driver will fall back to version 1.0.2.

  • The Driver Manager for UNIX/Linux has been enhanced to support setting the Unicode encoding type for applications on a per connection basis. By passing a value for the SQL_ATTR_APP_UNICODE_TYPE attribute using SQLSetConnectAttr, your application can specify the encoding at connection. This allows your application to pass both UTF-8 and UTF-16 encoded strings with a single environment handle.*
    The valid values for the SQL_ATTR_APP_UNICODE_TYPE attribute are SQL_DD_CP_UTF8 and SQL_DD_CP_UTF16. The default value is SQL_DD_CP_UTF8.
    This enhancement is available in build 07.16.0398 of the driver manager.
  • The default OpenSSL library version has been updated to 1.1.1d.*
  • The new AllowedOpenSSLVersions option determines which version of the OpenSSL library file the driver uses for data encryption when multiple versions are installed with the product. For example, when specifying a value of 1.1.1 (AllowedOpenSSLVersions=1.1.1) the driver uses the 1.1.1 version of the library that is installed with the driver.*
  • The default OpenSSL library version has been updated to 1.0.2r:*
  • The default OpenSSL library version has been updated to 1.0.2n.*
  • The Batch Mechanism connection option has been added to the driver. When BatchMechanism is set to 2 (MultiRowInsert), the driver executes 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 driver has been enhanced to support SSL encryption, which can be configured using the following new connection options: Crypto Protocol Version, CrypoLibName, Encryption Method, Host Name in Certificate, Key Password, Key Store, Key Store Password, SSLLibName, Trust Store, Trust Store Password, Validate Server Certificate. SSL support was formally certified against driver version 07.16.0317 (B0386, U0249).
  • Support for Kerberos Authentication.
  • The driver has been enhanced to support the Char, Decimal, and Varchar data
    types when connected to Impala 2.0 and higher.
  • 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 following Windows platforms have reached the end of their product lifecycle and are no longer supported by the driver*:
    • Windows 8.0 (versions 8.1 and higher are still supported)
    • Windows Vista (all versions)
    • Windows XP (all versions)
    • Windows Server 2003 (all versions)
  • 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 Impala Server 1.1, 1.2, 1.3, 1.4
  • Certified with Cloudera Impala Server 2.0, 2.1

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

Version 7.1.2

Supported with the following Apache Hive versions:
  • Certified with Cloudera Impala 1.0 database server and formally certified with the following File formats and storage handlers:
    • File Formats:Parquet, Text File
    • Storage Handlers:HBase
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.
  • Provides a connection option that allows you to set a default limit for
    the number of rows returned when an ORDER BY clause is submitted. This
    provides a workaround for applications that are not compatible with
    Impala's requirement that ORDER BY clauses limit the number of rows returned.
  •  The driver provides support for the following standard SQL
    functionality:
    • Create Index, Create Table, and Create View
    • Insert, Update, and Delete
    • Drop Index and Drop Table


patch-whats-new

Read Next

What's new