Verify you are not pointing to the wrong container having files with same name.
Verify number of columns in external table are matching to that in file.
If you take closer look at file columns. you will notice a column is having comma in column name i.e. CITY,ST ZIP(3). This is creating the issue. As we have specified FIELD_TERMINATOR = ',', this is making one column as two different columns. Hence, we are getting error: “Too many columns in the line.”
The column definitions, data types and number of columns, must match the data in files. If there is a mismatch, the data rows will be rejected when querying the actual data.