17.10 - Maximum and In-Line Length of a DATASET Instance - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1198-171K
Language
English (United States)

DATASET uses complex data type enhancements for varying maximum and in-line lengths. The values represent the schema and data byte size for each instance of the DATASET data type.

There is additional space for other information within the instances, but specified values apply to just the schema and data.

Minimum or Maximum Length Type Length Size
Maximum LOB length 2 GB
Maximum row size 64 K
Default maximum length (if length is not provided) 2 GB
Default inline length (if length is not provided) 10 K
Minimum length 100 bytes
Maximum size of a schema that is not column-based 16 MB
Maximum size of a binary-encoded Avro value 16 MB
Maximum size of a CSV value 16 MB