[
https://issues.apache.org/jira/browse/HAWQ-1289?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15876983#comment-15876983
]
ASF GitHub Bot commented on HAWQ-1289:
--------------------------------------
Github user dyozie commented on a diff in the pull request:
https://github.com/apache/incubator-hawq-docs/pull/90#discussion_r102345563
--- Diff: markdown/pxf/HivePXF.html.md.erb ---
@@ -766,20 +766,42 @@ In this example, you will use the `Hive` profile to
query a partitioned Hive ext
hive> SELECT * from hive_multiformpart WHERE year='2016';
```
-6. Show the partitions defined for the `hive_multiformpart` table:
+6. Show the partitions defined for the `hive_multiformpart` table and exit
`hive`:
``` sql
hive> SHOW PARTITIONS hive_multiformpart;
year=2013
year=2016
+ hive> quit;
```
-7. Use the PXF `Hive` profile to create a readable HAWQ external table
derived from the Hive `hive_multiformpart` external table created in the
previous steps:
+7. Start the `psql` subsystem:
``` shell
$ psql -d postgres
```
+
+7. Use PXF HCatalog integration to query the Hive `hive_multiformpart`
external table you created in the previous steps:
+
+ ``` sql
+ postgres=# SELECT * FROM hcatalog.default.hive_multiformpart;
+ ```
+ ``` shell
+ location | month | number_of_orders | total_sales | year
+ ---------------+-------+------------------+-------------+------
+ ...
+ Prague | Dec | 333 | 9894.77 | 2013
+ Bangalore | Jul | 271 | 8320.55 | 2013
+ Beijing | Dec | 100 | 4248.41 | 2013
+ Prague | Jan | 101 | 4875.33 | 2016
+ Rome | Mar | 87 | 1557.39 | 2016
+ Bangalore | May | 317 | 8936.99 | 2016
+ ...
+ ```
+
+7. Now use the PXF `Hive` profile to create a readable HAWQ external table
derived from the Hive `hive_multiformpart` external table you created in the
previous steps:
--- End diff --
Remove "Now" (just start with "Use").
> Hive profile docs - add partitioning example with multiple file format types
> ----------------------------------------------------------------------------
>
> Key: HAWQ-1289
> URL: https://issues.apache.org/jira/browse/HAWQ-1289
> Project: Apache HAWQ
> Issue Type: Improvement
> Components: Documentation
> Reporter: Lisa Owen
> Assignee: David Yozie
> Priority: Minor
>
> include an example where:
> - a Hive table has multiple partitions of different file formats
> - create a pxf external table using Hive profile to read the different
> partitions of the hive table
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
