Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id AA633200C0E for ; Wed, 1 Feb 2017 18:35:47 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id A8DA2160B46; Wed, 1 Feb 2017 17:35:47 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 82F20160B63 for ; Wed, 1 Feb 2017 18:35:45 +0100 (CET) Received: (qmail 88868 invoked by uid 500); 1 Feb 2017 17:35:44 -0000 Mailing-List: contact commits-help@hawq.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hawq.incubator.apache.org Delivered-To: mailing list commits@hawq.incubator.apache.org Received: (qmail 88859 invoked by uid 99); 1 Feb 2017 17:35:44 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Feb 2017 17:35:44 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 100981803A3 for ; Wed, 1 Feb 2017 17:35:44 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -5.019 X-Spam-Level: X-Spam-Status: No, score=-5.019 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LAZY_DOMAIN_SECURITY=1, KAM_MANYCOMMENTS=1.2, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-2.999] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id hdVarNNqnDgu for ; Wed, 1 Feb 2017 17:35:29 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with SMTP id C27BD5F238 for ; Wed, 1 Feb 2017 17:35:26 +0000 (UTC) Received: (qmail 88022 invoked by uid 99); 1 Feb 2017 17:35:26 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Feb 2017 17:35:26 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id D0938DFCF5; Wed, 1 Feb 2017 17:35:25 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: yozie@apache.org To: commits@hawq.incubator.apache.org Date: Wed, 01 Feb 2017 17:35:28 -0000 Message-Id: In-Reply-To: <4c7b50d5708f493b93b6edc2632e7250@git.apache.org> References: <4c7b50d5708f493b93b6edc2632e7250@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [4/7] incubator-hawq-docs git commit: HAWQ-1305 Add apache license header to doc source archived-at: Wed, 01 Feb 2017 17:35:47 -0000 http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/query/gporca/query-gporca-features.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/query/gporca/query-gporca-features.html.md.erb b/markdown/query/gporca/query-gporca-features.html.md.erb index 4941866..6693425 100644 --- a/markdown/query/gporca/query-gporca-features.html.md.erb +++ b/markdown/query/gporca/query-gporca-features.html.md.erb @@ -2,6 +2,25 @@ title: GPORCA Features and Enhancements --- + + GPORCA includes enhancements for specific types of queries and operations. GPORCA also includes these optimization enhancements: - Improved join ordering http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/query/gporca/query-gporca-limitations.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/query/gporca/query-gporca-limitations.html.md.erb b/markdown/query/gporca/query-gporca-limitations.html.md.erb index b63f0d2..2e7aa6d 100644 --- a/markdown/query/gporca/query-gporca-limitations.html.md.erb +++ b/markdown/query/gporca/query-gporca-limitations.html.md.erb @@ -2,6 +2,25 @@ title: GPORCA Limitations --- + + There are limitations in HAWQ when GPORCA is enabled. GPORCA and the legacy query optimizer currently coexist in HAWQ because GPORCA does not support all HAWQ features. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/query/gporca/query-gporca-notes.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/query/gporca/query-gporca-notes.html.md.erb b/markdown/query/gporca/query-gporca-notes.html.md.erb index ed943e4..3747c80 100644 --- a/markdown/query/gporca/query-gporca-notes.html.md.erb +++ b/markdown/query/gporca/query-gporca-notes.html.md.erb @@ -2,6 +2,25 @@ title: Considerations when Using GPORCA --- + + To execute queries optimally with GPORCA, consider certain criteria for the query. Ensure the following criteria are met: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/query/gporca/query-gporca-optimizer.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/query/gporca/query-gporca-optimizer.html.md.erb b/markdown/query/gporca/query-gporca-optimizer.html.md.erb index 11814f8..b297b96 100644 --- a/markdown/query/gporca/query-gporca-optimizer.html.md.erb +++ b/markdown/query/gporca/query-gporca-optimizer.html.md.erb @@ -2,6 +2,25 @@ title: About GPORCA --- + + In HAWQ, you can use GPORCA or the legacy query optimizer. **Note:** To use the GPORCA query optimizer, you must be running a version of HAWQ built with GPORCA, and GPORCA must be enabled in your HAWQ deployment. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/query/gporca/query-gporca-overview.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/query/gporca/query-gporca-overview.html.md.erb b/markdown/query/gporca/query-gporca-overview.html.md.erb index 56f97eb..c18b4c2 100644 --- a/markdown/query/gporca/query-gporca-overview.html.md.erb +++ b/markdown/query/gporca/query-gporca-overview.html.md.erb @@ -2,6 +2,25 @@ title: Overview of GPORCA --- + + GPORCA extends the planning and optimization capabilities of the HAWQ legacy optimizer. GPORCA is extensible and achieves better optimization in multi-core architecture environments. When GPORCA is available in your HAWQ installation and enabled, HAWQ uses GPORCA to generate an execution plan for a query when possible. GPORCA also enhances HAWQ query performance tuning in the following areas: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/query/query-performance.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/query/query-performance.html.md.erb b/markdown/query/query-performance.html.md.erb index 981d77b..045a978 100644 --- a/markdown/query/query-performance.html.md.erb +++ b/markdown/query/query-performance.html.md.erb @@ -2,6 +2,25 @@ title: Query Performance --- + + HAWQ dynamically allocates resources to queries. Query performance depends on several factors such as data locality, number of virtual segments used for the query and general cluster health. - Dynamic Partition Elimination http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/query/query-profiling.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/query/query-profiling.html.md.erb b/markdown/query/query-profiling.html.md.erb index ea20e0a..fccef18 100644 --- a/markdown/query/query-profiling.html.md.erb +++ b/markdown/query/query-profiling.html.md.erb @@ -2,6 +2,25 @@ title: Query Profiling --- + + Examine the query plans of poorly performing queries to identify possible performance tuning opportunities. HAWQ devises a *query plan* for each query. Choosing the right query plan to match the query and data structure is necessary for good performance. A query plan defines how HAWQ will run the query in the parallel execution environment. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/query/query.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/query/query.html.md.erb b/markdown/query/query.html.md.erb index 9c218c7..7df1a14 100644 --- a/markdown/query/query.html.md.erb +++ b/markdown/query/query.html.md.erb @@ -2,6 +2,25 @@ title: Querying Data --- + + This topic provides information about using SQL in HAWQ databases. You enter SQL statements called queries to view and analyze data in a database using the `psql` interactive SQL client and other client tools. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/CharacterSetSupportReference.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/CharacterSetSupportReference.html.md.erb b/markdown/reference/CharacterSetSupportReference.html.md.erb index 8a12471..d978ecf 100644 --- a/markdown/reference/CharacterSetSupportReference.html.md.erb +++ b/markdown/reference/CharacterSetSupportReference.html.md.erb @@ -2,6 +2,25 @@ title: Character Set Support Reference --- + + This topic provides a referene of the character sets supported in HAWQ. The character set support in HAWQ allows you to store text in a variety of character sets, including single-byte character sets such as the ISO 8859 series and multiple-byte character sets such as EUC (Extended Unix Code), UTF-8, and Mule internal code. All supported character sets can be used transparently by clients, but a few are not supported for use within the server (that is, as a server-side encoding). The default character set is selected while initializing your HAWQ using `hawq init.` It can be overridden when you create a database, so you can have multiple databases each with a different character set. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/HAWQDataTypes.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/HAWQDataTypes.html.md.erb b/markdown/reference/HAWQDataTypes.html.md.erb index fe5cff7..fe31458 100644 --- a/markdown/reference/HAWQDataTypes.html.md.erb +++ b/markdown/reference/HAWQDataTypes.html.md.erb @@ -2,6 +2,25 @@ title: Data Types --- + + This topic provides a reference of the data types supported in HAWQ. HAWQ has a rich set of native data types available to users. Users may also define new data types using the `CREATE TYPE` command. This reference shows all of the built-in data types. In addition to the types listed here, there are also some internally used data types, such as **oid** (object identifier), but those are not documented in this guide. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/HAWQEnvironmentVariables.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/HAWQEnvironmentVariables.html.md.erb b/markdown/reference/HAWQEnvironmentVariables.html.md.erb index ce21798..2cf10ea 100644 --- a/markdown/reference/HAWQEnvironmentVariables.html.md.erb +++ b/markdown/reference/HAWQEnvironmentVariables.html.md.erb @@ -2,6 +2,25 @@ title: Environment Variables --- + + This topic contains a reference of the environment variables that you set for HAWQ. Set these in your user’s startup shell profile (such as `~/.bashrc` or `~/.bash_profile`), or in `/etc/profile`, if you want to set them for all users. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/HAWQSampleSiteConfig.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/HAWQSampleSiteConfig.html.md.erb b/markdown/reference/HAWQSampleSiteConfig.html.md.erb index d4cae5a..1161087 100644 --- a/markdown/reference/HAWQSampleSiteConfig.html.md.erb +++ b/markdown/reference/HAWQSampleSiteConfig.html.md.erb @@ -2,6 +2,25 @@ title: Sample hawq-site.xml Configuration File --- + + ```xml http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/HAWQSiteConfig.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/HAWQSiteConfig.html.md.erb b/markdown/reference/HAWQSiteConfig.html.md.erb index 3d20297..578a883 100644 --- a/markdown/reference/HAWQSiteConfig.html.md.erb +++ b/markdown/reference/HAWQSiteConfig.html.md.erb @@ -2,6 +2,25 @@ title: Server Configuration Parameter Reference --- + + This section describes all server configuration guc/parameters that are available in HAWQ. Configuration guc/parameters are located in `$GPHOME/etc/hawq-site.xml`. This configuration file resides on all HAWQ instances and is managed either by Ambari or by using the `hawq config` utility. On HAWQ clusters installed and managed by Ambari, always use the Ambari administration interface, and not `hawq config`, to configure HAWQ properties. Ambari will overwrite any changes made using `hawq config`. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/HDFSConfigurationParameterReference.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/HDFSConfigurationParameterReference.html.md.erb b/markdown/reference/HDFSConfigurationParameterReference.html.md.erb index aef4ed2..28b863a 100644 --- a/markdown/reference/HDFSConfigurationParameterReference.html.md.erb +++ b/markdown/reference/HDFSConfigurationParameterReference.html.md.erb @@ -2,6 +2,25 @@ title: HDFS Configuration Reference --- + + This reference page describes HDFS configuration values that are configured for HAWQ either within `hdfs-site.xml`, `core-site.xml`, or `hdfs-client.xml`. ## HDFS Site Configuration (hdfs-site.xml and core-site.xml) http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/SQLCommandReference.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/SQLCommandReference.html.md.erb b/markdown/reference/SQLCommandReference.html.md.erb index 7bbe625..44938ee 100644 --- a/markdown/reference/SQLCommandReference.html.md.erb +++ b/markdown/reference/SQLCommandReference.html.md.erb @@ -2,6 +2,25 @@ title: SQL Commands --- + + This section contains a description and the syntax of the SQL commands supported by HAWQ. - **[ABORT](../reference/sql/ABORT.html)** http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/catalog_ref-html.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/catalog_ref-html.html.md.erb b/markdown/reference/catalog/catalog_ref-html.html.md.erb index 864f106..bf73d47 100644 --- a/markdown/reference/catalog/catalog_ref-html.html.md.erb +++ b/markdown/reference/catalog/catalog_ref-html.html.md.erb @@ -2,6 +2,25 @@ title: System Catalogs Definitions --- + + System catalog table and view definitions in alphabetical order. - **[gp\_configuration\_history](../../reference/catalog/gp_configuration_history.html)** http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/catalog_ref-tables.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/catalog_ref-tables.html.md.erb b/markdown/reference/catalog/catalog_ref-tables.html.md.erb index 61aa936..4e1c745 100644 --- a/markdown/reference/catalog/catalog_ref-tables.html.md.erb +++ b/markdown/reference/catalog/catalog_ref-tables.html.md.erb @@ -2,6 +2,25 @@ title: System Tables --- + + This topic lists the system tables included in HAWQ. - gp\_configuration (Deprecated. See [gp\_segment\_configuration](gp_segment_configuration.html#topic1).) http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/catalog_ref-views.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/catalog_ref-views.html.md.erb b/markdown/reference/catalog/catalog_ref-views.html.md.erb index 4a7ad74..94b1c39 100644 --- a/markdown/reference/catalog/catalog_ref-views.html.md.erb +++ b/markdown/reference/catalog/catalog_ref-views.html.md.erb @@ -2,6 +2,25 @@ title: System Views --- + + HAWQ provides the following system views not available in PostgreSQL. - pg\_max\_external\_files (shows number of external table files allowed per segment host when using the file:// protocol) http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/catalog_ref.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/catalog_ref.html.md.erb b/markdown/reference/catalog/catalog_ref.html.md.erb index 143091f..142e3c3 100644 --- a/markdown/reference/catalog/catalog_ref.html.md.erb +++ b/markdown/reference/catalog/catalog_ref.html.md.erb @@ -2,6 +2,25 @@ title: System Catalog Reference --- + + This reference describes the HAWQ system catalog tables and views. System tables prefixed with '`gp_`' relate to the parallel features of HAWQ. Tables prefixed with '`pg_`' are either standard PostgreSQL system catalog tables supported in HAWQ, or are related to features HAWQ that provides to enhance PostgreSQL for data warehousing workloads. Note that the global system catalog for HAWQ resides on the master instance. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/gp_configuration_history.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/gp_configuration_history.html.md.erb b/markdown/reference/catalog/gp_configuration_history.html.md.erb index e501d55..d89b0e2 100644 --- a/markdown/reference/catalog/gp_configuration_history.html.md.erb +++ b/markdown/reference/catalog/gp_configuration_history.html.md.erb @@ -2,6 +2,25 @@ title: gp_configuration_history --- + + The `gp_configuration_history` table contains information about system changes related to fault detection and recovery operations. The HAWQ [fault tolerance service](../../admin/FaultTolerance.html) logs data to this table, as do certain related management utilities such as `hawq init`. For example, when you add a new segment to the system, records for these events are logged to `gp_configuration_history`. If a segment is marked as down by the fault tolerance service in the [gp\_segment\_configuration](gp_segment_configuration.html) catalog table, then the reason for being marked as down is recorded in this table. The event descriptions stored in this table may be helpful for troubleshooting serious system issues in collaboration with HAWQ support technicians. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/gp_distribution_policy.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/gp_distribution_policy.html.md.erb b/markdown/reference/catalog/gp_distribution_policy.html.md.erb index 6b227e6..4b205f1 100644 --- a/markdown/reference/catalog/gp_distribution_policy.html.md.erb +++ b/markdown/reference/catalog/gp_distribution_policy.html.md.erb @@ -2,6 +2,25 @@ title: gp_distribution_policy --- + + The `gp_distribution_policy` table contains information about HAWQ tables and their policy for distributing table data across the segments. This table is populated only on the master. This table is not globally shared, meaning each database has its own copy of this table. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/gp_global_sequence.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/gp_global_sequence.html.md.erb b/markdown/reference/catalog/gp_global_sequence.html.md.erb index ac2ff2f..7774e09 100644 --- a/markdown/reference/catalog/gp_global_sequence.html.md.erb +++ b/markdown/reference/catalog/gp_global_sequence.html.md.erb @@ -2,6 +2,25 @@ title: gp_global_sequence --- + + The `gp_global_sequence` table contains the log sequence number position in the transaction log. This table is used by persistent tables. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/gp_master_mirroring.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/gp_master_mirroring.html.md.erb b/markdown/reference/catalog/gp_master_mirroring.html.md.erb index fa7ea18..fbb5fce 100644 --- a/markdown/reference/catalog/gp_master_mirroring.html.md.erb +++ b/markdown/reference/catalog/gp_master_mirroring.html.md.erb @@ -2,6 +2,25 @@ title: gp_master_mirroring --- + + The `gp_master_mirroring` table contains state information about the standby master host and its associated write-ahead log (WAL) replication process. If this synchronization process (`gpsyncagent`) fails on the standby master, it may not always be noticeable to users of the system. This catalog is a place where HAWQ administrators can check to see if the standby master is current and fully synchronized. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/gp_persistent_database_node.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/gp_persistent_database_node.html.md.erb b/markdown/reference/catalog/gp_persistent_database_node.html.md.erb index 2a3537a..3f154a0 100644 --- a/markdown/reference/catalog/gp_persistent_database_node.html.md.erb +++ b/markdown/reference/catalog/gp_persistent_database_node.html.md.erb @@ -2,6 +2,25 @@ title: gp_persistent_database_node --- + + The `gp_persistent_database_node` table keeps track of the status of file system objects in relation to the transaction status of database objects. This information is used to make sure the state of the system catalogs and the file system files persisted to disk are synchronized. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/gp_persistent_filespace_node.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/gp_persistent_filespace_node.html.md.erb b/markdown/reference/catalog/gp_persistent_filespace_node.html.md.erb index b682a88..6033aff 100644 --- a/markdown/reference/catalog/gp_persistent_filespace_node.html.md.erb +++ b/markdown/reference/catalog/gp_persistent_filespace_node.html.md.erb @@ -2,6 +2,25 @@ title: gp_persistent_filespace_node --- + + The `gp_persistent_filespace_node` table keeps track of the status of file system objects in relation to the transaction status of filespace objects. This information is used to make sure the state of the system catalogs and the file system files persisted to disk are synchronized. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/gp_persistent_relation_node.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/gp_persistent_relation_node.html.md.erb b/markdown/reference/catalog/gp_persistent_relation_node.html.md.erb index f141cf7..a7c5041 100644 --- a/markdown/reference/catalog/gp_persistent_relation_node.html.md.erb +++ b/markdown/reference/catalog/gp_persistent_relation_node.html.md.erb @@ -2,6 +2,25 @@ title: gp_persistent_relation_node --- + + The `gp_persistent_relation_node` table table keeps track of the status of file system objects in relation to the transaction status of relation objects (tables, view, indexes, and so on). This information is used to make sure the state of the system catalogs and the file system files persisted to disk are synchronized. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/gp_persistent_relfile_node.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/gp_persistent_relfile_node.html.md.erb b/markdown/reference/catalog/gp_persistent_relfile_node.html.md.erb index 6d24a41..90c0e26 100644 --- a/markdown/reference/catalog/gp_persistent_relfile_node.html.md.erb +++ b/markdown/reference/catalog/gp_persistent_relfile_node.html.md.erb @@ -2,6 +2,25 @@ title: gp_persistent_relfile_node --- + + The `gp_persistent_relfile_node` table keeps track of the status of file system objects in relation to the transaction status of database objects. This information is used to make sure the state of the system catalogs and the file system files persisted to disk are synchronized. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/gp_persistent_tablespace_node.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/gp_persistent_tablespace_node.html.md.erb b/markdown/reference/catalog/gp_persistent_tablespace_node.html.md.erb index 55c853e..1385b67 100644 --- a/markdown/reference/catalog/gp_persistent_tablespace_node.html.md.erb +++ b/markdown/reference/catalog/gp_persistent_tablespace_node.html.md.erb @@ -2,6 +2,25 @@ title: gp_persistent_tablespace_node --- + + The `gp_persistent_tablespace_node` table keeps track of the status of file system objects in relation to the transaction status of tablespace objects. This information is used to make sure the state of the system catalogs and the file system files persisted to disk are synchronized. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/gp_relfile_node.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/gp_relfile_node.html.md.erb b/markdown/reference/catalog/gp_relfile_node.html.md.erb index 971ff16..2958fc0 100644 --- a/markdown/reference/catalog/gp_relfile_node.html.md.erb +++ b/markdown/reference/catalog/gp_relfile_node.html.md.erb @@ -2,6 +2,25 @@ title: gp_relfile_node --- + + The `gp_relfile_node` table contains information about the file system objects for a relation (table, view, index, and so on). http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/gp_segment_configuration.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/gp_segment_configuration.html.md.erb b/markdown/reference/catalog/gp_segment_configuration.html.md.erb index 9fcf0cb..020510c 100644 --- a/markdown/reference/catalog/gp_segment_configuration.html.md.erb +++ b/markdown/reference/catalog/gp_segment_configuration.html.md.erb @@ -2,6 +2,25 @@ title: gp_segment_configuration --- + + The `gp_segment_configuration` table contains information about master, standby and segment configuration. The HAWQ fault tolerance service (FTS) automatically detects the status of individual segments and marks the status of each segment in this table. If a segment is marked as DOWN, the corresponding reason is recorded in the [gp\_configuration\_history](gp_configuration_history.html) table. See [Understanding the Fault Tolerance Service](../../admin/FaultTolerance.html) for a description of the fault tolerance service. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/gp_version_at_initdb.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/gp_version_at_initdb.html.md.erb b/markdown/reference/catalog/gp_version_at_initdb.html.md.erb index 9e922e1..e24ab6b 100644 --- a/markdown/reference/catalog/gp_version_at_initdb.html.md.erb +++ b/markdown/reference/catalog/gp_version_at_initdb.html.md.erb @@ -2,6 +2,25 @@ title: 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 when the system was first initialized. This table is defined in the `pg_global` tablespace, meaning it is globally shared across all databases in the system. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_aggregate.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_aggregate.html.md.erb b/markdown/reference/catalog/pg_aggregate.html.md.erb index 1a02e89..6341c7b 100644 --- a/markdown/reference/catalog/pg_aggregate.html.md.erb +++ b/markdown/reference/catalog/pg_aggregate.html.md.erb @@ -2,6 +2,25 @@ title: pg_aggregate --- + + The `pg_aggregate` table stores information about aggregate functions. An aggregate function is a function that operates on a set of values (typically one column from each row that matches a query condition) and returns a single value computed from all these values. Typical aggregate functions are `sum`, `count`, and `max`. Each entry in `pg_aggregate` is an extension of an entry in `pg_proc`. The `pg_proc` entry carries the aggregate's name, input and output data types, and other information that is similar to ordinary functions. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_am.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_am.html.md.erb b/markdown/reference/catalog/pg_am.html.md.erb index 96ba56b..8a72f35 100644 --- a/markdown/reference/catalog/pg_am.html.md.erb +++ b/markdown/reference/catalog/pg_am.html.md.erb @@ -2,6 +2,25 @@ title: pg_am --- + + The `pg_am` table stores information about index access methods. There is one row for each index access method supported by the system. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_amop.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_amop.html.md.erb b/markdown/reference/catalog/pg_amop.html.md.erb index c07bcd1..431cecf 100644 --- a/markdown/reference/catalog/pg_amop.html.md.erb +++ b/markdown/reference/catalog/pg_amop.html.md.erb @@ -2,6 +2,25 @@ title: pg_amop --- + + The `pg_amop` table stores information about operators associated with index access method operator classes. There is one row for each operator that is a member of an operator class. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_amproc.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_amproc.html.md.erb b/markdown/reference/catalog/pg_amproc.html.md.erb index 7668bac..8f8b27c 100644 --- a/markdown/reference/catalog/pg_amproc.html.md.erb +++ b/markdown/reference/catalog/pg_amproc.html.md.erb @@ -2,6 +2,25 @@ title: pg_amproc --- + + The `pg_amproc` table stores information about support procedures associated with index access method operator classes. There is one row for each support procedure belonging to an operator class. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_appendonly.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_appendonly.html.md.erb b/markdown/reference/catalog/pg_appendonly.html.md.erb index b0a56d6..6b031f9 100644 --- a/markdown/reference/catalog/pg_appendonly.html.md.erb +++ b/markdown/reference/catalog/pg_appendonly.html.md.erb @@ -2,6 +2,25 @@ title: pg_appendonly --- + + The `pg_appendonly` table contains information about the storage options and other characteristics of append-only tables. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_attrdef.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_attrdef.html.md.erb b/markdown/reference/catalog/pg_attrdef.html.md.erb index f4af77d..27e9671 100644 --- a/markdown/reference/catalog/pg_attrdef.html.md.erb +++ b/markdown/reference/catalog/pg_attrdef.html.md.erb @@ -2,6 +2,25 @@ title: pg_attrdef --- + + The `pg_attrdef` table stores column default values. The main information about columns is stored in [pg\_attribute](pg_attribute.html#topic1). Only columns that explicitly specify a default value (when the table is created or the column is added) will have an entry here. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_attribute.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_attribute.html.md.erb b/markdown/reference/catalog/pg_attribute.html.md.erb index 53db267..9b6c1a8 100644 --- a/markdown/reference/catalog/pg_attribute.html.md.erb +++ b/markdown/reference/catalog/pg_attribute.html.md.erb @@ -2,6 +2,25 @@ title: pg_attribute --- + + The `pg_attribute` table stores information about table columns. There will be exactly one `pg_attribute` row for every column in every table in the database. (There will also be attribute entries for indexes, and all objects that have `pg_class` entries.) The term attribute is equivalent to column. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_attribute_encoding.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_attribute_encoding.html.md.erb b/markdown/reference/catalog/pg_attribute_encoding.html.md.erb index 3067a93..48517e4 100644 --- a/markdown/reference/catalog/pg_attribute_encoding.html.md.erb +++ b/markdown/reference/catalog/pg_attribute_encoding.html.md.erb @@ -2,6 +2,25 @@ title: pg_attribute_encoding --- + + The `pg_attribute_encoding` system catalog table contains column storage information. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_auth_members.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_auth_members.html.md.erb b/markdown/reference/catalog/pg_auth_members.html.md.erb index 7e770e0..ee8cf3c 100644 --- a/markdown/reference/catalog/pg_auth_members.html.md.erb +++ b/markdown/reference/catalog/pg_auth_members.html.md.erb @@ -2,6 +2,25 @@ title: pg_auth_members --- + + The `pg_auth_members` system catalog table shows the membership relations between roles. Any non-circular set of relationships is allowed. Because roles are system-wide, `pg_auth_members` is shared across all databases of a HAWQ system. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_authid.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_authid.html.md.erb b/markdown/reference/catalog/pg_authid.html.md.erb index ebae67c..2f1e8a8 100644 --- a/markdown/reference/catalog/pg_authid.html.md.erb +++ b/markdown/reference/catalog/pg_authid.html.md.erb @@ -2,6 +2,25 @@ title: pg_authid --- + + The `pg_authid` table contains information about database authorization identifiers (roles). A role subsumes the concepts of users and groups. A user is a role with the `rolcanlogin` flag set. Any role (with or without `rolcanlogin`) may have other roles as members. See [pg\_auth\_members](pg_auth_members.html#topic1). Since this catalog contains passwords, it must not be publicly readable. [pg\_roles](pg_roles.html#topic1) is a publicly readable view on `pg_authid` that blanks out the password field. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_cast.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_cast.html.md.erb b/markdown/reference/catalog/pg_cast.html.md.erb index 513c7a3..d5adf9d 100644 --- a/markdown/reference/catalog/pg_cast.html.md.erb +++ b/markdown/reference/catalog/pg_cast.html.md.erb @@ -2,6 +2,25 @@ title: pg_cast --- + + The `pg_cast` table stores data type conversion paths, both built-in paths and those defined with `CREATE CAST`. The cast functions listed in `pg_cast` must always take the cast source type as their first argument type, and return the cast destination type as their result type. A cast function can have up to three arguments. The second argument, if present, must be type `integer`; it receives the type modifier associated with the destination type, or `-1` if there is none. The third argument, if present, must be type `boolean`; it receives `true` if the cast is an explicit cast, `false` otherwise. It is legitimate to create a `pg_cast` entry in which the source and target types are the same, if the associated function takes more than one argument. Such entries represent 'length coercion functions' that coerce values of the type to be legal for a particular type modifier value. Note however that at present there is no support for associating non-default type modifiers with user-created data types, and so this facility is only of use for the small number of built-in types that have type modifier syntax built into the grammar. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_class.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_class.html.md.erb b/markdown/reference/catalog/pg_class.html.md.erb index 112375e..23a7dc8 100644 --- a/markdown/reference/catalog/pg_class.html.md.erb +++ b/markdown/reference/catalog/pg_class.html.md.erb @@ -2,6 +2,25 @@ title: pg_class --- + + The system catalog table `pg_class` catalogs tables and most everything else that has columns or is otherwise similar to a table (also known as *relations*). This includes indexes (see also [pg\_index](pg_index.html#topic1)), sequences, views, composite types, and TOAST tables. Not all columns are meaningful for all relation types. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_compression.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_compression.html.md.erb b/markdown/reference/catalog/pg_compression.html.md.erb index 3524af0..f03ba41 100644 --- a/markdown/reference/catalog/pg_compression.html.md.erb +++ b/markdown/reference/catalog/pg_compression.html.md.erb @@ -2,6 +2,25 @@ title: pg_compression --- + + The `pg_compression` system catalog table describes the compression methods available.. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_constraint.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_constraint.html.md.erb b/markdown/reference/catalog/pg_constraint.html.md.erb index 0f591fd..8db725b 100644 --- a/markdown/reference/catalog/pg_constraint.html.md.erb +++ b/markdown/reference/catalog/pg_constraint.html.md.erb @@ -2,6 +2,25 @@ title: pg_constraint --- + + The `pg_constraint` system catalog table stores check and foreign key constraints on tables. Column constraints are not treated specially. Every column constraint is equivalent to some table constraint. Not-null constraints are represented in the [pg\_attribute](pg_attribute.html#topic1) catalog table. Check constraints on domains are stored here, too. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_conversion.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_conversion.html.md.erb b/markdown/reference/catalog/pg_conversion.html.md.erb index 43763bc..6e26377 100644 --- a/markdown/reference/catalog/pg_conversion.html.md.erb +++ b/markdown/reference/catalog/pg_conversion.html.md.erb @@ -2,6 +2,25 @@ title: pg_conversion --- + + The `pg_conversion` system catalog table describes the available encoding conversion procedures as defined by `CREATE CONVERSION`. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_database.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_database.html.md.erb b/markdown/reference/catalog/pg_database.html.md.erb index b02a532..280af6a 100644 --- a/markdown/reference/catalog/pg_database.html.md.erb +++ b/markdown/reference/catalog/pg_database.html.md.erb @@ -2,6 +2,25 @@ title: pg_database --- + + The `pg_database` system catalog table stores information about the available databases. Databases are created with the `CREATE DATABASE` SQL command. Unlike most system catalogs, `pg_database` is shared across all databases in the system. There is only one copy of `pg_database` per system, not one per database. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_depend.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_depend.html.md.erb b/markdown/reference/catalog/pg_depend.html.md.erb index 85a1835..c398c37 100644 --- a/markdown/reference/catalog/pg_depend.html.md.erb +++ b/markdown/reference/catalog/pg_depend.html.md.erb @@ -2,6 +2,25 @@ title: pg_depend --- + + The `pg_depend` system catalog table records the dependency relationships between database objects. This information allows `DROP` commands to find which other objects must be dropped by `DROP CASCADE` or prevent dropping in the `DROP RESTRICT` case. See also [pg\_shdepend](pg_shdepend.html#topic1), which performs a similar function for dependencies involving objects that are shared across a HAWQ system. In all cases, a `pg_depend` entry indicates that the referenced object may not be dropped without also dropping the dependent object. However, there are several subflavors identified by `deptype`: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_description.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_description.html.md.erb b/markdown/reference/catalog/pg_description.html.md.erb index bad9627..d426f0b 100644 --- a/markdown/reference/catalog/pg_description.html.md.erb +++ b/markdown/reference/catalog/pg_description.html.md.erb @@ -2,6 +2,25 @@ title: pg_description --- + + The `pg_description` system catalog table stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the `COMMENT` command and viewed with `psql`'s `\d` meta-commands. Descriptions of many built-in system objects are provided in the initial contents of `pg_description`. See also [pg\_shdescription](pg_shdescription.html#topic1), which performs a similar function for descriptions involving objects that are shared across a HAWQ system. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_exttable.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_exttable.html.md.erb b/markdown/reference/catalog/pg_exttable.html.md.erb index ca5fc88..3d7245d 100644 --- a/markdown/reference/catalog/pg_exttable.html.md.erb +++ b/markdown/reference/catalog/pg_exttable.html.md.erb @@ -2,6 +2,25 @@ title: pg_exttable --- + + The `pg_exttable` system catalog table is used to track external tables and web tables created by the `CREATE EXTERNAL TABLE` command. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_filespace.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_filespace.html.md.erb b/markdown/reference/catalog/pg_filespace.html.md.erb index e0b810e..9f700fd 100644 --- a/markdown/reference/catalog/pg_filespace.html.md.erb +++ b/markdown/reference/catalog/pg_filespace.html.md.erb @@ -2,6 +2,25 @@ title: pg_filespace --- + + The `pg_filespace` table contains information about the filespaces created in a HAWQ system. Every system contains a default filespace, `pg_system`, which is a collection of all the data directory locations created at system initialization time. A tablespace requires a file system location to store its database files. In HAWQ, the master and each segment needs its own distinct storage location. This collection of file system locations for all components in a HAWQ system is referred to as a filespace. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_filespace_entry.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_filespace_entry.html.md.erb b/markdown/reference/catalog/pg_filespace_entry.html.md.erb index 5a45113..d9ea302 100644 --- a/markdown/reference/catalog/pg_filespace_entry.html.md.erb +++ b/markdown/reference/catalog/pg_filespace_entry.html.md.erb @@ -2,6 +2,25 @@ title: 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 storage location. This collection of file system locations for all components in a HAWQ system is referred to as a *filespace*. The `pg_filespace_entry` table contains information about the collection of file system locations across a HAWQ system that comprise a HAWQ filespace. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_index.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_index.html.md.erb b/markdown/reference/catalog/pg_index.html.md.erb index e93bd86..d94fe64 100644 --- a/markdown/reference/catalog/pg_index.html.md.erb +++ b/markdown/reference/catalog/pg_index.html.md.erb @@ -2,6 +2,25 @@ title: pg_index --- + + The `pg_index` system catalog table contains part of the information about indexes. The rest is mostly in [pg\_class](pg_class.html#topic1). http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/a42c05a9/markdown/reference/catalog/pg_inherits.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/catalog/pg_inherits.html.md.erb b/markdown/reference/catalog/pg_inherits.html.md.erb index 9868602..ec4c992 100644 --- a/markdown/reference/catalog/pg_inherits.html.md.erb +++ b/markdown/reference/catalog/pg_inherits.html.md.erb @@ -2,6 +2,25 @@ title: pg_inherits --- + + The `pg_inherits` system catalog table records information about table inheritance hierarchies. There is one entry for each direct child table in the database. (Indirect inheritance can be determined by following chains of entries.) In HAWQ, inheritance relationships are created by both the `INHERITS` clause (standalone inheritance) and the `PARTITION BY` clause (partitioned child table inheritance) of `CREATE TABLE`.