Re: JDBC driver for MySQL - storage plugin config and push down ?

2015-10-07 Thread Andrew Selden
There are 2 issues with the latest build that make the JDBC storage plugin unusable. I will be publishing a fix for both later today. The first issue is that the assembly phase wasn’t including the drill-module.conf for the JDBC plugin, so you could never actually register a JDBC source. The s

Re: JDBC driver for MySQL - storage plugin config and push down ?

2015-10-07 Thread Neeraja Rentachintala
Andrew thanks for the update. Also is it possible for you to share a brief set of instructions on how to configure/use this plugin with a database , lets say mysql (or postgres or ..). There have been few question on the threads around this and could benefit from a quick summary. -Neeraja On Wed

Re: JDBC driver for MySQL - storage plugin config and push down ?

2015-10-07 Thread andrew
Hi Ulf, There are 2 issues with the latest build that make the JDBC storage plugin unusable. I will be publishing a fix for both later today. The first issue is that the assembly phase wasn’t including the drill-module.conf for the JDBC plugin, so you could never actually register a JDBC sourc

Re: JDBC driver for MySQL - storage plugin config and push down ?

2015-10-06 Thread Ulf Andreasson @ MapR
Jacques et al, CP includes /usr/share/java/mysql-connector-java.jar but no diff. Are now running on a single node and have been monitoring /opt/drill/log but the sqlline.log doesn't let away anything when creating a new plugin. The web-ui only says "error (invalid JSON mapping)". Have also tried

Re: JDBC driver for MySQL - storage plugin config and push down ?

2015-10-05 Thread Jacques Nadeau
Have you added the MySQL jdbc driver to the Drill classpath? For better debugging of the issue: drop down to one node and then provide the server side log when you're trying to save/update the jdbc plugin. -- Jacques Nadeau CTO and Co-Founder, Dremio On Mon, Oct 5, 2015 at 5:14 AM, Ulf Andreasso

JDBC driver for MySQL - storage plugin config and push down ?

2015-10-05 Thread Ulf Andreasson @ MapR
Got some questions wrt the JDBC mySQL storage plugin 1) Given that we are getting close to 1.2 and full release of the plugin what is the status of the push down function, which clauses have been supported by push down? 2) Creation of my MySQLDB storage plugin gives me Error "(invalid JSON mappin