About CSV Format with Native Object Store | NOS | Teradata Vantage - About CSV Format - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Native Object Store Getting Started Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
zws1595641486108.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1214
lifecycle
previous
Product Category
Software
Teradata Vantage

Historically, a CSV file is stored in a database as one row, requiring a LOB data type. With NOS, each CSV file record is a single row in the foreign table.

Using NOS, the maximum payload size of a record is 16,776,192 bytes.
  • For UNICODE, that is equivalent to 8,388,096 characters.
  • For LATIN, that is equivalent to 16,776,192 characters.

The actual payload size is equivalent to the dataset individual record size.

Fields can be defined using one of the following methods:
  • Inside the CSV file as a header row with column names
  • In a schema that you create in Advanced SQL Engine and associate with your table, listing field names and customer delimiters

If no schema is provided, NOS assumes that the first record in the file is a header and that the fields are delimited by commas.

The provided examples assume that the CSV files have headers.

For supported CSV formats, see CSV External Files.

For instructions on working with CSV files without headers, see the Orange Book, Native Object Store: Teradata Vantageā„¢ Advanced SQL Engine, TDN0009800.