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 <[email protected]> Authored: Wed Jul 12 09:18:48 2017 -0600 Committer: Lisa Owen <[email protected]> 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
