4 HIVE

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

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

2.1.14 ======================================================================

Released 2017-10-20

Enhancements & New Features

Updated Kerberos configuration

The Host FQDN and Service Name configuration options (the KrbHostFQDN and KrbServiceName connection properties) are now optional. Also, the driver now automatically canonicalizes the server SPN when using Active Directory Kerberos.

Resolved Issues

The following issues are resolved in Simba Hive ODBC Driver 2.1.14.

AD Kerberos authentication may use the wrong user when enabling constrained delegation in Tableau server on Windows.
SQLGetInfo(SQL_KEYWORDS) returns an empty string.

The driver now returns a comma-separated list of keywords natively defined by the data source except for the ones that are also ODBC reserved words.

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

2.1.13 ———————————————————————–

Released 2017-09-21

Enhancements & New Features

Prefixes for log file names

You can now configure the driver to add a prefix to log file names. The prefix includes the user name associated with the connection and the process ID of the application through which the connection is made. To enable this feature, set the UseLogPrefix connection property to 1. For more information, see the Installation and Configuration Guide.

2.1.12 ———————————————————————–

Released 2017-06-26

Enhancements & New Features

Updated configuration option

The name of the Delegation User ID case configuration option has been changed from DelegationUIDCase to DelegationUserIDCase.

Resolved Issues

The following issues are resolved in Simba Hive ODBC Driver 2.1.12.

Driver reports that only read operations are supported in the driver log.
The INFINITY value for FLOAT columns is not correctly retrieved.
Error/status code returned for query timeout error is incorrect.
NaN value retrieved for FLOAT columns is incorrect.
The operation handle for metadata API calls is not closed correctly.

2.1.11 ———————————————————————–

Released 2017-05-09

Enhancements & New Features

Convert letter case of delegated user names

You can now configure the driver to change the Delegation UID (or DelegationUID) value to all upper-case or all lower-case. To do this, set the DelegationUIDCase connection property.

2.1.10 ———————————————————————–

Released 2017-03-23

Resolved Issues The following issues were resolved in Simba Hive ODBC Driver 2.1.10.

Driver converts COALESCE function to less efficient CASE statement.
In the Simba Hive ODBC Driver Configuration tool for DSN-less connections, the “Enable Auto Reconnect” option is disabled by default.

This option is now enabled by default, which is the expected default setting.
In some cases, when upgrading the macOS driver from an earlier version to a later one, the installation process fails to update the odbcinst.ini configuration file.

Before, upgrading the driver sometimes required you to make changes to the ~/Library/ODBC/odbcinst.ini file manually. The driver installation process has been updated so that manual changes are no longer necessary.
Segmentation fault in Driver Manager detection on Linux and Solaris Sparc platforms.
If you use an alias to refer to the Hive server host name while authenticating through Kerberos, the driver fails to connect.

2.1.9 ————————————————————————

Released 2017-03-20

Enhancements & New Features

Updated third-party library dependencies

The driver has been updated to incorporate newer versions of the third- party library dependencies.

2.1.8 ————————————————————————

Released 2017-01-31

Enhancements & New Features

Upgraded OpenSSL library

The driver now uses OpenSSL 1.0.2. Previously, the driver used OpenSSL 1.0.1l.

Resolved Issues The following issues were resolved in Simba Hive ODBC Driver 2.1.8.

When attempting to use the Windows trust store on Windows Server 2016, an access violation exception occurs.
Error message contains typo, misspelling “URI” as “UIR”.

2.1.7 ————————————————————————

Released 2016-11-17

Enhancements & New Features

Support for the Windows trust store

You now have the option to use the CA certificates in the Windows trust store for server verification when using SSL.
Auto Reconnect

You can now configure the driver to automatically attempt reconnection to the Hive server if communications are lost.

Resolved Issues The following issues were resolved in Simba Hive ODBC Driver 2.1.7.

Driver fails to connect to the server when using TLS 1.2.
When executing a query that contains a CASE statement, the driver replaces the greater than sign (>) with an equal sign (=).
Driver does not correctly translate queries that contain the IS NOT NULL operator.

2.1.6 ————————————————————————

Released 2016-10-06

Simba Hive ODBC Driver 2.1.6 included several internal updates.

2.1.5 ————————————————————————

Released 2016-07-12

Enhancements & New Features

Delegate Kerberos credentials

You can now have the driver forward your Kerberos user credentials to the server to simplify the authentication process.
Host FQDN default

If no value is set for the “Host FQDN” option, it will now default to "_HOST"
Optimized Fast SQLPrepare behavior

The Fast SQLPrepare driver configuration option (the FastSQLPrepare key) is now disabled for non-SELECT queries. This ensures that the driver retrieves the necessary result set metadata at prepare time.

Resolved Issues The following issues were resolved in Simba Hive ODBC Driver 2.1.5.

Unicode characters in parameter values causing errors.
Returning errors for some queries with dates in them.
Unable to create new tables when “Unicode character types” option set.

2.1.4 ————————————————————————

Released 2016-04-15

Resolved Issues The following issues were resolved in Simba Hive ODBC Driver 2.1.4.

Driver reports duplicate entries for SQLTables and SQLColumns.

2.1.3 ————————————————————————

Released 2016-03-31

Enhancements & New Features

Support added for Red Hat Enterprise Linux (RHEL) 7 and CentOS 7

You can now install and run the Linux version of the driver on machines that run RHEL 7 or CentOS 7.
Updated authentication support

For consistency with Microsoft Azure HDInsight updates, the Windows Azure HDInsight Emulator authentication mechanism (AuthMech=5) is now deprecated. The driver no longer supports connections to Hive server instances that run on Windows Azure HDInsight Emulator.

Resolved Issues The following issues were resolved in Simba Hive ODBC Driver 2.1.3.

When executing a query that uses regular expressions in the fields, an error occurs.

This issue has been resolved. Before, this problem occurred when querying Hive servers that are configured to not allow quoted identifiers (the hive.support.quoted.identifiers parameter is set to none), because these servers cannot parse the backquotes (`) used for regular expressions.
Driver truncates passwords that exceed the maximum character length of the Password field in the Simba Hive ODBC Driver DSN Setup dialog box.

The maximum character length of the Password field has been increased to 5000 characters.
In some cases, the driver stops working intermittently.

This issue has been resolved. Before, this problem occurred due to improper timing and sequence of operations between the execution context and the fetch thread.
In some cases, after being used in Tableau, the driver caches sessions and then tries to reuse them the next time Tableau is started.
When executing a parameterized INSERT statement on a BINARY column, an error occurs.

2.1.2 ————————————————————————

Released 2016-03-01

Resolved Issues The following issues were resolved in Simba Hive ODBC Driver 2.1.2.

When attempting to connect to the server using a non-Windows version of the driver with Service Discovery Mode enabled, the client stops working.
When executing a parameterized INSERT statement on a DATE, DECIMAL, or TIMESTAMP column, an error occurs.
When executing a query that contains a large number of filters using OR operators, an error occurs.

2.1.1 ————————————————————————

Released 2016-02-05

Enhancements & New Features

Updated handling of result set metadata

When connected to Hive 0.14 or later, the driver now reports result set columns as being updatable, improving compatibility with the DotNet Odbc library and OdbcDataAdapter.
Updated default socket timeout threshold

The default value of the Socket Timeout option (the SocketTimeout key) has been changed from 30 to 60, improving compatibility between the default behavior of the driver and Azure HDInsight.

2.1.0 ————————————————————————

Released 2015-12-21

Enhancements & New Features

Support added for ODBC 3.80

The driver now supports ODBC 3.80. Previously, the driver supported ODBC 3.52.
Improved implementation of SQLCancel

The driver now implements industry-standard behavior for when SQLCancel is called while query results are being fetched.
Upgraded OpenSSL library

The driver now uses OpenSSL 1.0.1l. Previously, the driver used OpenSSL 1.0.0q.
Upgraded ICU library

The driver now uses ICU 53.1. Previously, the driver used ICU 3.8.1.
Implemented driver configuration option for automatically opening a new session against Hive Server 2 when the existing session becomes invalid

You can now use the Invalid Session Auto Recover option (the InvalidSessionAutoRecover key) to configure the driver to automatically open a new session when it detects that the current session is no longer valid. This feature is available only for connections to Hive Server 2 instances.
Automatically configure settings in simba.hiveodbc.ini file

On non-Windows platforms, the DriverManagerEncoding and ODBCInst settings are now configured automatically based on the driver manager (iODBC or unixODBC) that is used.
Updated driver logging options

You can now specify the maximum size of each log file by using the “Max File Size” option (the LogFileSize key), and specify the maximum number of log files to keep by using the “Max Number Files” option (the LogFileCount key). Also, in the Logging Options dialog box for the Windows driver, you now have the option of browsing for the folder where you want to save log files instead of typing the path.
Updated naming convention for driver binary files
The names of the binary files used by the driver have been changed:
- SimbaHiveODBC32.dll is now HiveODBC_sb32.dll
- SimbaHiveODBC64.dll is now HiveODBC_sb64.dll
- libsimbahiveodbc32.so is now libhiveodbc_sb32.so
- libsimbahiveodbc64.so is now libhiveodbc_sb64.so
- libsimbahiveodbc.dylib is now libhiveodbc_sbUniversal.dylib
On non-Windows platforms, you should make sure that your configuration files point to the updated names of these files.

Resolved Issues The following issues were resolved in Simba Hive ODBC Driver 2.1.0.

DSN configurations cannot be saved when you are working as a non- administrator user.
When query execution results in a MapReduce error, the driver closes the current connection and opens a new one.
Driver terminates unexpectedly when preparing a parameterized INSERT statement.
Driver terminates unexpectedly when the application unloads the driver without closing all connections.

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