JDBC Driver Version 2.0.0

Release Date: 14th May 2019

Qubole has released a new version of JDBC driver. For more details, see:

What’s New

These are the changes in this version:

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

    Presto FastStreaming enables streaming of results directly from AWS S3 in the JDBC 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 JDBC 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.

  • Qubole has added a new configuration to bypass the QDS Control Plane for getting results directly from the S3 location.

List of Changes

New Features

  • JDBC-22: Qubole has added a new feature to the JDBC driver known as Presto FastStreaming. It enables streaming of results directly from AWS S3 in the JDBC driver. The streaming behavior can help the BI tool performance as results are displayed as soon as they are available in S3. Presto FastStreaming for JDBC driver is supported in Presto versions 0.193 and 0.208.

    Set stream_results=true in the Connection String.

    Contact Qubole Support to enable the Presto FastStreaming feature on the account. Via Support

Enhancements

  • JDBC-144: Qubole has added a new configuration to bypass the QDS Control Plane for getting results. You can set useS3=true to fetch results directly from the S3 location.
  • JDBC-145: Qubole has added a retry count for AWS API calls to fetch results from S3 in case of a failure.

Bug Fixes

  • JDBC-141: Fixed a bug where Spotfire Business Intelligence tool got invalid datatype while fetching data.