1. =# CREATE WRITABLE EXTERNAL TABLE unload_expenses
2. ( LIKE expenses )
3. LOCATION ('pxf://dir/path?PROFILE=hdfs:text')
4. FORMAT 'TEXT' (DELIMITER ',')
5. 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