COPY: What are different type of
Parsers COPY uses
By
default, COPY uses the DELIMITER parser to load raw data
into the database.
We do
not specify the DELIMITER parser directly; absence of a specific
parser indicates the default.
Raw
input data must be in UTF-8, delimited text format.
If the
data does not consist of delimited text, we should specify the correct parser
COPY should use
- NATIVE
- NATIVE VARCHAR
- FIXEDWIDTH
- ORC
We
cannot mix raw data types that require different parsers (such as NATIVE and
FIXEDWIDTH) in a single bulk load COPY statement.
No comments:
Post a Comment