Maximum and In-Line Length of a DATASET Instance - Analytics Database - Teradata Vantage

DATASET Data Type

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
bka1628112240653.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ekk1458586304878
lifecycle
latest
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