ODBC Driver Version 2.1.0

Release Date: 18th June 2019

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

Caution

The ODBC Driver version 2.1.0 is a beta release with Signature V4 support and Presto FastStreaming feature. 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

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.

These are the changes in this version:

  • Qubole has added a new feature to the ODBC driver known as Presto FastStreaming.

    Presto FastStreaming enables streaming of results directly from AWS S3 in the ODBC driver. This is in contrast to the earlier behavior wherein the driver waits for the query to finish before downloading any results from the QDS Control Plane or from S3. The streaming behavior can help the BI tool performance as results are displayed as soon as they are available in S3. Presto FastStreaming for ODBC driver is supported in Presto versions 0.193 and 0.208. As streaming cannot be used with Presto Smart Query Retry, the Presto FastStreaming feature automatically disables Presto Smart Query Retry.

  • ODBC driver now supports SQL_KEYWORDS in Hive and Presto queries. Limiting Presto and Hive queries with SQL_KEYWORDS now successfully return results.

  • The Use S3 option is enabled by default and it is set to bypass QDS Control Plane for getting results directly from the S3 location.

List of Changes

New Features

  • ODBC-53: Qubole has added a new feature to the ODBC driver known as Presto FastStreaming. It enables streaming of results directly from AWS S3 in the ODBC driver. This is in contrast to the earlier behavior wherein the driver waits for the query to finish before downloading any results from the QDS Control Plane or from S3. The streaming behavior can help the BI tool performance as results are displayed as soon as they are available in S3. Presto FastStreaming for ODBC driver is supported in Presto versions 0.193 and 0.208.

    To enable Presto FastStreaming:

    • On Linux and Mac, add STREAM_RESULTS=true in the odbc.ini file.
    • On Windows, select Stream Results in Qubole ODBC Driver DSN Setup > Advanced Configuration.

    Create a ticket with Qubole Support to enable the Presto FastStreaming feature on the account. Via Support

Bug Fixes

  • ODBC-297: Earlier, limiting queries with SQL_KEYWORDS returned empty results. ODBC driver now supports SQL_KEYWORDS in Hive and Presto queries. Limiting Presto and Hive queries with SQL_KEYWORDS now successfully return results.
  • ODBC-306: This fixes the bug in ODBC 2.0.0 wherein entire file was being downloaded from S3 as one big chunk instead of being downloaded as several smaller chunks.
  • ODBC-308: This fixes the bug that occurred in Qubole-on-Azure where data catalogs were not listed when UseS3 option was enabled.