note/notice
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/2a38a032 Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/2a38a032 Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/2a38a032 Branch: refs/heads/tutorial-proto Commit: 2a38a0322abda804cfd4fc8aa39f142f0d83ea11 Parents: 284c3ec Author: Lisa Owen <[email protected]> Authored: Wed Oct 26 10:20:28 2016 -0700 Committer: Lisa Owen <[email protected]> Committed: Wed Oct 26 10:20:28 2016 -0700 ---------------------------------------------------------------------- pxf/HivePXF.html.md.erb | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/2a38a032/pxf/HivePXF.html.md.erb ---------------------------------------------------------------------- diff --git a/pxf/HivePXF.html.md.erb b/pxf/HivePXF.html.md.erb index 82fcc25..da851db 100644 --- a/pxf/HivePXF.html.md.erb +++ b/pxf/HivePXF.html.md.erb @@ -130,7 +130,7 @@ Create a Hive table to expose our sample data set. STORED AS textfile; ``` - Notice: + Notice that: - The `STORED AS textfile` subclause instructs Hive to create the table in Textfile (the default) format. Hive Textfile format supports comma-, tab-, and space-separated values, as well as data specified in JSON notation. - The `DELIMITED FIELDS TERMINATED BY` subclause identifies the field delimiter within a data record (line). The `sales_info` table field delimiter is a comma (`,`). @@ -229,7 +229,7 @@ Use the PXF `HiveText` profile to create a queryable HAWQ external table from th (You can safely ignore the "nonstandard use of escape in a string literal" warning and related messages.) - Notice: + Notice that: - The `LOCATION` subclause `DELIMITER` value is specified in hexadecimal format. `\x` is a prefix that instructs PXF to interpret the following characters as hexadecimal. `2c` is the hex value for the comma character. - The `FORMAT` subclause `delimiter` value is specified as the single ascii comma character ','. `E` escapes the character. @@ -380,7 +380,7 @@ When specifying an array field in a Hive table, you must identify the terminator STORED AS TEXTFILE; ``` - Notice: + Notice that: - `FIELDS TERMINATED BY` identifies a comma as the field terminator. - The `COLLECTION ITEMS TERMINATED BY` subclause specifies the percent sign as the collection items (array item, map key/value pair) terminator. @@ -514,7 +514,7 @@ To obtain a description of a Hive table with HCatalog integration, you can use t - Use `\d hcatalog.hive-db-name.*` to describe the whole database schema, i.e. all tables in `hive-db-name`. - Use `\d hcatalog.*.*` to describe the whole schema, i.e. all databases and tables. -**Note:** When using `\d` or `\d+` commands in the `psql` HAWQ client, `hcatalog` will not be listed as a database. If you use other `psql` compatible clients, `hcatalog` will be listed as a database with a size value of `-1` since `hcatalog` is not a real database in HAWQ. +When using `\d` or `\d+` commands in the `psql` HAWQ client, `hcatalog` will not be listed as a database. If you use other `psql` compatible clients, `hcatalog` will be listed as a database with a size value of `-1` since `hcatalog` is not a real database in HAWQ. Alternatively, you can use the `pxf_get_item_fields` user-defined function (UDF) to obtain Hive table descriptions from other client interfaces or third-party applications. The UDF takes a PXF profile and a table pattern string as its input parameters. **Note:** The only supported input profile at this time is `'Hive'`. @@ -559,7 +559,7 @@ The PXF Hive plug-in supports the Hive partitioning feature and directory struct To take advantage of PXF partition filtering push-down, the Hive and PXF partition field names should be the same. Otherwise, PXF ignores partition filtering and the filtering is performed on the HAWQ side, impacting performance. -**Note:** The Hive plug-in only filters on partition columns, not on other table attributes. +**Note:** The Hive plug-in filters only on partition columns, not on other table attributes. ### <a id="example2"></a>Create Partitioned Hive Table
