hawq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yo...@apache.org
Subject [1/4] incubator-hawq-docs git commit: pxf json plugin - misc updates
Date Fri, 14 Oct 2016 23:25:03 GMT
Repository: incubator-hawq-docs
Updated Branches:
  refs/heads/develop a819abd79 -> f4bd3ef5a


pxf json plugin - misc updates

- use <> for options
- include link to CREATE EXTERNAL TABLE ref page


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/d1b7d017
Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/d1b7d017
Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/d1b7d017

Branch: refs/heads/develop
Commit: d1b7d017e50a2d32ad302e2a418138c9e3b4ce3b
Parents: a819abd
Author: Lisa Owen <lowen@pivotal.io>
Authored: Wed Oct 12 08:41:15 2016 -0700
Committer: Lisa Owen <lowen@pivotal.io>
Committed: Wed Oct 12 08:41:15 2016 -0700

----------------------------------------------------------------------
 pxf/JsonPXF.html.md.erb | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/d1b7d017/pxf/JsonPXF.html.md.erb
----------------------------------------------------------------------
diff --git a/pxf/JsonPXF.html.md.erb b/pxf/JsonPXF.html.md.erb
index 5283349..97195ad 100644
--- a/pxf/JsonPXF.html.md.erb
+++ b/pxf/JsonPXF.html.md.erb
@@ -141,25 +141,25 @@ Once loaded to HDFS, JSON data may be queried and analyzed via HAWQ.
 Use the following syntax to create an external table representing JSON data: 
 
 ``` sql
-CREATE EXTERNAL TABLE table_name 
-    ( column_name data_type [, ...] | LIKE other_table )
-LOCATION ( 'pxf://host[:port]/path-to-data?PROFILE=Json[&IDENTIFIER=value]' )
+CREATE EXTERNAL TABLE <table_name> 
+    ( <column_name> <data_type> [, ...] | LIKE <other_table> )
+LOCATION ( 'pxf://<host>[:<port>]/<path-to-data>?PROFILE=Json[&IDENTIFIER=<value>]'
)
       FORMAT 'CUSTOM' ( FORMATTER='pxfwritable_import' );
 ```
 JSON-plug-in-specific keywords and values used in the `CREATE EXTERNAL TABLE` call are described
below.
 
 | Keyword  | Value |
 |-------|-------------------------------------|
-| host    | Specify the HDFS NameNode in the `host` field. |
+| \<host\>    | Specify the HDFS NameNode in the \<host\> field. |
 | PROFILE    | The `PROFILE` keyword must specify the value `Json`. |
-| IDENTIFIER  | Include the `IDENTIFIER` keyword and value in the `LOCATION` string only
when accessing a JSON file with multi-line records. `value` should identify the member name
used to determine the encapsulating JSON object to return.  (If the JSON file is the multi-line
record Example 2 above, `&IDENTIFIER=created_at` would be specified.) |  
+| IDENTIFIER  | Include the `IDENTIFIER` keyword and \<value\> in the `LOCATION` string
only when accessing a JSON file with multi-line records. \<value\> should identify the
member name used to determine the encapsulating JSON object to return.  (If the JSON file
is the multi-line record Example 2 above, `&IDENTIFIER=created_at` would be specified.)
|  
 | FORMAT    | The `FORMAT` clause must specify `CUSTOM`. |
 | FORMATTER    | The JSON `CUSTOM` format supports only the built-in `pxfwritable_import`
`FORMATTER`. |
 
 
 ### Example 1 <a id="jsonexample1"></a>
 
-The following `CREATE EXTERNAL TABLE` SQL call creates a queryable external table based on
the data in the single-line-per-record JSON example.
+The following [CREATE EXTERNAL TABLE](../reference/sql/CREATE-EXTERNAL-TABLE.html) SQL call
creates a queryable external table based on the data in the single-line-per-record JSON example.
 
 ``` sql 
 CREATE EXTERNAL TABLE sample_json_singleline_tbl(


Mime
View raw message