Pad Extra Columns in Bulk Insert

Hi All, We primarily use COPY FROM LOCAL command for bulk loading data to vertica. The files contains pipe(|) separated columns , one row per line. There are times when we want to add more columns to the existing vertica tables, without disturbing the file generation process (which can later catch up at its own pace). Are there some tweaks to COPY FROM LOCAL itself so that it can self append some empty columns at the end of each line, so that the whole process can continue smoothly ? Thanks in Advance, RAvi.


Leave a Comment

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