RedShift - CSV load with line Break

Viewed 7563

Im trying to load a CSV file while loading I got the error

Delimited value missing end quote

CSV file Error line

enter image description here

REDSHIFT ERROR:

line_number     | 13
colname         | Comment
col_length      | 250
raw_line        |"123"|"123"|"xyz"|"2009-06-25 21:00:14.660000000"|"0"|""|""|""|""|""|"HI,

raw_field_value | HI, 
err_code        | 1214
err_reason      | Delimited value missing end quote
2 Answers
Related