5 IMPALA

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

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

1.2.17 =======================================================================

Released 2018-02-22

Enhancements & New Features

  • Backward compatibility added for Database connection property

    When configuring your connection on a non-Windows machine or through a connection string, you can now use either the Schema or Database connection property to specify the name of the database schema for the connection. Prior to this update, support for the Database connecton property had been removed.

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

  • Driver returns incorrect error code for when the Impala session times out and the auto reconnection feature is disabled.

    This issue has been resolved. Before, the driver incorrectly returned a generic error code (SQL state HY000). The driver now returns SQL state 08S01 instead.

  • In some cases, the driver fails to authenticate the connection through Kerberos.

  • In certain scenarios, during query execution the system message “Error creating temporary swap file name” may be displayed.

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

1.2.16 ———————————————————————–

Released 2017-10-31

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

  • If a query fails due to “Memory Limit Exceeded”, the query is not closed.

  • CHAR field length reports incorrect values.

  • Driver log file name does not include vendor.

1.2.15 ———————————————————————–

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.

1.2.14 ———————————————————————–

Released 2017-08-11

Enhancements & New Features

  • Support for Impala 2.9

    The driver now supports Impala versions 1.0.1 through 2.9.

  • Driver-wide configurations

    You can now set configuration options so that they apply to every connection that uses the driver. Before, most configuration options had to be set individually for each connection.

  • DelegationUIDCase renamed

    The DelegationUIDCase property has been renamed. It is now called DelegationUserIDCase.

  • Automatic server SPN canonicalization

    The driver now automatically canonicalizes the server SPN when using Active Directory Kerberos.

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

  • On macOS, the driver sometimes terminates unexpectedly when authenticating the connection through Kerberos.

  • Driver installation fails on Linux.

    This issue has been resolved. The issue occurred because the RPM file used an incorrect file path for the installation directory.

  • If a query contains a scalar subquery, the driver returns an error and fails to execute the query.

1.2.13 ———————————————————————–

Released 2017-05-25

Enhancements & New Features

  • Restrict catalog functions to current schema

    If a schema is not specified for a catalog function, or if a schema is specified with the wildcard character %, you can choose to restrict the catalog function to the current schema. This may improve performance. To do this, select the Restrict Metadata with Current Schema GUI option, or set the CurrentSchemaRestrictedMetadata connection setting to 1.

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

  • The driver incorrectly adds a length to all the type name in CAST statements during query translation.

  • In the driver log, the driver is reported as read-only, despite being read/write enabled.

  • The driver does not correctly retrieve infinity value for FLOAT columns.

  • The driver does not correctly retrieve NaN (Not a Number) value for FLOAT columns.

1.2.12 ———————————————————————–

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.

1.2.11 ———————————————————————–

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.

1.2.10 ———————————————————————–

Released 2017-02-07

Enhancements & New Features

  • Specify asynchronous exec poll interval

    You can now specify the time in milliseconds between each poll that the driver makes for the query execution status. Specify the number of milliseconds in the Advanced Options dialog box in the Async Exec Poll Interval field, or in the AsyncExecPollInterval configuration option.

  • Support for Impala 2.8

    The driver now supports Impala versions 1.0.1 through 2.8.

  • Specify Kerberos host name canonicalization

    By default, if you specify a Kerberos realm, the Kerberos layer canonicalizes the host FQDN in the server’s service principal name. You can disable this behavior by disabling the Canonicalize Principal FQDN option, or by setting the ServicePrincipalCanonicalization connection property to 0.

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

  • Queries using DISTINCT run correct in HUE but not via ODBC.

  • Wrong SQL state returned for query timeout error.

  • Incorrect driver version verification instructions for macOS in documentation.

  • Segmentation fault in Driver Manager detection on Linux and Solaris Sparc platforms.

1.2.9 ————————————————————————

Released 2017-02-02

Enhancements & New Features

  • Configure SSL certificate revocation check

    You can now configure the driver to check whether a TLS/SSL certificate that is stored in the Windows Trust Store has been revoked. By default, the driver checks for revocation. To disable the revocation check, clear the Check Certificate Revocation check box, or set the CheckCertRevocation key to 0.

  • Simplified MIT Kerberos configuration

    When using MIT Kerberos to access the Impala service from a Kerberos realm that is different than the Kerberos realm that the user belongs to, the user is no longer required to add the Impala service’s network domain to the Kerberos realm mapping in the Kerberos configuration file on the client machine.

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

  • Driver converts COALESCE function to less efficient Impala CASE statement.

1.2.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 have been resolved in Simba Impala ODBC Driver 1.2.8.

  • When attempting to use the Windows trust store on Windows Server 2016, an access violation exception occurs.

1.2.7 ————————————————————————

Released 2016-11-03

Enhancements & New Features

  • Support added for Kerberos delegation

    You now have the option for the driver to forward the user credentials to the server when using Kerberos authentication.

  • Support for 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 configure the driver to automatically attempt reconnection to the Impala server if communications are lost.

  • Support for query, login, and connection timeout

    The driver now supports the following ODBC API calls:
    • SQL_ATTR_CONNECTION_TIMEOUT
    • SQL_ATTR_LOGIN_TIMEOUT
    • SQL_ATTR_QUERY_TIMEOUT
  • Optimization of metadata retrieval

    Driver performance during metadata retrieval has been optimized.

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

  • If a user attempted to connect without proper permissions to access the schema set in the connection string, the driver would fail to connect.

    The driver will now display a warning under these circumstances, and use the default schema.

  • Specifying an alias for a column name in the SELECT list when SELECT DISTINCT is present and using that column name in the ORDER BY clause causes a system message to be displayed.

  • Driver returning incorrect order for character data types in the SQLGetTypeInfo result set under some circumstances.

1.2.6 ————————————————————————

Released 2016-08-28

Enhancements & New Features

  • Support added for TLS versions up to 1.2

    The driver can now connect to the database using TLS 1.2 or earlier. For detailed information about configuring TLS/SSL settings, see the Simba Impala ODBC with SQL Connector Installation and Configuration Guide.

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

  • When translating a CAST statement, the query translator removes the length from CHAR and VARCHAR data.

  • If a statement contains a CASE expression that uses THEN or ELSE as well as a parameter, and the statement also contains a GROUP BY clause that uses the same column as the CASE expression, then the driver returns a syntax error.

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