If the system identifies incorrect data during loading (either
with the nzload
command or the CREATE EXTERNAL
TABLE command), it writes a message to the log file. There are two
types of errors:
- Malformed UTF-8
- The message displays multiple pairs of hexadecimal digits that
contain 1 - 4 bytes. The system encloses the incorrect bytes with
square brackets and provides a clue as to why it was rejected.
- Unassigned and unsupported characters
- If the characters you attempted to load are unassigned in Unicode or unsupported by Netezza Performance Server, the system displays the error message
as U + 4 or 5 digits.