Downloading the ODBC Driver on Linux¶
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. New S3 buckets that are created after January 20, 2020 only support signature version V4. AWS regions that are created after 2013 only support signature version V4, which are listed in AWS Service endpoints.
Qubole recommends you to test if the S3 bucket is in the AWS region that supports signature version V4 to use series 2.1.x drivers.
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. It supports accessing AWS S3 buckets that require signature version V2. To know regions that support signature version V2, see AWS Service endpoints.
Proceed as follows to prepare your system and download the driver:
The Qubole driver is stored in the publicly accessible cloud storage, and works on all cloud platforms (except GCP) supported in QDS.
Qubole recommends to use 2.23 and later version of GNU C Library (glibc) as there is a bug in 2.22 and earlier versions.
Download the Qubole ODBC driver. The following table provides version, downloadable locations, and so on.
ODBC Driver Version AWS V4 Signature Support Downloading Location Driver Release Notes 2.1.1 Yes as it is Series 2.1.x https://paid-qubole.s3.amazonaws.com/odbc/2.1.1/qds-odbc-2.1.1-1.x86_64.rpm ODBC Driver Version 2.1.1 2.2.2 No as it is Series 2.2.x https://paid-qubole.s3.amazonaws.com/odbc/2.2.2/qds-odbc-2.2.2-1.x86_64.rpm ODBC Driver Version 2.2.2
Installing the ODBC Driver on Linux describes the steps to install the ODBC driver.
Downloading ODBC Driver Older Versions on Linux¶
To download the last three older ODBC driver versions, choose the version from this list:
ODBC Driver Version AWS V4 Signature Support Downloading Location Additional Description 2.1.0 (beta) Yes https://s3.amazonaws.com/paid-qubole/odbc/2.1.0/qds-odbc-2.1.0-1.x86_64.rpm
The ODBC Driver versions 2.0.0 and 2.1.0 are beta releases. They can cause data loss in scenarios where results data has NULL characters (0x00) and are therefore not recommended for production usage. For more information, see Launch Stage and Availability of Features.
2.0.0 (beta) Yes https://s3.amazonaws.com/paid-qubole/odbc/2.0.0/qds-odbc-2.0.0-1.x86_64.rpm
ODBC Driver Version AWS V4 Signature Support Downloading Location Additional Description 2.2.1 No https://paid-qubole.s3.amazonaws.com/odbc/2.2.1/qds-odbc-2.2.1-1.x86_64.rpm NA 2.2.0 No https://paid-qubole.s3.amazonaws.com/odbc/2.2.0/qds-odbc-2.2.0-1.x86_64.rpm