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

Error with executing a copy command on a ascii 29 delimited file

Prasanna_1Prasanna_1
in General Discussion
Hi All,

I am getting this error executing the copy command in VSQL commandline below. Please let me know your thoughts.Thanks

copy sample.temp_full from local 'test.txt' delimiter E'\029'.

ERROR 2730. COPY delimiter must be a single character



Comments

  • Prasanna_1Prasanna_1
    the ascii delimiter I am referring to is Group Separator aka GS
  • Prasanna_1Prasanna_1
    My apologies! I was using the wrong delimiter type. 

    I am using the following command now and it works fine: copy sample.temp_full from local 'test.txt' delimiter E'\035'
  • BhawanaBhawana
    Hi Prasanna,

    I am glad it worked out well.

    Regards,

    Bhawana

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
Heading 1Heading 2
QuoteCodeSpoiler
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...

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