We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Error with executing a copy command on a ascii 29 delimited file — Vertica Forum
Options

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
SpoilerCodeQuote
Heading 2Heading 1
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 ...