Thanks much, Uwe. I fixed the JDBC storage plugin doc and added an "Important Unresolved Issues" section to the staged release notes <http://kristinehahn.github.io/drill/docs/apache-drill-1-2-0-release-notes> that covers https://issues.apache.org/jira/browse/DRILL-3958. We probably need to add a few more.
Kristine Hahn Sr. Technical Writer 415-497-8107 @krishahn skype:krishahn On Tue, Oct 20, 2015 at 6:53 AM, Geercken, Uwe <[email protected]> wrote: > Kristine, > > Just a note: > > I tested JDBC access yesterday. What I found out is, that in the URL you > can omit the database name because you anyway have to specify it in the > query. Without specifying it in the query it does not work, so no need to > duplicate the information. > > I also added a Jira today because adding the configuration for the plugin > requires the JDBC driver to be in the 3rdparty folder. If not, then - when > saving the configuration - the UI complains about the JSON syntax while the > error is really that the driver is missing in the 3rdparty folder. > > > Regards, > > Uwe > > -----Original Message----- > From: Kristine Hahn [mailto:[email protected]] > Sent: Dienstag, 20. Oktober 2015 14:16 > To: [email protected] > Subject: Re: Drill 1.2 + RDBMS > > Please see the staged documentation (not yet published on Apache): > http://kristinehahn.github.io/drill/docs/jdbc-storage-plugin/ > > There is an issue (a Jira has been or is being opened) with using > classicmodels or any data using the text type. > > Kristine Hahn > Sr. Technical Writer > 415-497-8107 @krishahn skype:krishahn > > > On Tue, Oct 20, 2015 at 2:26 AM, Devender Yadav < > [email protected]> wrote: > > > Hi, > > > > > > > > With apache drill 1.2, we can query over RDBMS data. > > > > so, I tried to add a plugin for MySQL. I am doing it using the web > client. > > I created a plugin with name mysql and added following configurations: > > > > { > > "type": "jdbc", > > "driver": "com.mysql.jdbc.Driver", > > "uri": "jdbc:mysql://<IP>:3306/classicmodels", > > "username": "root", > > "password": "root", > > "enabled": true > > } > > > > > > It is showing error: > > > > (Invalid JSON mapping) > > > > Any pointer on this. Is there any documentation for that?? > > > > > > > > Regards, > > Devender > > > > ________________________________ > > > > > > > > > > > > > > NOTE: This message may contain information that is confidential, > > proprietary, privileged or otherwise protected by law. The message is > > intended solely for the named addressee. If received in error, please > > destroy and notify the sender. Any use of this email is prohibited > > when received in error. Impetus does not represent, warrant and/or > > guarantee, that the integrity of this communication has been > > maintained nor that the communication is free of errors, virus, > interception or interference. > > >
