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/11/01 23:23:06 UTC
[5/6] incubator-hawq-docs git commit: more - uppercase for SQL
keywords
more - uppercase for SQL keywords
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/af50fc80
Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/af50fc80
Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/af50fc80
Branch: refs/heads/develop
Commit: af50fc8088f12f4dd08faf180532355902790b89
Parents: e1fef71
Author: Lisa Owen <lo...@pivotal.io>
Authored: Tue Nov 1 14:11:36 2016 -0700
Committer: Lisa Owen <lo...@pivotal.io>
Committed: Tue Nov 1 14:11:36 2016 -0700
----------------------------------------------------------------------
datamgmt/HAWQInputFormatforMapReduce.html.md.erb | 2 +-
.../g-loading-data-using-an-external-table.html.md.erb | 4 ++--
datamgmt/load/g-register_files.html.md.erb | 12 ++++++------
3 files changed, 9 insertions(+), 9 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/af50fc80/datamgmt/HAWQInputFormatforMapReduce.html.md.erb
----------------------------------------------------------------------
diff --git a/datamgmt/HAWQInputFormatforMapReduce.html.md.erb b/datamgmt/HAWQInputFormatforMapReduce.html.md.erb
index 32dd4fa..a6fcca2 100644
--- a/datamgmt/HAWQInputFormatforMapReduce.html.md.erb
+++ b/datamgmt/HAWQInputFormatforMapReduce.html.md.erb
@@ -194,7 +194,7 @@ implements Tool {
Or a Parquet table:
``` sql
- CREATE TABLE employees ( id INTEGER NOT NULL, name TEXT NOT NULL) with (appendonly=true, orientation=parquet);
+ CREATE TABLE employees ( id INTEGER NOT NULL, name TEXT NOT NULL) WITH (APPENDONLY=true, ORIENTATION=parquet);
```
3. Insert one tuple:
http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/af50fc80/datamgmt/load/g-loading-data-using-an-external-table.html.md.erb
----------------------------------------------------------------------
diff --git a/datamgmt/load/g-loading-data-using-an-external-table.html.md.erb b/datamgmt/load/g-loading-data-using-an-external-table.html.md.erb
index 9af2b13..32a741a 100644
--- a/datamgmt/load/g-loading-data-using-an-external-table.html.md.erb
+++ b/datamgmt/load/g-loading-data-using-an-external-table.html.md.erb
@@ -6,13 +6,13 @@ Use SQL commands such as `INSERT` and `SELECT` to query a readable external tabl
``` sql
=# INSERT INTO expenses_travel
-SELECT * from ext_expenses where category='travel';
+SELECT * FROM ext_expenses WHERE category='travel';
```
To load all data into a new database table:
``` sql
-=# CREATE TABLE expenses AS SELECT * from ext_expenses;
+=# CREATE TABLE expenses AS SELECT * FROM ext_expenses;
```
http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/af50fc80/datamgmt/load/g-register_files.html.md.erb
----------------------------------------------------------------------
diff --git a/datamgmt/load/g-register_files.html.md.erb b/datamgmt/load/g-register_files.html.md.erb
index beea0f6..c0f4e2b 100644
--- a/datamgmt/load/g-register_files.html.md.erb
+++ b/datamgmt/load/g-register_files.html.md.erb
@@ -54,17 +54,17 @@ You can locate the table by one of two methods, either by relation ID or by tab
To find the relation ID, run the following command on the catalog table pg\_class:
```
-select oid from pg_class where relname=$relname
+SELECT oid FROM pg_class WHERE relname=$relname
```
To find the table name, run the command:
```
-select segrelid from pg_appendonly where relid = $relid
+SELECT segrelid FROM pg_appendonly WHERE relid = $relid
```
then run:
```
-select relname from pg_class where oid = segrelid
+SELECT relname FROM pg_class WHERE oid = segrelid
```
## <a id="topic1__section3"></a>Registering Data Using Information from a YAML Configuration File
@@ -92,8 +92,8 @@ This example shows how to use `hawq register` to register HDFS data using a YAML
First, create a table in SQL and insert some data into it.
```
-=> create table paq1(a int, b varchar(10))with(appendonly=true, orientation=parquet);
-=> insert into paq1 values(generate_series(1,1000), 'abcde');
+=> CREATE TABLE paq1(a int, b varchar(10))with(appendonly=true, orientation=parquet);
+=> INSERT INTO paq1 VALUES(generate_series(1,1000), 'abcde');
```
Extract the table metadata by using the `hawq extract` utility.
@@ -110,7 +110,7 @@ hawq register --config paq1.yml paq2
Select the new table and check to verify that the content has been registered.
```
-=> select count(*) from paq2;
+=> SELECT count(*) FROM paq2;
```