15.10 - Changes to this Book - Teradata Database

Teradata Database Teradata JSON

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1150-151K
Release Description

Teradata Database 15.10

December 2015

Updated the privileges required for JSON_SHRED_BATCH and JSON_SHRED_BATCH_U.

Teradata Database 15.10

July 2015

  • Added information about the support provided by .NET Data Provider for the JSON type.
  • Clarified that when casting a JSON type to /from VARCHAR/CHAR and no character set is explicitly specified, the character set of the JSON type is used.
  • Clarified the use of structured UDTs with JSON_AGG and JSON_COMPOSE.

Teradata Database 15.10

June 2015

  • Added information on how to specify a storage format for the JSON data type so that JSON data is stored in one of the optional binary formats (BSON or UBJSON).
  • Added new functions: BSON_CHECK, JSONMETADATA, JSONGETVALUE, NVP2JSON.
  • Added new methods: AsJSONText, AsBSON, StorageSize, Metadata, KeyCount.
  • Added JSON as a supported data type for parameters and the return type of Java UDFs and external stored procedures.