DATASET Constructor Syntax - 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ā„¢
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.