Loading Data with COPY
COPY FROM copies data from a file or standard input into a table and appends the data to the table contents.
COPY is non-parallel: data is loaded in a single process using the HAWQ master instance. Using
COPY is only recommended for very small data files.
COPY source file must be accessible to the master host. Specify the
COPY source file name relative to the master host location.
HAWQ copies data from
STDOUT using the connection between the client and the master server.