Suppose you have a CSV file and you want to copy some, but not all, of its contents into a Vertica table. There are two ways you can to do this:
Let’s see how this works.
- Use the SKIP keyword with COPY.
- Use the head or tail Linux command.
Continue reading here:
https://my.vertica.com/blog/filtering-d ... g-vertica/