Rules and Restrictions - Advanced SQL Engine - Teradata Database

DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
des1556232910526.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1198
lifecycle
previous
Product Category
Teradata Vantageā„¢

CSV_TO_AVRO converts CSV format data into DATASET STORAGE FORMAT AVRO or CSV data type instances. CSV_TO_AVRO produces one output column called 'data'.

The RETURNS clause defines the resulting Avro instance variable inline and maximum length. The default is to return a maximum size DATASET STORAGE FORMAT AVRO or CSV instance. All values are treated as strings, except the NULL fields are converted to null Avro or CSV values.

For more information about Rules and Restrictions, see CSV_TO_JSON.