3 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.15, as well as the version history.

1.2.15 =======================================================================

Released 2017-09-21

Enhancements & New Features

  • Prefixes for log file names

    You can now configure the driver to prefix log file names with 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.

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

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.

1.2.5 ————————————————————————

Released 2016-08-02

Enhancements & New Features

  • Support added for SQL_TSI_FRAC_SECOND precision

    The driver now supports queries that use the TIMESTAMPDIFF and TIMESTAMPADD scalar functions with the SQL_TSI_FRAC_SECOND precision.

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

  • Driver returns non-selected columns specified in the ORDER BY clause.

  • Syntax error when using parameters in case expressions, specifically in the ELSE and THEN clauses.

  • Using alias for a column name in SELECT DISTINCT List does not resolve properly for the ORDER BY clause.

1.2.4 ————————————————————————

Released 2016-06-30

Enhancements & New Features

  • Support added for EXISTS syntax

    The driver now supports queries that use the EXISTS syntax.

  • Additional SQLColumn optimization

    The driver now optimizes catalog functions that include schema restrictions.

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

  • Query fails if the column name contains a char from the Latin-1 Supplement char set.

  • Warning dialog when non-Admin user clicks OK on the DSN dialog should be suppressed.

  • Driver reports statement length limit as 16K.

1.2.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.

  • Improved implementation of SQLCancel

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

  • Optimized metadata retrieval

    The driver now retrieves schemas and table names using the SHOW TABLES query instead of the GetTables Thrift API call.

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

  • The Use Only SSPI configuration option (the UseOnlySSPI property) does not work correctly.

  • Driver does not push down restrictions for catalog functions (SQLTables and SQLColumns), in some cases causing a large number of GET_TABLES requests to occur.

  • When connecting to Impala 1.1 and executing a query that contains a NULL literal in the SELECT list, the driver terminates unexpectedly.

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