ODBC Driver Version 2.1.1

Release Date: 14th November 2019

Qubole has released a new version of ODBC driver for Linux, Mac, and Windows. Qubole supports two variants of its ODBC drivers:

  • Series 2.1.x (starting with version 2.1.1) is based on top of AWS SDK and hence it has inherent support for accessing AWS S3 buckets that require signature version V4.
  • Series 2.2.x is based on older (1.X.X) releases and does not support accessing AWS S3 buckets that require signature version V4.

For more details, see:

What’s New

Note

Unless stated otherwise, features are generally available, available as self-service and enabled by default. For more information, see Launch Stage and Availability of Features.

List of Changes

Enhancements

  • ODBC-315: Earlier, Qubole ODBC driver was using two API calls (Command API followed by Results API to fetch results location) when USE_S3 (on Linux/Mac) or UseS3 (on Windows) was enabled. Now, this enhancement replaces that with a single API call. This helps in reducing the overall command latency.
  • ODBC-343: Qubole has added an optimization to reduce the number of calls to Qubole APIs. Specifically, Qubole ODBC drivers do not make a call to get credentials on every connect call if those credentials have already been obtained during a previous connect call. This enhancement helps reduce the overall latency due to additional Qubole API calls.

Bug Fixes

  • ODBC-244: This fixes the issue with current_date, current_time, and current_timestamp keywords in Qubole ODBC driver.

  • ODBC-322: This fixes the data loss issue encountered in releases 2.0.0 and 2.1.0 (faced when NULL (0x00) characters were present in the Results data).

  • ODBC-323: This fixes the issue in ODBC Driver 2.0 and 2.1 due to which malformed metadata queries were created for columns having spaces and special characters.

  • ODBC-331: Starting this version, ODBC driver for Linux only creates system-level DSNs during its installation. For details on steps to create user-level DSNs, see Creating a User-level DSN.

  • ODBC-341: It is a fix for the issue with Linux ODBC installer wherein it was overwriting /etc/qubole.odbc.ini if it was missing ODBC Data Sources stanza. With this fix, if /etc/qubole.odbc.ini that already exists, was missing the ODBC Data Sources stanza, the installer now adds this stanza and adds Qubole DSN.

    In addition, this fix:

    • Resolves the issue wherein while uninstalling the driver, systems with unixODBC received the following insignificant error: cannot remove '/etc/profile.d/qds-odbc.sh': No such file or directory.
    • Removes the ODBCInstLib key in /etc/qubole.odbc.ini on Linux.