AVRO Data Support - Parallel Transporter

Teradata® Parallel Transporter Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
IntelliFlex
Enterprise
VMware
Lake
Product
Parallel Transporter
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-04-02
dita:mapPath
mjn1691132485167.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.