You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hawq.apache.org by yo...@apache.org on 2016/09/29 17:22:47 UTC
[33/50] [abbrv] incubator-hawq-docs git commit: more updates -
cleaning up update, delete, vacuum references
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/master
Commit: 94eac9f94147850c092fa04fcf4ca828d7266b28
Parents: ffda5ae
Author: Lisa Owen <lo...@pivotal.io>
Authored: Thu Sep 22 15:36:43 2016 -0700
Committer: Lisa Owen <lo...@pivotal.io>
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.