Setting Compression Options for Hadoop Writable External Tables
A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.
Setting Compression Options for Hadoop Writable External Tables
Compression options for Hadoop Writable External Tables use the form of a URI query and begin with a question mark. Specify multiple compression options with an ampersand (&).
| Compression Option | Values | Default Value |
|---|---|---|
| compress | true or false | false |
| compression_type | BLOCK or RECORD |
RECORD
For AVRO format, compression_type must be block if compress is true. |
| codec | Codec class name |
GzipCodec for text format
and DefaultCodec for gphdfs_export
format. For AVRO format, the value is either deflate (the default) or snappy |
| codec_level (for AVRO format and deflate codec only) | integer between 1 and 9 |
6
The level controls the trade-off between speed and compression. Valid values are 1 to 9, where 1 is the fastest and 9 is the most compressed. |
Place compression options in the query portion of the URI.