it often happened some rows with format issue, data type issue rejected by copy command while try load it by copy command. the query return succeed but some of data rejected.
To do troubleshooting
save Rejected Data and Exceptions
COPY large_tbl FROM :file1 ON site01,
:file2 O...