The following shows the syntax when you use a DATASET data type in a data type declaration phrase. For example, this syntax is used when defining a table column to be DATASET type.
DATASET [ ( maxlength ) ] [ INLINE LENGTH integer ] STORAGE FORMAT [ AVRO | CSV [ CHARACTER SET { LATIN | UNICODE } ] ] [ attributes ] [...]
Syntax Elements
- maxlength
- [Optional] A maximum length may be specified, in terms of bytes, subject to the absolute maximum of 2 GB which is chosen based on the maximum size of a LOB in Teradata. If not specified, the default maximum length is the absolute maximum.
- INLINE LENGTH integer
- [Optional] An inline length may be specified, in terms of bytes, subject to the absolute maximum of 64,000. If not specified, the default is 10,000.
- STORAGE FORMAT
- The built-in storage format. The supported types are AVRO and CSV.The CSV and AVRO DATASET data types are only supported on the Block File System on the primary cluster. They are not available for the Object File System.
- CHARACTER SET
- [Optional] The optional character set for the CSV storage format. The supported character sets are UNICODE or LATIN. The default character set used is the current server character set of the session.
- attributes
- The following data type attributes are supported for the DATASET type.
- NULL and NOT NULL Phrase
- FORMAT
- TITLE Phrase
- NAMED Phrase
- DEFAULT NULL
- COMPRESS USING and DECOMPRESS USING (see COMPRESS and DECOMPRESS Syntax)