16.20 - Maximum and In-Line Length of a DATASET Instance - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ DATASET Data Type

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
pgs1512082344257.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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