Maximum and In-Line Length of a DATASET Instance

Teradata Vantageā„¢ DATASET Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1198-162K

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