Re: RDBMS Storage Plugin Configurations

Thank you all for the replies! Yes, looks like DRILL-7467 is what I am looking for. The use case is do an occational join across two storage plugins with one of them being the jdbc storage plugin. Now we would like to release the JDBC connection used afterward. -- Jiang On Thu, Jan 16, 2020

Re: RDBMS Storage Plugin Configurations

In the scope of DRILL-7467 one of the enhancements will be to add opportunity to control basic data source setup thought the storage plugin config. You will be able to indicate basic data source parameters and their values: https://commons.apache.org/proper/commons-dbcp/configuration.html

Re: RDBMS Storage Plugin Configurations

Hi Jiang, Welcome to Drill! Just as an FYI, there are several improvements underway for the JDBC plugin: https://issues.apache.org/jira/browse/DRILL-7467 https://issues.apache.org/jira/projects/DRILL/issues/DRILL-7490

Re: RDBMS Storage Plugin Configurations

Hi Jiang, Welcome to the Drill mailing list. I think you may be making some assumptions about how Drill works, perhaps based on how other DB-driven applications work. Drill is not primarily a front-end for an RDBS. Instead, it is primarily designed to scan distributed data as fast as possible