DATASET Data Type Syntax | Teradata Vantage - 17.10 - DATASET Data Type Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1198-171K
Language
English (United States)

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.
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
  • FORMAT
  • TITLE
  • NAMED
  • DEFAULT NULL
  • COMPRESS USING and DECOMPRESS USING
For details on these data type attributes, see Teradata Vantageā„¢ - Data Types and Literals, B035-1143.