15.10 - JSON_SHRED_BATCH and JSON_SHRED_BATCH_U - Teradata Database

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty

Purpose

JSON_SHRED_BATCH and JSON_SHRED_BATCH_U are SQL stored procedures that use any number of JSON instances to populate existing tables, providing a flexible form of loading data from the JSON format into a relational model. Two shred procedures are provided; however, the only difference between them is the character set of the data. To explain the functionality, we only describe JSON_SHRED_BATCH (the version that operates on LATIN character set data), but the explanation applies equally to JSON_SHRED_BATCH_U (the UNICODE version).

Functional Description

The batch shredding procedures map into a number of successive calls to JSON_TABLE to create a conglomerate temporary table, the values of which can be assigned to existing tables.

Syntax