4 HIVE

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

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

2.6.9 ========================================================================

Released 2020-07-17

Enhancements & New Features

  • [HAR-1156] Updated HiveServer2 connection

The driver now supports the Active Passive HS2 Interactive HA mode. For more information, see the Installation and Configuration Guide.

  • [HAR-1080] macOS X notarization

The driver now supports notarization on macOS versions 10.14.6 and later.

  • [HAR-1081] Code sign support

The Windows and macOS versions of the driver are now code-signed.

  • [HAR-1135] Upgraded boost library version

On AIX, the driver now uses boost version 1.59.0. Previously, on AIX, the driver used boost version 1.55.0.

  • [HAR-1139] Upgraded libcurl version

The driver now uses libcurl version 7.66.0. Previously, the driver used libcurl version 7.60.0.

  • [HAR-1146] Updated Windows Server support

The driver now supports Windows Server 2019.

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

  • [HAR-986] In some cases, the driver delivers ambiguous SSL-related error messages.

  • [HAR-1053] On AIX, when using a different OpenSSL version, the driver terminates unexpectedly.

  • [HAR-1158] When the SQLBindCol property is called with a NULL pointer, the driver throws an error.

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

  • On Hive 3.0 and later, when the server does not set the metastore schema reader properly, the driver returns the following error:

Error from server: error code: '0' error message: 'MetaException(message:java.lang.UnsupportedOperationException: Storage schema reading not supported)'

To resolve this issue, set the following in the Hive server: metastore.storage.schema.reader.impl=org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader

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

The following changes may disrupt established workflows for the driver.

2.6.9 ------------------------------------------------------------------------

  • [HAR-1061][HAR-1086][HAR-1088]Deprecated support for OS platforms

Beginning with this release, support will be deprecated for the following OS platforms: - Windows 7 - Windows Server 2008 and 2008 r2 - OS X 10.9, 10.10, 10.11, and 10.12 - CentOS 6 / RHEL 6

Support will be dropped at least three months after this release.

  • Removing support for Visual C++ Redistributable for Visual Studio 2013

As early as April 2020, the driver will no longer support this version of the dependency and will require Visual C++ Redistributable for Visual Studio 2015 instead. For information about the supported Visual C++ Redistributable for Visual Studio versions, see the Installation and Configuration Guide.

2.6.8 ------------------------------------------------------------------------

  • Removed support for Apache Hive versions earlier than 1.0.0

Beginning with this release, the driver no longer supports Apache Hive versions earlier than 1.0.0. For a list of supported Apache Hive 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.8 ------------------------------------------------------------------------

Released 2020-01-24

Enhancements & New Features

  • [HAR-1043][HAR-1048][HAR-1056][HAR-1083] 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 Hive ODBC Driver 2.6.8.

  • [HAR-1045] In some cases, when attempting to continue an interrupted fetch operation after losing contact with the server, the driver might return result sets with missing rows.

This issue has been resolved. If the server supports FETCH_FIRST or FETCH_PRIOR fetch orientations, the driver now correctly resumes fetch operations after reconnecting to the server. If FETCH_FIRST or FETCH_PRIOR is not supported and the driver is unable to continue a fetch operation, it returns an error.

  • [HAR-1046] In some cases, when there is a connection issue during OpenSession calls to the server, the driver terminates unexpectedly.

  • [HAR-1066] 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.

  • [HAR-1123] On Windows, if the GSSAPI MIT Kerberos library is present in the environment, the driver cannot be configured to use Active Directory
    Kerberos via SSPI in HTTP mode.

2.6.7 ------------------------------------------------------------------------

Released 2019-09-27

Enhancements & New Features

  • [HAR-1036] Updated Debian installation package

The file names of the Debian installation package and its contents have been updated for consistency.

Resolved Issues The following issue has been resolved in Simba Hive ODBC Driver 2.6.7.

  • [HAR-990] If a scalar function has an escape sequence that contains comparisons to literal values, the driver fails to run the query and returns an error.

2.6.6 ------------------------------------------------------------------------

Released 2019-08-16

Enhancements & New Features

  • [HAR-1024] 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.

  • [HAR-1029] 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.

  • [HAR-1002] Internal driver improvements

The driver has been updated with minor internal improvements.

Resolved Issues The following issues was resolved in Simba Hive ODBC Driver 2.6.7.

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

  • [HAR-1023] In some cases, when calling SQLBindCol on every row in a table, driver performance is lower than expected.

2.6.5 ------------------------------------------------------------------------

Released 2019-05-17

Enhancements & New Features

  • [HAR-928] Support for Oracle Linux

The driver now supports Oracle Linux 7.5 and 7.6.

  • [HAR-966] Updated zlib version

The driver now uses zlib version 1.2.11. Previously, the driver used zlib version 1.2.8.

  • [HAR-985] unixODBC support on macOS

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

  • [HAR-994] Updated OpenSSL version

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

Resolved Issues The following issue was resolved in Simba Hive ODBC Driver 2.6.5.

  • [HAR-989] The driver does not correctly handle LIMIT x,y syntax.

2.6.4 ------------------------------------------------------------------------

Released 2019-03-15

Enhancements & New Features

  • [HAR-921] Cookie-based authentication

The driver now supports cookie-based authentication as part of the authentication process. To do this, set the HTTPAuthCookies configuration option to a list of authentication cookies. For more information, see the Installation and Configuration Guide.

  • [HAR-965] Updated RapidJSON parser

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

  • [HAR-987] Dynamically linked OpenSSL library for Solaris

In the Solaris driver, the OpenSSL library is now dynamically linked.

Resolved Issues The following issue was resolved in Simba Hive ODBC Driver 2.6.4.

  • [HAR-959] When SQLTables is called, the driver does not correctly display views.

2.6.3 ------------------------------------------------------------------------

Released 2019-02-01

Enhancements & New Features

  • [HAR-923] Updated ICU version

The driver now uses ICU version 58.2. Previously, the driver used ICU version 53.1.

  • [HAR-937] Dynamically linked libraries for Linux

To reduce the footprint of the Linux driver, the OpenSSL and ICU libraries are now dynamically linked.

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

  • [HAR-926] The driver fails to parse queries that contain the keyword "LIMIT".

  • [HAR-936] The driver fails to parse queries that contain a non-reserved keyword as the column name.

  • [HAR-886] The driver fails to parse queries that contain a CAST function.

  • [HAR-935] The driver fails to parse queries that contain an EXTRACT or FLOOR function.

2.6.2 ------------------------------------------------------------------------

Released 2018-11-02

Enhancements & New Features

  • [HAR-930] 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 Hive ODBC Driver 2.6.2.

  • [HAR-882] EnableUniqueColumnName can produce unexpected results for certain locale settings.

  • [HAR-902] The driver unexpectedly returns an error that is not handled by some BI tools.

This issue has been resolved. The driver now returns empty result sets for these queries.

  • [HAR-900] The message returned by the driver when an invalid Port value is specified in a DSN or connection string is insufficiently detailed.

  • [HAR-899] The driver does not support the TIMESTAMPADD and TIMESTAMPDIFF functions.

This issue has been resolved. You can now call the TIMESTAMPADD and TIMESTAMPDIFF functions when working with data of type TIMESTAMP. For more information, see the Installation and Configuration Guide.

  • [HAR-908] Kerberos authentication fails when using Keyring on Linux.

  • [HAR-912] In some situations, HTTP requests fail with a "Couldn't refill buffer" error message.

This issue has been resolved. The error message is caused by the driver attempting to make HTTP requests on connections that have been closed by the server. Now, when the driver makes a request, it checks if the "Connection" HTTP header field is set to "close". If so, the driver closes and reopens the connection.

2.6.1 ------------------------------------------------------------------------

Released 2018-08-03

Enhancements & New Features

  • [HAR-883] Hive 3.1 now supported

The driver now supports Apache Hive versions 0.11 through 3.1.

Resolved Issues The following issue has been resolved in Simba Hive ODBC Driver 2.6.1.

  • [HAR-833] CAST AS VARCHAR(n) returns incorrect metadata.

2.6.0 ------------------------------------------------------------------------

Released 2018-07-13

Enhancements & New Features

  • [HAR-732] Minimum TLS support

You can now specify the minimum version of TLS the driver accepts when authenticating the connection to the data source.

  • [HAR-822] Updated OpenSSL version

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

  • [HAR-807] More informative SSL error messages

The driver now provides more detailed error messages for TLS/SSL errors.

  • [HAR-820] Catalog configuration improvements

Internal improvements were made to the way the driver configures the catalog, schema, table, and column name lengths.

  • [HAR-657] Configuration instructions for Delegation UID

The driver documentation now provides additional configuration instructions for enabling the Delegation UID function on a clustered server or when using Kerberos authentication.

Resolved Issues The following issue has been resolved in Simba Hive ODBC Driver 2.6.0.

  • [HAR-853] HiveServerType value is incorrect in some documentation examples.

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

Installation and Configuration Guide