17.10 - Rules and Restrictions - 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)

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.