5 IMPALA
============================================================================== Magnitude Simba Impala ODBC Data Connector Release Notes ==============================================================================
The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Impala ODBC Connector 2.6.13, 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.13 =======================================================================
Released 2021-02-26
Enhancements & New Features
- [IMP-805] New authentication method
You can now authenticate your connection using SAML 2.0. For more information, see the Installation and Configuration Guide.
- [IMP-782] Updated authentication mechanism support
The AuthMech property now uses the name of the authentication mechanism instead of the corresponding numbers. The following are the supported authentication mechanisms: - No Authentication - Kerberos - SASL User Name - User Name and Password - SAML_2.0
The connector continues to recognize the corresponding numbers (0, 1, 2, and 3) for backwards compatibility. For more information, see the Installation and Configuration Guide.
Resolved Issues The following issue has been resolved in Simba Impala ODBC Connector 2.6.13.
- [IMP-846] When HTTP is enabled and two API calls with a time lag between them are made, the server resets the connection and the connector returns an error.
Known Issues The following are known issues that you may encounter due to limitations in the data source, the connector, or an application.
- [IMP-843] Limited support for query translation
The connector does not support query translation if the query contains the "LIMIT x OFFSET y" syntax.
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 connector.
In addition to changes that are already implemented in the current version of the connector, this section describes potentially disruptive changes that will be implemented in a future version of the connector, so that you can plan accordingly.
Upcoming ---------------------------------------------------------------------
- [IMP-717] Removing support for Visual Studio 2013
As early as March 2021, the connector will no longer support Visual Studio 2013. For a list of supported Visual Studio versions, see the Installation and Configuration Guide.
2.6.12 -----------------------------------------------------------------------
- [IMP-823] Removed support for earlier versions of AIX
Beginning with this release, the driver no longer supports AIX versions 5.2 through 6.1. For a list of supported AIX versions, see the Installation and Configuration Guide.
- [IMP-713][IMP-715] Removed support for earlier versions of Windows
Beginning with this release, the driver no longer supports the following versions of Windows: - Windows 7 - Windows Server 2008 - Windows Server 2008r2
For a list of supported Windows versions, see the Installation and Configuration Guide.
- [IMP-728][IMP-730] Removed support for earlier versions of macOS
Beginning with this release, the driver no longer supports 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][IMP-744][IMP-816][IMP-818][IMP-833] Removed support for earlier versions of Linux distributions
Beginning with this release, the driver no longer supports the following versions of Linux distributions: - CentOS 6 - Debian 6 and 7 - RHEL 6 - Ubuntu 14.04 - SLES 11
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.12 -----------------------------------------------------------------------
Released 2020-12-23
Enhancements & New Features
- [IMP-782] Updated support for the HTTP transport mode
When using the HTTP transport mode, the driver now retries idempotent API calls to the server.
- [IMP-801] Updated logging configurations
The logging configurations for a particular connection can now be passed in via the connection string or DSN.
- [IMP-802] Updated OpenSSL support
The driver now uses OpenSSL 1.1.1g. Previously, the driver used OpenSSL 1.1.1d.
- [IMP-780][IMP-819][IMP-821][IMP-825][IMP-827][IMP-835] Updated platform support
The driver now supports the following platform versions: - Windows Server 2019 - macOS 10.15 - AIX 7.2 - Ubuntu 18.04 and 20.04 - SLES 15 - Debian 8 and 9
For a list of supported platform versions, see the Installation and Configuration Guide.
Resolved Issues The following issue has been resolved in Cloudera ODBC Driver for Impala 2.6.12.
- [IMP-806] When the server returns 0 rows, the driver stops fetching results.
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.
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
- [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.
==============================================================================