17.10 - CreateDATASET 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)
CreateDATASET (
  schema_expression,
  data_expression,
  { AVRO | CSV [ , { LATIN | UNICODE } ] }
)

Syntax Elements

schema_expression
Any expression that evaluates to the following Teradata data types conforming to the schema specifications:
  • CHAR
  • VARCHAR
  • CLOB
  • JSON
  • BYTE
  • VARBYTE
  • BLOB
If the Schema parameter is null, it is assumed the instance is being loaded into a column with a column-based schema. If not, and you use the instance without providing a schema (for example, writing the instance out to a table, or searching using dot notation), an error occurs.
The schema data is provided as a CHAR/VARCHAR/CLOB in either the LATIN or UNICODE character set, or as a BYTE/VARBYTE/BLOB representing the UTF8 encoding of the schema. The schemas provided as BYTE/VARBYTE/BLOB data are not null-terminated.
data_expression
Any expression that evaluates to Teradata BYTE/VARBYTE/BLOB/CLOB data.
A BYTE/VARBYTE/BLOB containing the binary-encoded self-describing data value. Data can be specified in any way Vantage currently allows for function parameters. If validation is enabled, and a null value does not complete the specified schema, an error occurs. Otherwise, the data is accepted.
AVRO
CSV
Specify the name of the storage format. Any other value, including a null or omitted value, are invalid.
LATIN
UNICODE
The character set of the created CSV DATASET value, either LATIN or UNICODE. You can specify the character set only for the CSV storage format. If this parameter is omitted for a CSV value, the CSV value is created in the default server character set.