The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

can I load a file with escape as including several chars?

ERROR 2737:  COPY ESCAPE must be a single character

 

I'm using  DELIMITER  ',' ENCLOSED BY  '"'  ESCAPE AS '\"'  NULL AS '\N'    while loading and several records got rejected coz it has a field which contains multiple  \"  within.

 

 

ex: "aaaaaaaa","bbbbbbb","cccccccc","dddddd","1","","","2045-07-01 05:02:03",,"m.mmmm.co.mm/apimm/app/setvvvvvvvvvvv.php?data={\cccccccccc\":0,\ccccccc\":2,\cccccccccc\":5,\ddddddd\":0}"

 

 

The last field in this record has  \ and \"  in it.

I've tried  ESCAPE AS '\"'   ,  ESCAPE AS '\'  ,  ESCAPE AS '\\"' but no go.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.