[
https://issues.apache.org/jira/browse/HAWQ-1289?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15838701#comment-15838701
]
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_r97890133
--- Diff: markdown/pxf/HivePXF.html.md.erb ---
@@ -134,14 +134,30 @@ Create a Hive table to expose our sample data set.
hive> LOAD DATA LOCAL INPATH '/tmp/pxf_hive_datafile.txt'
INTO TABLE sales_info;
```
+
+ In examples later in this section, you will access the `sales_info`
Hive table directly via PXF. You will also insert `sales_info` data into tables
of other Hive file format types, and use PXF to access those directly as well.
3. Perform a query on `sales_info` to verify that the data was loaded
successfully:
``` sql
hive> SELECT * FROM sales_info;
```
-In examples later in this section, you will access the `sales_info` Hive
table directly via PXF. You will also insert `sales_info` data into tables of
other Hive file format types, and use PXF to access those directly as well.
+### <a id="get_hdfs_file_location"></a>Determine the HDFS location of a
Hive Table
+
+Should you need to identify the HDFS file location of a Hive managed
table, you will reference it using its HDFS file path. You can determine a Hive
table's location in HDFS using the `DESCRIBE` command, for example:
--- End diff --
Small edit - remove "you will"
> 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.4#6332)
