AVRO Data Support - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.20
Published
November 2020
Language
English (United States)
Last Update
2020-11-19
dita:mapPath
whl1527114222314.ditamap
dita:ditavalPath
whl1527114222314.ditaval
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata PT supports loading AVRO data into, and extracting AVRO data from, Teradata Database tables.

The wire protocol between Teradata PT and the Teradata Database treats AVRO as a VARBYTE/BLOB (depending on the size of the data).

Teradata PT does not have an AVRO data type for specification in the schema.

The user must use VARBYTE or BLOB in the schema definition, and all of the rules for loading AVRO data into the Teradata Database (or extracting from the database) are the same as how LOBs are supported.

This means that inline and deferred mode is allowed.

The Teradata Database has implicit CASTs between VARBYTE/BLOB and AVRO.

The maximum size allowed for an AVRO container is 2GB (the same as the maximum size of a BLOB column in the Teradata Database). If the AVRO container is larger than 2GB, the container must be split into multiple, smaller containers prior to loading into the Teradata Database.

For more information on BLOB, see Large Objects.