RedShift – CSV load with line Break

Home / Uncategorized / RedShift – CSV load with line Break

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

Delimited value missing end quote

CSV file Error line

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


Answer:

Read more

Leave a Reply

Your email address will not be published. Required fields are marked *