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

DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
des1556232910526.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1198
lifecycle
previous
Product Category
Teradata Vantageā„¢

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