Column specification

The columns to be loaded into the table can optionally be specified as a list of columns in the order they are to be loaded from the file. Any columns omitted from the list will receive a null value at load time.

If the columns to loaded are not defined, it is assumed that all columns are contained in the file and their order is the same as that of the fields in the file.

The ā€˜cā€™ switch is used to define the column list.

Have more questions? Submit a request


Article is closed for comments.

Powered by Zendesk