You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hawq.apache.org by li...@apache.org on 2017/07/12 15:19:27 UTC
incubator-hawq-docs git commit: pxf jdbc profile - enhance INTERVAL
discussion
Repository: incubator-hawq-docs
Updated Branches:
refs/heads/master abea80853 -> f6d40aaca
pxf jdbc profile - enhance INTERVAL discussion
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/f6d40aac
Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/f6d40aac
Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/f6d40aac
Branch: refs/heads/master
Commit: f6d40aaca08e78d208a7ac8192ebf88a3564bec4
Parents: abea808
Author: Lisa Owen <lo...@pivotal.io>
Authored: Wed Jul 12 09:18:48 2017 -0600
Committer: Lisa Owen <lo...@pivotal.io>
Committed: Wed Jul 12 09:18:48 2017 -0600
----------------------------------------------------------------------
markdown/pxf/JdbcPXF.html.md.erb | 2 ++
1 file changed, 2 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/f6d40aac/markdown/pxf/JdbcPXF.html.md.erb
----------------------------------------------------------------------
diff --git a/markdown/pxf/JdbcPXF.html.md.erb b/markdown/pxf/JdbcPXF.html.md.erb
index 337de66..9135e2b 100644
--- a/markdown/pxf/JdbcPXF.html.md.erb
+++ b/markdown/pxf/JdbcPXF.html.md.erb
@@ -87,6 +87,8 @@ Example JDBC \<custom-option\> connection string:
&JDBC_DRIVER=com.mysql.jdbc.Driver&DB_URL=jdbc:mysql://<dbhost>:<dbport>/testdb&USER=user1&PASS=changeme
```
+When specifying the `PARTITION_BY` option, tune the `INTERVAL` value and unit based upon the optimal number of JDBC connections to the target database and the optimal distribution of fragments across HAWQ segments. The `INTERVAL` low boundary is driven by the number of HAWQ segments (`default_hash_table_bucket_number`), while the high boundary is driven by the acceptable number of JDBC connections to the target database. `INTERVAL` settings influence the number of fragments, and should ideally not be set too high nor too low. Testing with multiple values may help you select the optimal settings.
+
Example JDBC \<custom-option\> substrings identifying partitioning parameters:
``` pre