|« PreviousNext »|
|Did this page help you? Yes | No | Tell us about it...|
To load data files that are compressed using gzip, include the GZIP option. To load data files that are compressed using lzop, include the LZOP option.
copy customer from 's3://mybucket/customer.lzo' credentials 'aws_access_key_id=
<secret-access-key>' delimiter '|' lzop;
If you use the GZIP option or LZOP option, ensure that all data files being loaded are gzip or lzop compressed. COPY does not support files compressed using the lzop --filter option.