more updates - cleaning up update, delete, vacuum references
Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/commit/94eac9f9 Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/94eac9f9 Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/94eac9f9 Branch: refs/heads/develop Commit: 94eac9f94147850c092fa04fcf4ca828d7266b28 Parents: ffda5ae Author: Lisa Owen <[email protected]> Authored: Thu Sep 22 15:36:43 2016 -0700 Committer: Lisa Owen <[email protected]> Committed: Thu Sep 22 15:36:43 2016 -0700 ---------------------------------------------------------------------- datamgmt/BasicDataOperations.html.md.erb | 2 +- reference/sql/CREATE-EXTERNAL-TABLE.html.md.erb | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/94eac9f9/datamgmt/BasicDataOperations.html.md.erb ---------------------------------------------------------------------- diff --git a/datamgmt/BasicDataOperations.html.md.erb b/datamgmt/BasicDataOperations.html.md.erb index e50060c..6c3323c 100644 --- a/datamgmt/BasicDataOperations.html.md.erb +++ b/datamgmt/BasicDataOperations.html.md.erb @@ -49,7 +49,7 @@ Periodically running the `VACUUM` command on system catalog tables removes these For example: ``` sql -VACUUM mytable; +VACUUM pg_class; ``` ### <a id="topic10"></a>Configuring the Free Space Map http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/94eac9f9/reference/sql/CREATE-EXTERNAL-TABLE.html.md.erb ---------------------------------------------------------------------- diff --git a/reference/sql/CREATE-EXTERNAL-TABLE.html.md.erb b/reference/sql/CREATE-EXTERNAL-TABLE.html.md.erb index 4eec64b..2f19eab 100644 --- a/reference/sql/CREATE-EXTERNAL-TABLE.html.md.erb +++ b/reference/sql/CREATE-EXTERNAL-TABLE.html.md.erb @@ -109,7 +109,7 @@ where \<pxf parameters\> is: ## <a id="topic1__section3"></a>Description -`CREATE EXTERNAL TABLE` or `CREATE EXTERNAL WEB TABLE` creates a new readable external table definition in HAWQ. Readable external tables are typically used for fast, parallel data loading. Once an external table is defined, you can query its data directly (and in parallel) using SQL commands. For example, you can select, join, or sort external table data. You can also create views for external tables. DML operations (`INSERT` or `TRUNCATE`) are not allowed on readable external tables. +`CREATE EXTERNAL TABLE` or `CREATE EXTERNAL WEB TABLE` creates a new readable external table definition in HAWQ. Readable external tables are typically used for fast, parallel data loading. Once an external table is defined, you can query its data directly (and in parallel) using SQL commands. For example, you can select, join, or sort external table data. You can also create views for external tables. DML operations (`UPDATE`, `INSERT`, `DELETE`, or `TRUNCATE`) are not permitted on readable external tables. `CREATE WRITABLE EXTERNAL TABLE` or `CREATE WRITABLE EXTERNAL WEB TABLE` creates a new writable external table definition in HAWQ. Writable external tables are typically used for unloading data from the database into a set of files or named pipes.
