AVRO Data Support - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2023-11-29
dita:mapPath
abr1608578396711.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
Product Category
Teradata Tools and Utilities

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

The wire protocol between Teradata PT and the 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 database (or extracting from the database) are the same as how LOBs are supported.

This means that inline and deferred mode is allowed.

The 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 database). If the AVRO container is larger than 2GB, the container must be split into multiple, smaller containers prior to loading into the database.

For more information on BLOB, see Large Objects.