Rejected Reason: Too Many Columns Found

please share sample rows, table definition and your COPY statement.

Check the delimiter in your COPY command - if you are loading strings that may have the delimiter character within it, it may break the format and that would be perceived as too many columns. You could use the ENCLOSED BY option if your strings are quoted. See the section "Delimiting Characters (ENCLOSED BY)" at this link: https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BulkLoadCOPY/LoadingUTF-8FormatData.htm

In addition, try to use unprintable character as a delimiter, to eliminate the risk that your data include a delimiter character.
The following examples use \001 (CTRL-A) as field separator and \002 (CTRL-B) as record separator.
Export 2000 rows from a table to a file:
vsql -F $'\001' -R $'\002' -P null='REALNULL' -AXtnqc "select * from schema_name.table_name limit 2000" > file_name.tbl
Load the file data back to a table:
copy schema_name.table_name from 'file_name.tbl' delimiter E'\001' record terminator E'\002' null 'REALNULL' abort on error;

Enclosed by ' " ' command was what I was missing LenoyJ, thanks!