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. |