Example 2—Hadoop file server (pxf) v7.4

Suggest edits
=# CREATE WRITABLE EXTERNAL TABLE unload_expenses 
   ( LIKE expenses ) 
   LOCATION ('pxf://dir/path?PROFILE=hdfs:text') 
 FORMAT 'TEXT' (DELIMITER ',')
 DISTRIBUTED BY (exp_id);

You specify an HDFS directory for a writable external table that you create with the pxf protocol.

Parent topic: Defining a File-Based Writable External Table

← Prev

Example 1—WarehousePG file server (gpfdist)

↑ Up

Defining a File-Based Writable External Table

Next →

Defining a Command-Based Writable External Web Table