Formatting Data Files Formatting Data Files When you use the HAWQ tools for loading and unloading data, you must specify how your data is formatted. COPY , CREATE EXTERNAL TABL...

GPORCA Limitations Unsupported SQL Query Features Performance Regressions GPORCA Limitations There are limitations in HAWQ when GPORCA is enabled. GPORCA and the legacy query...

Understanding the Fault Tolerance Service Viewing the Current Status of a Segment Understanding the Fault Tolerance Service The fault tolerance service (FTS) enables HAWQ to c...

Best Practices Best Practices This chapter provides best practices on using the components and features that are part of a HAWQ system. Best Practices for Configuring HAWQ Pa...

Elastic Query Execution Runtime Storage Physical Segments and Virtual Segments Virtual Segment Allocation Policy Elastic Query Execution Runtime HAWQ uses dynamically alloca...

Accessing HBase Data Prerequisites Syntax Column Mapping Row Key Direct Mapping Indirect Mapping (via Lookup Table) Example Accessing HBase Data Prerequisites Before t...

SHOW Synopsis Description Parameters Examples Compatibility See Also SHOW Shows the value of a system configuration parameter. Synopsis SHOW <configuration_parameter>...

Loading and Unloading Data Loading and Unloading Data The topics in this section describe methods for loading and writing data into and out of HAWQ, and how to format data file...

High Availability, Redundancy and Fault Tolerance About High Availability About Segment Fault Tolerance About Interconnect Redundancy High Availability, Redundancy and Fault...

pg_dumpall Synopsis Description Options Notes Examples See Also pg_dumpall Extracts all databases in a HAWQ system to a single script file or other archive file. Synop...