JavaScript Object Notation - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
egk1499705348414.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata PT supports loading JavaScript Object Notation (JSON) data into, and extracting JSON data from, Teradata Database tables.

The wire protocol between Teradata PT and the Teradata Database treats JSON as a CLOB.

Depending on how the JSON columns are defined in the Teradata PT schema, Teradata PT uses one of the following two methods to load JSON data into, or extract JSON data from, the Teradata Database:

  • Inline
  • Deferred

The JSON columns in the Teradata PT schema must have a length in bytes.

Only the TPT SQL Selector operator can extract JSON data from a Teradata table.

Only the TPT SQL Inserter operator can load JSON data into a Teradata table.

Only the TPT Data Connector operator can read JSON data from, and write JOS data to, a file.

For more information on CLOB, see Large Objects.