postgresql - RedShift - CSV load with line Break -
im trying load csv file while loading got 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
you'll need escape newline characters in source data , specify escape
option in copy
statement. please have @ "preparing files copy escape option" more details.
Comments
Post a Comment