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) orUseS3
(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
, andcurrent_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.
- Resolves the issue wherein while uninstalling the driver, systems with unixODBC received the following insignificant
error: