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 (&).

Table 1. Compression Options
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.