Data with backslash not loaded to vertica while copying from hdfs
I am trying to load data from hdfs using copy from hdfs. Some of the records contain backslash and they are not loaded. e.g.
2004-01-21|1243|11111|||C MXXAXE|GXEN MXCAXE\|123
I tried using Escape as '\', but that also doesn't work. Also tried all the below options.
DELIMITER '|' RECORD TERMINATOR E'\EOL\n' ESCAPE AS '\' DIRECT"
DELIMITER '|' RECORD TERMINATOR E'\EOL\n' ESCAPE AS '\\' DIRECT"
DELIMITER '|' RECORD TERMINATOR E'\EOL\n' ESCAPE AS E'\' DIRECT"
Please help resolve it.
0