Example 2—Hadoop file server (pxf)

=# 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.