5 IMPALA

============================================================================== Simba Impala ODBC Driver with SQL Connector Release Notes ==============================================================================

The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Impala ODBC Driver 2.6.11, as well as the version history.

For information about upcoming support deprecations or removals, see the Workflow Changes section. Deprecated features will not receive any updates, but will continue to be usable in their current state until support is removed in a future release.

2.6.11 =======================================================================

Released 2020-06-30

Enhancements & New Features

  • [IMP-659] Support for DML result set count

    The driver now reports the correct row count for DML results in server versions that return the correct row count information. Previously, the driver returned “-1”.

  • [IMP-783] Server-side properties configuration

    You can now configure server-side properties as driver-wide properties via the registry or the .impalaodbc.ini file.

Resolved Issues The following issues have been resolved in Cloudera ODBC Driver for Impala 2.6.11.

  • [IMP-662] When an incorrect user ID or password is entered in SASL, the driver returns the error message “Error from the Impala Thrift API: No more data to read.”

    This issue has been resolved. The driver now returns a more detailed error message.

  • [IMP-691] The driver returns string data untruncated regardless of the value that the string column length is set to.

    This issue has been resolved. The driver now truncates the string data in the result set if the data exceeds the column length.

  • [IMP-789] The driver imposes a minimum (255) and maximum (32,767) character length for the StringColumnLength connection property.

    This issue has been resolved. The minimum limit has been set to 1 and values larger than 32,767 can now be set.

Known Issues The following are known issues that you may encounter due to limitations in the data source, the driver, or an application.

  • Limited support for BINARY, DATE, and TIME data types

    • BINARY is not a supported data type in Impala.
    • DATE is supported only when you connect to Impala version 3.3 or later.
    • As a result of the limitations above, some values of TIME data types are also not supported.

Workflow Changes =============================================================

The following changes may disrupt established workflows for the driver.

In addition to changes that are already implemented in the current version of the driver, this section describes potentially disruptive changes that will be implemented in a future version of the driver, so that you can plan accordingly.

Upcoming ———————————————————————

  • [IMP-713][IMP-717] Removing support for earlier versions of Windows

    As early as June 2020, the driver will no longer support the following versions of Windows:

    • Windows 7
    • Windows Server 2008
    • Windows Server 2008r2

    In addition, as early as June 2020, the driver will no longer support Visual Studio 2013.

    For a list of supported Windows and Visual Studio versions, see the Installation and Configuration Guide.

  • [IMP-728] Removing support for macOS 10.12 and earlier

    As early as June 2020, the driver will no longer support the following versions of macOS:

    • macOS 10.12 “Sierra”
    • macOS 10.11 “El Capitan”
    • macOS 10.10 “Yosemite”
    • macOS 10.9 “Mavericks”

    For a list of supported macOS versions, see the Installation and Configuration Guide.

  • [IMP-732] Removing support for CentOS 6 and RHEL 6

    As early as June 2020, the driver will no longer support CentOS 6 or Red Hat Enterprise Linux (RHEL) 6.

    For a list of supported Linux versions, see the Installation and Configuration Guide.

2.6.10 ———————————————————————–

  • [IMP-680] Removed support for Impala 2.7

    Beginning with this release, the driver no longer supports Impala 2.7. For a list of supported versions, see the Installation and Configuration Guide.

  • [IMP-713][IMP-717] Deprecated support for earlier versions of Windows

    Beginning with this release, support for the following versions of Windows has been deprecated:

    • Windows 7
    • Windows Server 2008
    • Windows Server 2008r2

    In addition, beginning with this release, support for Visual Studio 2013 has been deprecated.

    Support will be removed in a future release. For a list of supported Windows and Visual Studio versions, see the Installation and Configuration Guide.

  • [IMP-728] Deprecated support for earlier versions of macOS

    Beginning with this release, support for the following versions of macOS has been deprecated:

    • macOS 10.12 “Sierra”
    • macOS 10.11 “El Capitan”
    • macOS 10.10 “Yosemite”
    • macOS 10.9 “Mavericks”

    Support will be removed in a future release. For a list of supported macOS versions, see the Installation and Configuration Guide.

  • [IMP-732] Deprecated support for CentOS 6 and RHEL 6

    Beginning with this release, support for CentOS 6 or Red Hat Enterprise Linux (RHEL) 6 has been deprecated.

    Support will be removed in a future release. For a list of supported Linux versions, see the Installation and Configuration Guide.

2.6.8 ————————————————————————

  • [IMP-680] Removed support for Impala 1.0.1 to 2.6

    Beginning with this release, the driver no longer supports Impala 1.0.1 to 2.6. For a list of supported versions, see the Installation and Configuration Guide.

2.6.0 ————————————————————————

  • Minimum TLS Version

    Beginning with this release, the driver requires a minimum version of TLS for encrypting the data store connection. By default, the driver requires TLS version 1.2. This requirement may cause existing DSNs and connection strings to stop working, if they are used to connect to data stores that use a TLS version earlier than 1.2.

    To resolve this, in your DSN or connection string, set the Minimum TLS option (the Min_TLS property) to the appropriate version of TLS for your server. For more information, see the Installation and Configuration Guide.

Version History ==============================================================

2.6.10 ———————————————————————–

Released 2020-03-27

Enhancements & New Features

  • [IMP-656] Updated default value for DisableOptimizedEncodingConverter

    The DisableOptimizedEncodingConvert property is now set to false by default. For more information, see the Installation and Configuration Guide.

  • [IMP-752] Support for notarization

    The driver now supports notarization on macOS systems, enabling it to be run on macOS versions 10.14.6 and later.

  • [IMP-769] Updated boost library on AIX

    The AIX version of the driver now uses boost version 1.59.0. Previously, the AIX version of the driver used version 1.55.0.

2.6.9 ————————————————————————

Released 2020-01-24

Enhancements & New Features

  • [IMP-704] Improved performance with multiple concurrent connections

    The driver now retrieves data much faster in scenarios that involve multiple concurrent connections to the data store. This improves performance when working with applications such as Power BI.

  • [IMP-696][IMP-708][IMP-722] Updated third-party libraries

    The driver has been updated to use the following libraries:

    • Boost 1.64.0 (previously 1.57.0)
    • libcurl 7.66.0 (previously 7.60.0)
    • Expat 2.2.9 (previously 2.2.0)
    • OpenSSL 1.1.1d (previously 1.1.0j)

Resolved Issues The following issues have been resolved in Simba Impala ODBC Driver 2.6.9.

  • [IMP-699] In some cases, when the driver submits a query that contains a Boolean value expression, the driver returns an “Unsupported query” error.

  • [IMP-724] The driver terminates unexpectedly when both of the following occur:

    • Multiple database drivers are loaded to the same process.
    • One driver unloads and calls ICU’s u_cleanup() function, while another driver continues to run and tries to access the memory space that has been cleaned up.

2.6.8 ————————————————————————

Released 2019-09-27

Enhancements & New Features

  • [IMP-680] Updated Impala support

    The driver now supports Impala versions 2.7 to 3.3.

  • [IMP-688] Updated support for Debian installation

    The Linux driver now includes installation packages specific to Debian systems. For more information, see the Installation and Configuration Guide.

  • [IMP-666] Support for DATE data type

    The driver now supports the DATE data type for Impala version 3.3 and later. For more information, see “Data Types” in the Installation and Configuration Guide.

Resolved Issues The following issues have been resolved in Simba Impala ODBC Driver 2.6.8.

  • [IMP-686] When an AnalysisException error occurs, the driver incorrectly classifies it as a syntax error and returns SQLState 42000.

  • [IMP-687] After SQLFetch returns an error, if you attempt to call SQLFetch again, the driver terminates unexpectedly.

2.6.7 ————————————————————————

Released 2019-08-23

Enhancements & New Features

  • [IMP-678] Reporting the maximum length of database fields

    You can now specify the maximum character length that the driver reports for the names of catalogs, columns, schemas, and tables. To do this, set the following connection properties:

    • MaxCatalogNameLen
    • MaxColumnNameLen
    • MaxSchemaNameLen
    • MaxTableNameLen

    For more information, see the Installation and Configuration Guide.

  • [IMP-634] Thrift transport modes

    The driver now enables you to specify the Thrift transport mode used. You can configure the driver to use binary, HTTP, or SASL transport. For more information, see the Installation and Configuration Guide.

  • [IMP-668] Updated driver version information in Linux binary

    You can now check the Linux driver’s version from the driver binary file. To do this, open the .so file in a text editor, and search for the text “\(driver_version_sb\):”. The driver’s version number is listed after this text.

  • [IMP-677] New name for Enable Simulated Transactions

    The configuration option Enable Simulated Transactions (key name EnableSimulatedTransactions) has been renamed to Ignore Transactions (key name IgnoreTransactions). The previous key name continues to be supported for backwards compatibility.

  • [IMP-671] Updated third-party library linking for Linux

    In the Linux driver, minor internal improvements have been implemented for the linking between the third-party libraries and the main driver library.

  • [IMP-645] Internal driver improvements

    The driver has been updated with minor internal improvements.

Resolved Issues The following issues have been resolved in Simba Impala ODBC Driver 2.6.7.

  • [IMP-672] When the driver sets the SQLSetConnectAttr attribute SQL_ATTR_AUTOCOMMIT to SQL_AUTOCOMMIT_OFF, it terminates unexpectedly.

  • [IMP-647] When the driver executes a dynamic or parameterized query with OFFSET, it returns an error.

    This issue has been resolved. The driver now properly supports LIMIT x,y query syntax.

  • [IMP-654] When query retry is enabled, the driver does not retry queries when a transport or communication link failure occurs.

  • [IMP-660] When you insert a negative value into a TINYINT column, the driver returns an error.

  • [IMP-664] When the driver prepares a query that includes a STRING column cast to a variable-length VARCHAR, a length of 32767 is always returned.

  • [IMP-670] When retrieving a DECIMAL value that contains an integer ending with 0, the driver erroneously returns SQL_SUCCESS_WITH_INFO and a truncation error.

2.6.6 ————————————————————————

Released 2019-05-17

Enhancements & New Features

  • [IMP-639] Updated default value for DisableOptimizedEncodingConverter

    The DisableOptimizedEncodingConvert property is now set to true by default. This enables the driver to read and replace invalid UTF-8 characters.

2.6.5 ————————————————————————

Released 2019-05-10

Enhancements & New Features

  • [IMP-573] unixODBC support on macOS

    On macOS, you can now use the driver with version 2.3.1 of the unixODBC driver manager.

  • [IMP-628] Updated OpenSSL support

    The driver now uses OpenSSL 1.1.0j.

  • [IMP-609] Updated Impala support

    The driver now supports Impala versions 1.0.1 through 3.1.

Resolved Issues The following issues have been resolved in Simba Impala ODBC Driver 2.6.5.

  • [IMP-623] In some cases, queries with a parameterized INSERT clauses fail.

  • [IMP-629] The driver does not handle the scale and precision of DECIMAL data correctly.

  • [IMP-612] The driver does not pass a UID into the session when connected using No Authentication.

  • [IMP-631] When inserting CHAR or VARCHAR values, the driver incorrectly translates those values to CAST(CAST(…)).

    This issue is resolved. The driver now translates these values to a single CAST.

2.6.4 ————————————————————————

Released 2019-03-08

Enhancements & New Features

  • [IMP-601] SERVER as alias for HOST

    The driver now supports the use of SERVER as an alias for the HOST configuration option. The configuration option HOST is still supported.

  • [IMP-607] Updated RapidJSON parser

    The driver has been updated to use version 1.1.0 of the RapidJSON parser.

Resolved Issues The following issue has been resolved in Simba Impala ODBC Driver 2.6.4.

  • [IMP-603] In some queries that include aliases in subqueries, the driver translates the query to a syntax that is not supported by Impala CDH6.

2.6.3 ————————————————————————

Released 2019-02-08

Enhancements & New Features

  • [IMP-567] Impala 3.0 support

    The driver now supports Apache Impala 1.0.1 through 3.0. Previously the driver supported Apache Impala 1.0.1 through 2.12.

  • [IMP-569] Oracle Linux support

    The driver now supports Oracle Linux RHCK and UEK 7.5.

  • [IMP-580] Support for driver-wide configuration on Windows

    On Windows, the driver can now read driver-wide configuration settings from the .impalaodbc.ini file. This file must be present in the subfolder inside the driver installation directory.

  • [IMP-592] Support for invalid UTF-8 characters

    The driver can now read and replace invalid characters in UTF-8 data. To do this, set the DisableOptimizedEncodingConverter option to “true”. For more information, see the Installation and Configuration Guide.

  • [IMP-589] Dynamically linked third-party libraries

    The Linux driver has been updated to use dynamically linked libraries for ICU and OpenSSL. The installation directory now includes a “ThirdParty” directory which contains all required runtime libraries for the driver.

  • [IMP-566] Updated ICU library

    The driver has been updated to use version 58.2 of the ICU library.

Resolved Issues The following issues have been resolved in Simba Impala ODBC Driver 2.6.3.

  • [IMP-570] When the driver is installed on a machine that uses Turkish locale settings, if you try to connect using a connection string where one or more of the property names contains a lower-case “i” character, the driver does not connect to the server.

  • [IMP-581] If the comments for a table are longer than 256 characters, the driver returns the following error: (20030) Memory management error.

  • [IMP-583] In some cases when the Use SQL Unicode Types property is disabled, after SQL_PREPARE the driver incorrectly returns SQL_WCHAR and SQL_WVARCHAR for SQL_CHAR and SQL_VARCHAR.

2.6.2 ————————————————————————

Released 2018-11-23

Resolved Issues The following issue has been resolved in Simba Impala ODBC Driver 2.6.2.

  • [IMP-565] The driver reports transport-related errors using the generic error code 10000, instead of reporting them more specifically using error code 08S01.

2.6.1 ————————————————————————

Released 2018-10-05

Enhancements & New Features

  • [IMP-474] Support for native scalar functions

    The driver now defaults to using native Impala scalar functions, provided that those functions are supported by the Impala server.

  • [IMP-550] More informative Port value error messages

    The driver now provides more detailed error messages when an invalid value is specified for the Port connection property.

  • [IMP-576] Updated OpenSSL version

    The driver now uses OpenSSL version 1.1.0i. Previously, the driver used OpenSSL version 1.1.0h.

Resolved Issues The following issues were resolved in Simba Impala ODBC Driver 2.6.1.

  • [IMP-553] The driver translates Winsock error 10053 into generic error

    This issue has been resolved. The drive now translates the Winsock error into error 08S01.

  • [IMP-475] The driver treats strings with the literal value “NULL” as NULL values.

  • [IMP-552] The driver does not honor the SQL_ATTR_LOGIN_TIME attribute when connecting, which may cause the driver to behave unexpectedly.

==============================================================================