16.20 - Functional Description - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ XML Data Type

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1140-162K
Language
English (United States)

The shredding procedure processes in a streaming fashion (the whole document is not loaded into memory all at once) each of the documents returned by evaluating the SQL query specified by queryString. The annotated schema is used to extract the values of interest from each of the documents and the target tables are updated using these values. During this process, if an externalContext is specified, any configuration values specified are used to override equivalent parameters in the annotated schema mapping.