Loading 7-zip compressed files

Moderator: NorbertKrupa

Post Reply
User avatar
Josh
Intermediate
Intermediate
Posts: 106
Joined: Thu Jan 26, 2012 9:38 pm

Loading 7-zip compressed files

Post by Josh » Mon Nov 17, 2014 1:56 pm

Does anyone know if Vertica can load 7-zip compressed files with the COPY command?
Thank you!
Joshua

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

Re: Loading 7-zip compressed files

Post by JimKnicely » Tue Nov 18, 2014 11:54 pm

According to the docs the Vertica COPY command works with BZIP, GZIP and LZO compressed files...
Jim Knicely

Image

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

User avatar
Josh
Intermediate
Intermediate
Posts: 106
Joined: Thu Jan 26, 2012 9:38 pm

Re: Loading 7-zip compressed files

Post by Josh » Thu Nov 20, 2014 3:12 pm

Thank you, Jim!
Thank you!
Joshua

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Loading 7-zip compressed files

Post by NorbertKrupa » Mon May 23, 2016 3:02 am

You can always pipe the uncompression into a COPY...FROM STDIN.
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “Vertica Data Load”