[ https://issues.apache.org/jira/browse/HAWQ-1071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15612864#comment-15612864 ]
ASF GitHub Bot commented on HAWQ-1071: -------------------------------------- Github user lisakowen commented on a diff in the pull request: https://github.com/apache/incubator-hawq-docs/pull/39#discussion_r85407620 --- 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 -- yes, this is good info to share with the user! i checked out the code, and it looks like this GUC is on by default. i will add some text to that effect in the appropriate section. > 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)