Escaping in Text Formatted Files Escaping in Text Formatted Files By default, the escape character is a \ (backslash) for text-formatted files. You can declare a different esca...

Loading Data with COPY 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-paralle...

Formatting Rows Formatting Rows HAWQ expects rows of data to be separated by the LF character (Line feed, 0x0A ), CR (Carriage return, 0x0D ), or CR followed by LF (CR+LF ,...

Formatting Rows Formatting Rows HAWQ expects rows of data to be separated by the LF character (Line feed, 0x0A ), CR (Carriage return, 0x0D ), or CR followed by LF (CR+LF ,...

createdb Synopsis Description Options Examples createdb Creates a new database. Synopsis createdb [< connection_options >] [< database_options >] [- e | -- ech...

SET Synopsis Description Parameters Examples Compatibility See Also SET Changes the value of a HAWQ configuration parameter. Synopsis SET [ SESSION | LOCAL ] <con...

Unloading Data Using COPY Unloading Data Using COPY COPY TO copies data from a table to a file (or standard input) on the HAWQ master host using a single process on the HAWQ m...

HDFS Catalog Cache HDFS Catalog Cache HDFS catalog cache is a caching service used by HAWQ master to determine the distribution information of table data on HDFS. HDFS is slow...

CREATE SEQUENCE Synopsis Description Parameters Notes Examples Compatibility See Also CREATE SEQUENCE Defines a new sequence generator. Synopsis CREATE [ TEMPORARY ...

Configuration File Format Configuration File Format The gpfdist configuration file uses the YAML 1.1 document format and implements a schema for defining the transformation pa...