Overview Creating and Managing Databases Creating and Managing Tablespaces Creating and Managing Schemas Creating and Managing Tables Identifying HAWQ Table HDFS Files Choosi...

Capture Row Formatting Errors and Declare a Reject Limit Capture Row Formatting Errors and Declare a Reject Limit The following SQL fragment captures formatting errors internal...

COPY Synopsis Description Parameters Notes File Formats Examples Compatibility See Also COPY Copies data between a file and a table. Synopsis COPY <table> [(< col...

Loading and Writing Non-HDFS Custom Data Loading and Writing Non-HDFS Custom Data HAWQ supports TEXT and CSV formats for importing and exporting data. You can load and write ...

pg_locks pg_locks The pg_locks view provides access to information about the locks held by open transactions within HAWQ. pg_locks contains one row per active lockable objec...

Disabling EXECUTE for Web or Writable External Tables Disabling EXECUTE for Web or Writable External Tables There is a security risk associated with allowing external tables to...

Load the Data Load the Data Create the tables with SQL statements based on the appropriate schema. There are no special requirements for the HAWQ tables that hold loaded data....

dropdb Synopsis Description Arguments Options Examples dropdb Removes a database. Synopsis dropdb [< connection_options >] [- e | -- echo ] [- i | -- interac...

pg_shdepend pg_shdepend The pg_shdepend system catalog table records the dependency relationships between database objects and shared objects, such as roles. This information ...

Handling Load Errors Handling Load Errors Readable external tables are most commonly used to select data to load into regular database tables. You use the CREATE TABLE AS SELEC...