paul-rogers commented on a change in pull request #2030: Update docs for
Metastore to point that all format plugins are supported
URL: https://github.com/apache/drill/pull/2030#discussion_r394538417
##########
File path: _docs/connect-a-data-source/plugins/080-rdbms-storage-plugin.md
##########
@@ -9,14 +9,25 @@ As with any source, Drill supports joins within and between
all systems. Drill a
## Using the RDBMS Storage Plugin
-Drill is designed to work with any relational datastore that provides a JDBC
driver. Drill is actively tested with Postgres, MySQL, Oracle, MSSQL and Apache
Derby. For each system, you will follow three basic steps for setup:
+Drill is designed to work with any relational datastore that provides a JDBC
driver. Drill is actively tested with
+ Postgres, MySQL, Oracle, MSSQL, Apache Derby and H2. For each system, you
will follow three basic steps for setup:
1. [Install Drill]({{ site.baseurl
}}/docs/installing-drill-in-embedded-mode), if you do not already have it
installed.
2. Copy your database's JDBC driver into the jars/3rdparty directory.
(You'll need to do this on every node.)
3. Restart Drill. See [Starting Drill in Distributed
Mode]({{site.baseurl}}/docs/starting-drill-in-distributed-mode/).
- 4. Add a new storage configuration to Drill through the Web UI. Example
configurations for [Oracle](#Example-Oracle-Configuration), [SQL
Server](#Example-SQL-Server-Configuration),
[MySQL](#Example-MySQL-Configuration) and
[Postgres](#Example-Postgres-Configuration) are provided below.
-
-**Example: Working with MySQL**
+ 4. Add a new storage configuration to Drill through the Web UI. Example
configurations for [Oracle](#example-oracle-configuration), [SQL
Server](#example-sql-server-configuration),
[MySQL](#example-mysql-configuration) and
[Postgres](#example-postgres-configuration) are provided below.
+
+## Setting data source parameters in the storage plugin configuration
+
+Starting from Drill 1.18.0, new JDBC storage plugin configuration property
`sourceParameters` was introduced to allow
Review comment:
Drill's JDBC storage plugin configuration allows you to specify database
parameters as JSON key/value pairs. Drill 1.18 introduced a new JDBC storage
plugin property called `sourceParameters` to handle query parameter names which
are not valid JSON identifiers. See
[HikariCP](https://github.com/brettwooldridge/HikariCP#configuration-knobs-baby)
for details. See [Example of Postgres Configuration with `sourceParameters`
configuration
property](#example-of-postgres-configuration-with-sourceparameters-configuration-property)
for an example.
(Note: please specify which parameters we're talking about. I made up the
"database parameter" part; please replace with an accurate description.)
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
