[
https://issues.apache.org/jira/browse/HAWQ-1071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15612453#comment-15612453
]
ASF GitHub Bot commented on HAWQ-1071:
--------------------------------------
Github user kavinderd commented on a diff in the pull request:
https://github.com/apache/incubator-hawq-docs/pull/39#discussion_r85378363
--- Diff: pxf/HivePXF.html.md.erb ---
@@ -339,21 +601,21 @@ postgres=# CREATE EXTERNAL TABLE pxf_sales_part(
delivery_state TEXT,
delivery_city TEXT
)
-LOCATION ('pxf://namenode_host:51200/sales_part?Profile=Hive')
+LOCATION ('pxf://namenode:51200/sales_part?Profile=Hive')
FORMAT 'custom' (FORMATTER='pxfwritable_import');
postgres=# SELECT * FROM pxf_sales_part;
```
-### <a id="example3"></a>Example
+### <a id="example3"></a>Query Without Pushdown
In the following example, the HAWQ query filters the `delivery_city`
partition `Sacramento`. The filter on `item_name` is not pushed down, since it
is not a partition column. It is performed on the HAWQ side after all the data
on `Sacramento` is transferred for processing.
``` sql
-postgres=# SELECT * FROM pxf_sales_part WHERE delivery_city = 'Sacramento'
AND item_name = 'shirt';
+postgres=# SELECT * FROM pxf_sales_part WHERE delivery_city = 'Sacramento'
AND item_name = 'cube';
```
-### <a id="example4"></a>Example
+### <a id="example4"></a>Query With Pushdown
--- End diff --
Somewhere it should be stated that the HAWQ GUC
`pxf_enable_filter_pushdown` needs to be turned on. If this is off no filter
pushdown will occur regardless of the nature of the query.
> add PXF HiveText and HiveRC profile examples to the documentation
> -----------------------------------------------------------------
>
> Key: HAWQ-1071
> URL: https://issues.apache.org/jira/browse/HAWQ-1071
> Project: Apache HAWQ
> Issue Type: Improvement
> Components: Documentation
> Reporter: Lisa Owen
> Assignee: David Yozie
> Priority: Minor
> Fix For: 2.0.1.0-incubating
>
>
> the current PXF Hive documentation includes an example for only the Hive
> profile. add examples for HiveText and HiveRC profiles.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
