Loading 7-zip compressed files
Moderator: NorbertKrupa
Loading 7-zip compressed files
Does anyone know if Vertica can load 7-zip compressed files with the COPY command?
Thank you!
Joshua
Joshua
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Loading 7-zip compressed files
According to the docs the Vertica COPY command works with BZIP, GZIP and LZO compressed files...
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Loading 7-zip compressed files
You can always pipe the uncompression into a COPY...FROM STDIN.
Checkout vertica.tips for more Vertica resources.