Repository: incubator-hawq-docs Updated Branches: refs/heads/develop 6e9f482ad -> 1f6714a31
pxf/hive reorganize syntax example and chg some params [#128450965] 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/4dfb8cd5 Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/4dfb8cd5 Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/4dfb8cd5 Branch: refs/heads/develop Commit: 4dfb8cd51445dc9c3cc8f097b46cb0863f1fa596 Parents: 6e9f482 Author: Lisa Owen <[email protected]> Authored: Wed Aug 17 08:42:22 2016 -0700 Committer: David Yozie <[email protected]> Committed: Fri Aug 19 10:47:35 2016 -0700 ---------------------------------------------------------------------- pxf/HivePXF.html.md.erb | 11 +++++++---- 1 file changed, 7 insertions(+), 4 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/4dfb8cd5/pxf/HivePXF.html.md.erb ---------------------------------------------------------------------- diff --git a/pxf/HivePXF.html.md.erb b/pxf/HivePXF.html.md.erb index a7160d3..efac11e 100644 --- a/pxf/HivePXF.html.md.erb +++ b/pxf/HivePXF.html.md.erb @@ -72,9 +72,8 @@ PXF has three built-in profiles for Hive tables: - HiveRC - HiveText -The Hive profile works with any Hive storage type. Use HiveRC and HiveText to query RC and Text formats respectively. The HiveRC and HiveText profiles are faster than the generic Hive profile. When using the HiveRC and HiveText profiles, you must specify a DELIMITER option in the LOCATION clause. See [Using Profiles to Read and Write Data](ReadWritePXF.html#readingandwritingdatawithpxf) for more information on profiles. - -The following example creates a readable HAWQ external table representing a Hive table named `/user/eddie/test` using the PXF Hive profile: +The Hive profile works with any Hive storage type. +The following example creates a readable HAWQ external table representing a Hive table named `accessories` in the `inventory` Hive database using the PXF Hive profile: ``` shell $ psql -d postgres @@ -82,10 +81,14 @@ $ psql -d postgres ``` sql postgres=# CREATE EXTERNAL TABLE hivetest(id int, newid int) -LOCATION ('pxf://namenode:51200/hive-db-name.test?PROFILE=Hive') +LOCATION ('pxf://namenode:51200/inventory.accessories?PROFILE=Hive') FORMAT 'custom' (formatter='pxfwritable_import'); ``` + +Use HiveRC and HiveText to query RC and Text formats respectively. The HiveRC and HiveText profiles are faster than the generic Hive profile. When using the HiveRC and HiveText profiles, you must specify a DELIMITER option in the LOCATION clause. See [Using Profiles to Read and Write Data](ReadWritePXF.html#readingandwritingdatawithpxf) for more information on profiles. + + ### <a id="topic_b4v_g3n_25"></a>Hive Complex Types PXF tables support Hive data types that are not primitive types. The supported Hive complex data types are array, struct, map, and union. This Hive `CREATE TABLE` statement, for example, creates a table with each of these complex data types:
