17.10 - DATASET Constructor 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)
new DATASET (
  schema_expression,
  DATASET_expression,
  { AVRO | CSV [, { LATIN | UNICODE } ] }
)

Syntax Elements

schema_expression
Any expression that evaluates to a Teradata VARCHAR or VARBYTE conforming to the Avro or CSV schema specifications.
DATASET_expression
The CSV or Avro data value. If the constructor is for a CSV value, the value is a VARCHAR or CLOB in either the LATIN or UNICODE character set. If the constructor is for an Avro value, this value is VARBYTE or BLOB.
AVRO
CSV
The storage format of the new DATASET instance, either CSV or Avro.
LATIN
UNICODE
The character set of the returned 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 return CSV value is created in the current server character set.