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


Csv parser - Evaluate header for each file — Vertica Forum

Csv parser - Evaluate header for each file

Hi,

 

I have multiple CSV files in a directory. They may have different column combinations, but I would like to COPY them all with a single command. But the FDelimitedParser only evaluates the header row for the first file, then rejects all rows that do not fit - ie. all rows from most of the other files.

 

1 - Is this expected behavior, and if so, why ?

 

2 - I want it to evaluate the headers for each file, is there a way ?

 

Thanks

Leave a Comment

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