Filtering Data While Loading into Vertica

Post links to your favorite Vertica related material in this forum

Moderator: NorbertKrupa

Post Reply
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1737
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Filtering Data While Loading into Vertica

Post by JimKnicely » Wed Mar 22, 2017 1:37 pm

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:
  • Use the SKIP keyword with COPY.
  • Use the head or tail Linux command.
Let’s see how this works.

Continue reading here:
https://my.vertica.com/blog/filtering-d ... g-vertica/
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”

Who is online

Users browsing this forum: No registered users and 1 guest