Release Note 20171201

This is a summary of new features and improvements introduced in the December 1st, 2017 release. If you have any product feature requests, submit them at feedback.treasuredata.com.

Table of Contents

Presto: DELETE statement support

Presto DELETE is now available for all TD customers, superseding our previous partial delete support. You can now delete rows from a table with the familiar SQL DELETE FROM table_name WHERE… with any condition. For details, click the following link:

Presto: Version Upgrade to v0.188

We’ve finished upgrading all customers to Presto v0.188 from v0.178. The major changes include:

Geospatial Functions Support

Presto 0.188 adds industry compliant geospatial functions. The new geospatial functions are a contribution from the ride-sharing company, Uber, to Presto project.

Lambda and Other New Expressions and Functions

Detailed Changelogs

The detailed changelogs are available here.

  • Presto version 0.188 release note
  • Presto version 0.187 release note
  • Presto version 0.186 release note
  • Presto version 0.185 release note
  • Presto version 0.184 release note
  • Presto version 0.183 release note
  • Presto version 0.182 release note
  • Presto version 0.181 release note
  • Presto version 0.180 release note
  • Presto version 0.179 release note

Presto: Continued Performance Improvements

A series of internal improvements released during October and November mean that Presto can now process, on average, at least 25% more data per Compute Unit than previously. No changes to your code are required to take advantage of this improvement.

Workflow: Enhanced User Interface (Private Beta)


Run History

Edit Workflow in Console

Session Details

Version List

We continue our private availability for our new Treasure Workflow web user interface experience. We are currently in Private Beta.

With the new experience, you can create and edit of workflows directly from your web browser, utilize quickstart templates, more easily find and debug workflow errors, and view history of edits to a workflow project.

In the last month we have further updated our Workflow UI edit experience, based on feedback, to enhance ease of use.

If you are interested in joining the private access of this new UI, and have not already requested access, complete this sign-up form, or contact your account representative.

Hive: TD_NUMERIC_RANGE() and TD_ARRAY_INDEX()

These two functions were added to Hive engine.

Collection: Hubspot Custom Properties

The Data Connector for Hubspot now enables users to import custom properties for objects.

Collection: Google Doubleclick for Publishers (DFP)

The Data Connector for Google Doubleclick for Publishers (DFP) enables users to import data from DFP, including the company, creative, inventory_adunit, line_item, order, placement, and report objects.

Collection: JavaScript SDK v1.9.1

JavaScript SDK v1.9.1 was released, which includes minor bug fixes and improvements. This version supports multi-token & key column for Personalization API.

Output: Result Output to Salesforce Marketing Cloud (ExactTarget)

Now you can publish user segments from Treasure Data into Salesforce Marketing Cloud (ExactTarget). Run data-driven email campaigns, by using your first party data from a variety of sources.

Private Availability

Console: Improved load time for table list & query editor pages (Private Access)

We have enabled support for a pagination based experience, for quicker page load time on these frequently accessed pages. If you’re interested in trying out this support, please let support or your account representative know, and we can turn it on for your account.

We will also be enabling support for faster load time on the saved queries page soon as well.


Last modified: Nov 30 2017 19:57:50 UTC

If this article is incorrect or outdated, or omits critical information, let us know. For all other issues, access our support channels.