17.05 - Rules and Restrictions - Teradata Database

Teradata Vantageā„¢ - DATASET Data Type

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1198-170K

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.