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