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. >
