The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Csv parser - Evaluate header for each file



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 ?



Leave a Comment

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