Page 1 of 1
Loading 7-zip compressed files
Posted: Mon Nov 17, 2014 1:56 pm
by Josh
Does anyone know if Vertica can load 7-zip compressed files with the COPY command?
Re: Loading 7-zip compressed files
Posted: Tue Nov 18, 2014 11:54 pm
by JimKnicely
According to the docs the Vertica COPY command works with BZIP, GZIP and LZO compressed files...
Re: Loading 7-zip compressed files
Posted: Thu Nov 20, 2014 3:12 pm
by Josh
Thank you, Jim!
Re: Loading 7-zip compressed files
Posted: Mon May 23, 2016 3:02 am
by NorbertKrupa
You can always pipe the uncompression into a COPY...FROM STDIN.