Rules and Restrictions - Advanced SQL Engine - Teradata Database

DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
amv1590702100517.ditamap
dita:ditavalPath
amv1590702100517.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.