Release: Amazon Redshift on 2014-05-06

This release of Amazon Redshift adds support for unloading data to a single file and adds new functions to work with strings using regular expressions.


Release Date: May 08, 2014
Created On: May 08, 2014
Last Updated: October 09, 2017


New Features

Feature Description

UNLOAD to a single file

You can unload table data serially to a single file on Amazon S3 by running the UNLOAD command with the PARALLEL OFF option. If the size of the data is greater than the maximum file size of 6.2 GB, UNLOAD creates additional files.

REGEXP functions

The REGEXP_COUNT, REGEXP_INSTR, and REGEXP_REPLACE functions manipulate strings based on regular expression pattern matching.

New table design tutorial

The new tutorial, Tuning Table Design, walks you through the steps to optimize the design of your tables, including testing load and query performance before and after tuning. For more information, see Tutorial: Tuning Table Design in the Amazon Redshift Database Developer Guide.

Documentation

For a summary of these new features and other documentation changes, go to Document History in the Amazon Redshift Database Developer Guide and the Amazon Redshift Cluster Management Guide.