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


PloadDelimitedSource does not log rejected data properly — Vertica Forum

PloadDelimitedSource does not log rejected data properly

It looks like PloadDelimitedSource is not as good with logging as COPY command is. We are running into scenarios where when we run the command: copy {table} with source PloadDelimitedSource(file='/home/dbadmin/bla.txt') delimiter E'\007' no escape direct; only the exception file is created, but there is no associated file which contains the actual rejected rows. when we run the command: copy {table} with source PloadDelimitedSource(file='/home/dbadmin/bla.txt') delimiter E'\007' rejected data '/home/dbadmin/copyerrors/' no escape direct; the file with the actual rejected rows is generated, but does not have the associated *-copy-from-exceptions file. Is it possible to enforce PloadDelimitedSource utility to work like COPY command and generate both the files ?

Comments

  • the first command should have just been: copy table with source PloadDelimitedSource(file='/home/dbadmin/bla.txt') delimiter '\\007' no escape direct; How can I edit my post?
  • It seems that COPY's REJECTED DATA and EXCEPTIONS clauses only work with "COPY LOCAL".

    However, for most users, all COPY'ing occurs locally, and we need a way to get at REJECTED DAT Aand their corresponding EXCEPTIONS, even if other methods of loading data are being used, such as pload (PloadDelimitedSource)


Leave a Comment

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