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

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

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