I'm trying to mount csv files that have a CRLF as a row terminator, into Redshift Spectrum. However, it seems like I can only specify a single character as a row terminator. Does anyone know how to get around this?
Asked
Active
Viewed 235 times
0
-
How is it treating the lines if you do not specify the terminator? Is it reading the rows correctly, or is it inserting blank rows? – John Rotenstein Dec 18 '17 at 20:34
-
Hi John, if I don't specify, it inserts a blank row between each row, which means it's defaulting to CR, and then reads the LF as data. I'm trying to figure out how to specify CRLF as the EOL. – user1316437 Dec 18 '17 at 21:43