Troubleshooting Query Performance Issues How to Investigate Query Performance Issues Rejection of Query Resource Requests Queries Cancelled Due to High VMEM Usage Segments Do N...
pg_filespace_entry pg_filespace_entry A tablespace requires a file system location to store its database files. In HAWQ, the master and each segment needs its own distinct stor...
pg_filespace pg_filespace The pg_filespace table contains information about the filespaces created in a HAWQ system. Every system contains a default filespace, pg_system , whi...
ALTER RESOURCE QUEUE Synopsis Description Parameters Examples Compatibility See Also ALTER RESOURCE QUEUE Modify an existing resource queue. Synopsis ALTER RESOURCE QU...
Best Practices for Configuring Resource Management Best Practices for Configuring Resource Management When configuring resource management, you can apply certain best practices...
Best Practices for Configuring Resource Management Best Practices for Configuring Resource Management When configuring resource management, you can apply certain best practices...
Accessing File-Based External Tables Accessing File-Based External Tables External tables enable accessing external files as if they are regular database tables. They are often...
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...