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

Teradata Vantage™ - Native Object Store Getting Started Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1214-171K
Language
English (United States)

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 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 record size is equivalent to the dataset individual record size.

NOS automatically discovers the schema of the data, including the data format, field delimiter, column names, column data types, and object store path definition.

If there are more columns than the number of fields in some of the records, then NULLs are returned for those columns. Similarly if there are less columns than the fields in some of the records, the extra fields are ignored.

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.