16.10 - AVRO Data Support - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

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.