Examples for Creating External Tables

These examples show how to define external data with different protocols. Each CREATE EXTERNAL TABLE command can contain only one protocol.

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.

gpfdist -p 8081 -d /var/data/staging -l /home/gpadmin/log &

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

• Example 2—Multiple gpfdist instances

• Example 3—Multiple gpfdists instances

• Example 4—Single gpfdist instance with error logging

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

• Example 6—Multiple files in CSV format with header rows

• Example 7—Readable External Web Table with Script

• Example 8—Writable External Table with gpfdist

• Example 9—Writable External Web Table with Script

• Example 10—Readable and Writable External Tables with XML Transformations

Parent topic: Defining External Tables