Working with File-Based External Tables Working with File-Based External Tables External tables provide access to data stored in data sources outside of HAWQ as if the data wer...

Data Types Table 1. HAWQ Built-in Data Types Time Zones Date and Time Configuration Files Polymorphic Types Data Types This topic provides a reference of the data types sup...

Query Performance How to Investigate Query Performance Issues Data Locality Statistics Number of Virtual Segments Factors Impacting Query Performance General Guidelines Qu...

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

Using Kerberos Authentication Prerequisites Procedure Using Kerberos Authentication Kerberos is an encrpyted network authentication protocol for client/server applications. K...

Table Distribution and Storage Table Distribution Policy Data Locality External Data Access Table Distribution and Storage HAWQ stores all table data, except the system tabl...

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

Enabling GPORCA Setting the optimizer_analyze_root_partition Parameter Enabling GPORCA for a System Enabling GPORCA for a Database Enabling GPORCA for a Session or a Query ...

Creating and Managing Tablespaces Creating a Filespace To create a filespace using hawq filespace Creating a Tablespace Using a Tablespace to Store Database Objects Viewing Exi...

gpfdist Protocol gpfdist Protocol The gpfdist:// protocol is used in a URI to reference a running gpfdist instance. The gpfdist utility serves external data files from a dir...