Release: Amazon Redshift on 2014-03-25
This release of Amazon Redshift adds support for loading data in JSON format using the COPY command and a new function, REGEXP_SUBSTR, which returns a substring based on regular expressions.
Release Date: March 25, 2014
Created On: March 25, 2014
Last Updated: October 09, 2017
Release: Amazon Redshift on 2014-03-25
This release of Amazon Redshift adds support for loading data in JSON format using the COPY command and a new function, REGEXP_SUBSTR, which returns a substring based on regular expressions.
New Features
| Feature | Description |
|---|---|
|
COPY from JSON |
The COPY command now supports loading JSON-formatted data from files on Amazon S3 and from remote hosts. |
|
New REGEXP_SUBSTR function |
The REGEXP_SUBSTR function returns the characters extracted from a string by searching for a regular expression pattern. |
|
New STL_PLAN_INFO system table |
The STL_PLAN_INFO table supplements the EXPLAIN command as another way to look at query plans. |
|
Documentation |
For a summary of these new features and other documentation changes, go to Document History in the Amazon Redshift Developer Guide. |