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.
- 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 external object storage path definition.
If there are more columns than record fields, NULLs are returned for the extra columns. If there are fewer columns than record fields, 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, Teradata Vantage™ Native Object Store Orange Book - 17.20, TDN0009800-2 . Download from the attachments tab, , to the left.