Examples for Creating External Tables

Note: When using IPv6, always enclose the numeric IP addresses in square brackets.

Start gpfdist before you create external tables with the gpfdist protocol. The following code starts the gpfdist file server program in the background on port 8081 serving files from directory /var/data/staging. The logs are saved in /home/gpadmin/log.

• Example 1—Single gpfdist instance on single-NIC machine

• Example 5—TEXT Format on a Hadoop Distributed File Server

• Example 8—Writable External Table with gpfdist

Parent topic: