About JSON Format with Native Object Store | NOS | Teradata Vantage - About JSON Format - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Native Object Store Getting Started Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
jjn1567647976698.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1214
lifecycle
previous
Product Category
Software
Teradata Vantage
Using NOS, the maximum payload size of a record is 16,776,192 bytes.
  • For UNICODE, that is equivalent to 8,388,096 characters.
  • For LATIN, that is equivalent to 16,776,192 characters.

The actual payload size is equivalent to the dataset individual record size.

Payload attributes for JSON objects are the names in the name:value pairs. In the example river flow data, some of the payload attributes include: datetime, Flow, Velocity, Precipitation, Temp, GageHeight.

Attributes may differ from one JSON object to another. JSON objects do not have to include all attributes.

For supported JSON formats, see JSON External Files.

For more details, see the Orange Book, Native Object Store: Teradata Vantageā„¢ Advanced SQL Engine, TDN0009800.