Repository: incubator-hawq-docs Updated Branches: refs/heads/develop 59e6e0548 -> f08f7caec
HAWQ-1202 - PXF server config params (This closes #70) 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/f08f7cae Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/f08f7cae Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/f08f7cae Branch: refs/heads/develop Commit: f08f7caec6283e664277d295bb829535f8624cdb Parents: 59e6e05 Author: Lisa Owen <[email protected]> Authored: Tue Jan 3 16:04:32 2017 -0800 Committer: David Yozie <[email protected]> Committed: Tue Jan 3 16:04:32 2017 -0800 ---------------------------------------------------------------------- reference/guc/guc_category-list.html.md.erb | 12 +++++++ reference/guc/parameter_definitions.html.md.erb | 35 ++++++++++++++++++-- 2 files changed, 45 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/f08f7cae/reference/guc/guc_category-list.html.md.erb ---------------------------------------------------------------------- diff --git a/reference/guc/guc_category-list.html.md.erb b/reference/guc/guc_category-list.html.md.erb index 56f6e73..c42bba9 100644 --- a/reference/guc/guc_category-list.html.md.erb +++ b/reference/guc/guc_category-list.html.md.erb @@ -198,6 +198,18 @@ The parameters in this topic control the configuration of the HAWQ array and its - [hawq\_segment\_directory](parameter_definitions.html#hawq_segment_directory) - [hawq\_segment\_temp\_directory](parameter_definitions.html#hawq_segment_temp_directory) +## <a id="topic_pxfparam"></a>HAWQ Extension Framework (PXF) Parameters + +The parameters in this topic control configuration, query analysis, and statistics collection in the HAWQ Extension Framework (PXF). + +- [pxf\_enable\_filter\_pushdown](parameter_definitions.html#pxf_enable_filter_pushdown) +- [pxf\_enable\_stat\_collection](parameter_definitions.html#pxf_enable_stat_collection) +- [pxf\_remote\_service\_login](parameter_definitions.html#pxf_remote_service_login) +- [pxf\_remote\_service\_secret](parameter_definitions.html#pxf_remote_service_secret) +- [pxf\_service\_address](parameter_definitions.html#pxf_service_address) +- [pxf\_service\_port] (parameter_definitions.html#pxf_service_port) +- [pxf\_stat\_max\_fragments] (parameter_definitions.html#pxf_stat_max_fragments) + ## <a id="topic56"></a>HAWQ PL/Java Extension Parameters The parameters in this topic control the configuration of HAWQ PL/Java extensions. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/f08f7cae/reference/guc/parameter_definitions.html.md.erb ---------------------------------------------------------------------- diff --git a/reference/guc/parameter_definitions.html.md.erb b/reference/guc/parameter_definitions.html.md.erb index 4e627cb..b568da8 100644 --- a/reference/guc/parameter_definitions.html.md.erb +++ b/reference/guc/parameter_definitions.html.md.erb @@ -414,8 +414,14 @@ Descriptions of the HAWQ server configuration parameters listed alphabetically. - **[port](../../reference/guc/parameter_definitions.html#port)** +- **[pxf\_enable\_filter\_pushdown](../../reference/guc/parameter_definitions.html#pxf_enable_filter_pushdown)** + - **[pxf\_enable\_stat\_collection](../../reference/guc/parameter_definitions.html#pxf_enable_stat_collection)** +- **[pxf\_remote\_service\_login](../../reference/guc/parameter_definitions.html#pxf_remote_service_login)** + +- **[pxf\_remote\_service\_secret](../../reference/guc/parameter_definitions.html#pxf_remote_service_secret)** + - **[pxf\_service\_address](../../reference/guc/parameter_definitions.html#pxf_service_address)** - **[pxf\_service\_port](../../reference/guc/parameter_definitions.html#pxf_service_port)** @@ -2732,6 +2738,14 @@ The database listener port for a HAWQ instance. The master and each segment has |-----------------------|---------|------------------------| | any valid port number | 5432 | local, system, restart | +## <a name="pxf_enable_filter_pushdown"></a>pxf\_enable\_filter\_pushdown + +Determines whether partition filtering is enabled. If on, filtering is performed by PXF at the partition level. When off, filtering is performed on the HAWQ side, possibly negatively impacting performance. + +| Value Range | Default | Set Classifications | +|-------------|---------|-------------------------| +| Boolean | on | master, session, reload | + ## <a name="pxf_enable_stat_collection"></a>pxf\_enable\_stat\_collection Determines whether `ANALYZE` collects statistics for readable PXF tables. If true, an analyze operation on a readable PXF table estimates the number of tuples in the table, generates a sample table and runs statistics queries on the sample table to calculate statistics, as it does for native tables. When false, `ANALYZE` displays a message to warn that it is skipping the table because `pxf_enable_stat_collection` is off. @@ -2740,9 +2754,26 @@ Determines whether `ANALYZE` collects statistics for readable PXF tables. If tru |-------------|---------|-------------------------| | Boolean | true | master, session, reload | +## <a name="pxf_remote_service_login"></a>pxf\_remote\_service\_login + +Temporary configuration parameter identifying the login credential to forward to remote services requiring authentication. + +| Value Range | Default | Set Classifications | +|---------------------------------------------------------|-----------------|-------------------------| +| string | | master, session, reload | + +## <a name="pxf_remote_service_secret"></a>pxf\_remote\_service\_secret + +Temporary configuration parameter identifying the password credential to forward to remote services requiring authentication. + +| Value Range | Default | Set Classifications | +|---------------------------------------------------------|-----------------|-------------------------| +| string | | master, session, reload | + + ## <a name="pxf_service_address"></a>pxf\_service\_address -Specifies the location and port of the PXF service used by HCatalog. To learn more about HCatalog querying by PXF, see [Using PXF and HCatalog to Query Hive](../../pxf/HivePXF.html#hcatalog). +Specifies the location and port of the PXF service used by HCatalog. To learn more about HCatalog integration with PXF, see [Using PXF and HCatalog to Query Hive](../../pxf/HivePXF.html#hcatalog). | Value Range | Default | Set Classifications | |---------------------------------------------------------|-----------------|-------------------------| @@ -2758,7 +2789,7 @@ Specifies the listen port for the PXF service when HDFS NameNode High Availabili ## <a name="pxf_stat_max_fragments"></a>pxf\_stat\_max\_fragments -The maximum number of fragments to sample during `ANALYZE` on a PXF table. A lower value provides better performance for the `ANALYZE` command, but the sampling is less uniform. A higher value provides more uniform sampling, with slower `ANALYZE` performance. +The maximum number of fragments to sample during `ANALYZE` on a PXF table. A lower value provides faster performance for the `ANALYZE` command, but the sampling is less uniform. A higher value provides more uniform sampling, with slower `ANALYZE` performance. | Value Range | Default | Set Classifications | |---------------------|---------|-------------------------|
