Example 2—Hadoop file server (pxf)
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.