Skip to main content

Bulk Load (Copy) - First n columns.


Ilan_1
  • Participating Frequently
Hello, I have a table with 300+ columns and I am using COPY command to load the file to the table. The issue I have is the feed or the csv file I have may only 1st 100 column values or 1st n column values. How do I let COPY command to know if the feed does not have values for those columns insert NULL values and load the rest without failing ?.

2 replies

Forum|alt.badge.img+2
  • Participating Frequently
  • July 13, 2013
Hi, Take a look at the TRAILING NULLCOLS argument to COPY: https://my.vertica.com/docs/6.1.x/HTML/index.htm#1668.htm Does that do what you're looking for? Adam

Ilan_1
  • Author
  • Participating Frequently
  • July 15, 2013
Thanks Adam that solved my issue.