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...

System Views System Views HAWQ provides the following system views not available in PostgreSQL. pg_max_external_files (shows number of external table files allowed per segmen...

CREATE TABLE AS Synopsis Description Parameters Notes Examples Compatibility See Also CREATE TABLE AS Defines a new table from the results of a query. Synopsis CREATE...

Accessing JSON File Data Prerequisites Working with JSON Files JSON to HAWQ Data Type Mapping JSON File Read Modes Loading JSON Data to HDFS Querying External JSON Data Exampl...

Configuring PXF Setting up the Java Classpath Setting up the JVM Command Line Options for the PXF Service Using PXF on a Secure HDFS Cluster Requirements Credentials for Remote...

System Views System Views HAWQ provides the following system views not available in PostgreSQL. pg_max_external_files (shows number of external table files allowed per segmen...

Installing gpfdist Installing gpfdist You may choose to run gpfdist from a machine other than the HAWQ master, such as on a machine devoted to ETL processing. To install gpfdi...

FETCH Synopsis Description Parameters Notes Examples Compatibility See Also FETCH Retrieves rows from a query using a cursor. Synopsis FETCH [ <forward_direction> ...

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

gp_version_at_initdb gp_version_at_initdb The gp_version_at_initdb table is populated on the master and each segment in the HAWQ system. It identifies the version of HAWQ used...