Release Note 20140624

Table of Contents

Features & Improvements

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

SDKs: Released Javascript SDK v0.1.1

We released our first version of the new Javascript SDK (v0.1.1).

The pre-built SDK is available in both compressed or uncompressed format.

SDKs: Android SDK All-In-One JAR

The Android SDK v0.1.1 was released.

We created an all-in-one JAR build (td-android-sdk-0.1.1-shaded.jar) which contains all the dependencies: this greatly facilitates including the SDK in an Android project when not using Maven.

Console: Javascript SDK

Added the Javascript SDK link to the Import Data, SDKs landing page.

Console: Javascript SDK

Console: New Query and Schedules Page Links

We added convenience links in the:

  • Schedules list page:
    • Added a description which is displayed when the schedules list is empty: the description invites the user to create a new schedule through the New Query page:
  • New Query page:
    • Added links to the ‘schedules’ and ‘result output’ documentation pages in the respective sections of the New Query page:
    • Added links to the selected Query engine’s reference documentation page.

Console: New Query and Schedules Page Links - 1 Console: New Query and Schedules Page Links - 2 Console: New Query and Schedules Page Links - 3

Console: Top Bar Menus

Made the Top Bar’s menus open ‘on click’ instead of ‘on hover’.

Console: Scrolling When Navigating Across Pages

In pages implementing pagination (Jobs and Schedule pages), loading the next or previous page scrolls the page up to the top when the size of the page does not fit on the screen.

APIs: Create Table with Write-Only API Key

Made write-only API keys able to create tables in databases whose user has import-only permissions for.

Workers: Schema Mismatch Warnings

When executing a Query Result Output to MySQL in append or update modes, columns that are in the result schema but not in the destination table schema are dropped. An information message is printed in the Job’s log for each column in the result that is dropped:

Skipping result column "<column_name>" (the column name does not match any of the columns in the destination table)

Workers: Avoid Retry On Semantic Exceptions

The Hive worker does not retry on Semantic exceptions.


Bug Fixes

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

Console: Jobs Validation Errors On Deleted Saved Query Result Outputs

  • [Problem]
    Jobs cannot be killed if they are run using a saved Query Result Output that is subsequently deleted.
    [Solution]
    This problem is caused by a race condition which is not handled: if the user runs a job with a query result output set to a saved target and the saved target is deleted while the job executes, the attempt to update the job status to ‘killed’ fails because of a validation error.
    Validation of the named output target is skipped if an output target URL is already set for the job (as it happens for jobs that already began running). This avoids the race condition.

Console: Web Uploader Problems In IE10

  • [Problem]
    CSV parsing for the Web uploader doesn’t work on Internet Explorer 10.
    [Solution]
    The Javascript portion of the CSV parser was not compatible with IE10’s Javascript core.
    A new version of the parser was compiled to resolve the compatibility issue.

Console: Storage Graph Includes Deleted Databases

  • [Problem]
    The Storage graph in the Utilization page includes databases that have been deleted.
    [Solution]
    The query used to calculate the total storage for the account ignores the databases' ‘deleted_at’ field. Databases whose ‘deleted_at’ field is NOT NULL, have been deleted.
    The query is updated to filter out databases that have been deleted by checking the ‘deleted_at’ value for each record.

Console: Tutorial Problem

  • [Problem]
    The links required to progress through the tutorial may not be accessible: if this happens, the user is becomes stuck in the tutorial and cannot complete it.
    [Solution]
    This problem occurs when the screen width is too small. In this situation the tutorial overlay fails to be placed over the correct links.
    The layout of the page was changed to make only the content (Side bar and Top bar excluded) of the page scrollable.

APIs: Bulk Import Record Count Overflow

  • [Problem]
    Bulk import’s count of valid and error records saturates at 231.
    [Solution]
    The type of the fields in the Bulk Import session API table were set to integers.
    The fields have been changed to long to represents numbers up to 263.

APIs: Bulk Import Auto Schema Detection

  • [Problem]
    Auto-schema detection for Bulk Import records fails occasionally.
    [Solution]
    This problem is due to the APIs being unable to download a sample of the imported data from AWS S3 after the Bulk Import perform action has completed: this is caused by the well known S3’s ‘eventual consistency’ problem.
    The eventual consistency problem is worked around by having the API retry to fetch a sample of the Bulk imported data when a failure occurs.

APIs: Bulk Import Perform Restrictions

  • [Problem]
    The Bulk Import perform step can be executed multiple times, leading to duplicated data.
    [Solution]
    When a Perform job is already running for a Bulk Import session, the status of the session is set to ‘Performing’ but the API does not check the status of a session before accepting a new Perform job request.
    Added validation on the status of the Bulk Import session to make sure only one Bulk Import perform job can be run at any time.

APIs: Scheduled Queries Next Run Time

  • [Problem]
    The ‘Next run’ time field for a Scheduled query is not updated when the periodicity is modified for the query to run less frequently.
    [Solution]
    This is due to an inconsistent handling of the next run time between the APIs database and Job Scheduling database.
    We made the handling consistent by passing the next run time calculated by one to the other, avoiding inconsistent calculations.

Last modified: Nov 06 2014 06:54:36 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.