Example 2—Hadoop file server (gphdfs)

Example 2—Hadoop file server (gphdfs)

=# CREATE WRITABLE EXTERNAL TABLE unload_expenses 
   ( LIKE expenses ) 
   LOCATION ('gphdfs://hdfslhost-1:8081/path') 
 FORMAT 'TEXT' (DELIMITER ',')
 DISTRIBUTED BY (exp_id);

You can only specify a directory for a writable external table with the gphdfs protocol. (You can only specify one file for a readable external table with the gphdfs protocol)

Note: The default port number is 9000.