ODBC Driver Version 2.0.0

Release Date: 24th May 2019

Qubole has released a new version of ODBC driver for Linux, Mac, and Windows.

Caution

The ODBC Driver version 2.0.0 is a beta release with Signature V4 support. It can cause data loss in scenarios where results data has NULL characters (0x00) and is therefore not recommended for production usage. For more information, see Launch Stage and Availability of Features.

For more details, see:

What’s New

The new features and enhancements are listed in the section below:

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.

  • Qubole now supports AWS SDK in Qubole ODBC Driver for Linux, Mac, and Windows. With this change, the ODBC driver also gets support for AWS Signature V4 for authenticating requests with AWS S3. Signature V4 is required for successful operation of Qubole ODBC drivers as Signature V2 (version that was supported by Qubole Drivers until now) will be shut down by AWS on June 24, 2019.

  • Qubole has added three new configuration properties in this version to:

    • Bypass the QDS Control Plane for getting results directly from the S3 location
    • Add the AWS region of the bucket that you use as the cloud object storage
    • Add the catalog name

    Learn more

List of Changes

Enhancements

  • ODBC-234: This enhancement adds support for AWS SDK in Qubole ODBC Driver on Windows. With this change, Qubole ODBC driver on Windows also gets support for AWS Signature V4 for authenticating requests with AWS S3. Signature V4 is required for successful operation of Qubole ODBC drivers as Signature V2 (version that was supported by Qubole Drivers until now) will be shut down by AWS on June 24, 2019.

  • ODBC-271: This enhancement adds support for AWS SDK in Qubole ODBC Driver on Mac. With this change, Qubole ODBC driver on Mac also gets support for AWS Signature V4 for authenticating requests with AWS S3. Signature V4 is required for successful operation of Qubole ODBC drivers as Signature V2 (version that was supported by Qubole Drivers until now) will be shut down by AWS on June 24, 2019.

  • ODBC-274: In the ODBC driver for Linux, Qubole now allows you to add a catalog that is CATALOG=<catalog_name> in the odbc.ini file.

  • ODBC-276: In the ODBC driver for Linux and Mac, Qubole now allows you to add a catalog that is CATALOG=<catalog_name> in the odbc.ini file. On Windows, you can configure it in the Advanced Configuration option of ODBC DataSource.

  • ODBC-283: This enhancement adds support for AWS SDK in Qubole ODBC Driver on Linux. With this change, Qubole ODBC driver on Linux also gets support for AWS Signature V4 for authenticating requests with AWS S3. Signature V4 is required for a successful operation of Qubole ODBC drivers as Signature V2 (version that was supported by Qubole Drivers until now) will be shut down by AWS on June 24, 2019.

  • ODBC-292: Qubole has added a new configuration to bypass the QDS Control Plane for getting results. You can set USE_S3=true to fetch results directly from the S3 location. In the ODBC driver for Linux and Mac, you can add the configuration in the odbc.ini file.

    In the ODBC driver on Windows, you can configure it in the Advanced Configuration option of ODBC DataSource.

Bug Fixes

  • ODBC-286: It fixes an issue with Qubole ODBC Driver version 1.1.11 that resulted in a parsing error when using the driver with a cluster running in the https://azure.qubole.com/ Qubole environment.