Hi, I'm trying to use Drill with the sqlline command line on linux but I'm not able to maintain a connection to my drillbits alive long enough to get the results back. The connection is reset after 30 seconds even while a query is running!
I did find the "timeout" variable and set it to -1 but it does not change a thing. The drillbit.log file contains the following lines : 2016-03-24 17:15:37,651 [UserServer-1] INFO o.a.drill.exec.rpc.user.UserServer - RPC connection /39.6.64.15:31010 <--> /39.6.64.22:46641 (user client) timed out. Timeout was set to 30 seconds. Closing connection. Anyone knows where I can modify this setting ? Best regards, Damien -----Message d'origine----- De : Andries Engelbrecht [mailto:[email protected]] Envoyé : jeudi 24 mars 2016 16:47 À : [email protected] Objet : Re: JDBC storage plugin fails I have also seen this fail if the supplied credentials are not valid. With MySQL it can be a bit tricky as credentials can depend on the location of the client, so make sure the MySQL user credentials are for % since Drill is a distributed system and any of the nodes may connect to MySQL. --Andries > On Mar 24, 2016, at 8:39 AM, Christopher Matta <[email protected]> wrote: > > Scott, > Could you paste the JSON you're using to define the MySQL storage > plugin here? I've experienced that you get that error when either the > JSON is invalid, or Drill can't find the class you defined. > > I've created a JIRA to improve this functionality: > https://issues.apache.org/jira/browse/DRILL-4533 > > > > On Thursday, March 24, 2016, Wilburn, Scott > <[email protected]> wrote: > >> Hello, >> I am trying to connect to a mysql database using the jdbc storage >> plugin using Drill 1.5 described here: >> https://drill.apache.org/docs/rdbms-storage-plugin/ >> >> When I try to create the plugin through the web UI, I get the >> following vague error: >> "Please retry: error (unable to create/ update storage)" >> >> I tried to see if more information exists in the drillbit logs, but >> didn't see anything relevant. Does anyone know where I can find a >> better description of the problem, or is JDBC just broken in 1.5? I >> found the following Jira with the same description for 1.2 >> (DRILL-3977). Has it been broken since 1.2, or am I doing something stupid? >> >> Any help would be appreciated. >> >> Thanks, >> Scott Wilburn >> >> > > -- > Chris Matta > [email protected] > 215-701-3146 __________ L'intégrité de ce message n'étant pas assurée sur Internet, la société i-BP ne peut être tenue responsable de son contenu. Si vous n'êtes pas destinataire de ce message, merci de le détruire et d'avertir l'expéditeur. The integrity of this message cannot be guaranteed on the Internet. The i-BP company cannot therefore be considered responsible for the contents. If you are not the intended recipient of this message, then please delete it and notify the sender. __________
