Release Note 20141209

Table of Contents

Features & Improvements

This is a summary of the new features and improvements introduced in this release:

Presto: Upgraded Presto to v0.86

We upgraded the Presto query engine from v0.76 to v0.86.
The list of Presto specific changes can be found at Presto’s Release notes (v0.77 through v0.86).

The major highlights are:

  • Supports for Map types
  • Support for Array types
  • Support for distributed JOINs in joining large tables
  • Ability to rename a table using an ‘ALTER TABLE’ statement

Alongside the improvements to Presto, we made these changes/optimizations:

  • Presto’s parallelization allows the clients to fetch the results while the query is still being performed. The Treasure Data Presto worker have been optimized to take advantage of this capability and modified to keep displaying the query progress although it already started fetching the result of the query.
  • Added the TD_DATE_TRUNC UDF to mirror the functionality of the equally named TD_DATE_TRUNC UDF in Hive. Please note that as for Hive, TD_DATE_TRUNC is * inspired but not identical to Presto’s native date_trunc function: TD_DATE_TRUNC is mainly used when the time reference is expressed as a Unix time long * integer while date_trunc is suited for Presto’s native ‘date’, ‘time’, and ‘time with timezone’ types.
  • Added support for INSERT INTO statements (as already supported by Hive) and optimized table writes by leveraging our metadata store directly.
  • Optimized fetching of data from storage in case of transfer failures and improved the retry mechanism.
  • Fixed time index filtering when the TD_TIME_FORMAT UDF is used within the TD_TIME_RANGE UDF.
  • Fixed time index filtering when the end limit (3rd argument) of the TD_TIME_RANGE UDF is NULL.
  • Added the TD_MD5 and TD_URL_DECODE UDFs. The functionality is identical to Hive’s.
  • Improved the error message to be more descriptive when a query fails because of an unsupported operation.
  • Experimental support of CREATE TABLE FROM queries in Presto.
  • Fixed WITH clause when the table alias contains capitalized characters.
  • Fixed issue in handling JSON structures embedded in strings.
  • Added handling of result output to S3 when the query result contains a NULL constant – which is not supported since a Treasure Data storage equivalent * does not exist. Added a message to warn the user to modify the NULL constant by casting it to another supported type.

Query Library: Examples SQL Query Catalog

We released a new application which works as a collection of sample queries along with description, input & output tables, and a sample visualization graph.
Some important analytics categories are covered. These queries can be used as templates in writing a query whose scope and purpose falls within the boundaries of one of the provided example.

The SQL Query Catalog is accessible at examples.treasuredata.com.

Query Library: Main

Query Library: Template

Bug Fixes

These are the most important Bug Fixes made in this release:

Console: Stale Table List in the Database View

  • [Problem]
    When a table is created or deleted and the user returns to the database view, the table list is still reflecting the previous status.
    [Solution]
    This issue is caused by not fetching the list of tables again when one of the tables is deleted or a new table is created. This causes the page to load the list of tables from the cache in localStorage, making it look like the table list is stale.
    We solved this problem by enforcing the fetch of the list of tables after the creation or deletion of a table. This guaranteed that the list of table is always up to date and reflects the last operation.

Console: Resizing of the Query Index Page

  • [Problem]
    Making the queries index page narrow triggers multiple scrollbars at the bottom of the page.
    [Solution]
    This is due to an improper handling of the panel sizing when the window is made narrower than the minimum supported browser width.
    We improved the resizing mechanism to handle this case more gracefully and avoid triggering multiple unnecessary scrollbars.

Console: Password Strength Indicator

  • [Problem]
    The password strength indicator is misplaced and not displayed right next to the password field it belongs.
    [Solution]
    This is a simple styling issue.
    The location where the password strength indicator is displayed was tweaked to place the indicator right below the password field of the form.

Last modified: Dec 21 2014 20:00:09 UTC

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