Example 9—Writable External Web Table with Script
A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.
Example 9—Writable External Web Table with Script
Creates a writable external web table, campaign_out, that pipes output data
received by the segments to an executable script,
to_adreport_etl.sh:
=# CREATE WRITABLE EXTERNAL WEB TABLE campaign_out (LIKE campaign) EXECUTE '/var/unload_scripts/to_adreport_etl.sh' FORMAT 'TEXT' (DELIMITER '|');