This is an automated email from the ASF dual-hosted git repository.
dzamo pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/master by this push:
new 50d36184b Add info about setting JDBC driver connection props in
storage-jdbc.
50d36184b is described below
commit 50d36184b9d24d40aee8191a4326e433284e19b6
Author: James Turton <[email protected]>
AuthorDate: Thu Oct 27 16:02:03 2022 +0200
Add info about setting JDBC driver connection props in storage-jdbc.
---
_docs/en/connect-a-data-source/plugins/080-rdbms-storage-plugin.md | 7 ++++++-
1 file changed, 6 insertions(+), 1 deletion(-)
diff --git a/_docs/en/connect-a-data-source/plugins/080-rdbms-storage-plugin.md
b/_docs/en/connect-a-data-source/plugins/080-rdbms-storage-plugin.md
index 43000b26d..8d879fcba 100644
--- a/_docs/en/connect-a-data-source/plugins/080-rdbms-storage-plugin.md
+++ b/_docs/en/connect-a-data-source/plugins/080-rdbms-storage-plugin.md
@@ -21,7 +21,12 @@ Drill is designed to work with any relational datastore that
provides a JDBC dri
**Introduced in release:** 1.18
-A JDBC storage plugin configuration property `sourceParameters` was introduced
to allow setting data source parameters described in
[HikariCP](https://github.com/brettwooldridge/HikariCP#configuration-knobs-baby).
Parameters names with incorrect naming and parameter values which are of
incorrect data type or illegal will cause the storage plugin to fail to start.
See the [Example of PostgreSQL Configuration with `sourceParameters`
configuration property](#example-of-postgres-configurat [...]
+A JDBC storage plugin configuration property `sourceParameters` was introduced
to allow setting data source parameters [supported by
HikariCP](https://github.com/brettwooldridge/HikariCP#configuration-knobs-baby).
Parameters names with incorrect naming and parameter values which are of
incorrect data type or illegal will cause the storage plugin to fail to start.
See the [Example of PostgreSQL Configuration with `sourceParameters`
configuration property](#example-of-postgres-configurat [...]
+
+From release 1.20 onwards, the default `sourceParameters` set on the JDBC
storage plugin are set to make the initiation of outbound connections lazy
rather than eager, where eager means at the time of storage config enablement.
Additionally, the JDBC connection pool is now allowed by default to shrink back
down to empty if all of its connections are idle. These new settings are
visible in the `rdbms` storage config template and may be overridden to
reinstate Drill's earlier behaviour.
+
+It is also possible to set JDBC driver connection properties (which are
distinct from HikariCP's own properties) using `sourceParameters` by prepending
the property name with `dataSource.`. For example, to set the connection
property `S3OutputLocation`, which is supported by the AWS Athena JDBC driver,
add a property named `dataSource.S3OutputLocation` to `sourceParameters`. Refer
to the [HikariCP
docs](https://github.com/brettwooldridge/HikariCP#rocket-initialization) for
more detail.
+
### Example: Working with MySQL
