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 <[email protected]> Authored: Tue Nov 1 14:11:36 2016 -0700 Committer: Lisa Owen <[email protected]> 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; ```
