AVRO Data Support - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.00
Published
November 2020
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
ric1544831938741.ditamap
dita:ditavalPath
obe1474387269547.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, 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.