drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abdel Hakim Deneche <adene...@maprtech.com>
Subject Re: How to specify Drill JDBC connection timeout or JDBC Query timeout
Date Fri, 03 Jun 2016 23:59:15 GMT
You should fill a JIRA asking for this to be implemented. At least this
will be visible to the developers.

Thanks

On Fri, Jun 3, 2016 at 1:01 PM, Hao Zhu <hzhu@maprtech.com> wrote:

> Thanks Hakim.
> Seems the test framework is using JAVA Thread level timeout.
> Is there any chance we implement JDBC api level timeout?
>
> Thanks,
> Hao
>
> On Thu, Jun 2, 2016 at 6:42 PM, Abdel Hakim Deneche <adeneche@maprtech.com
> >
> wrote:
>
> > For connection timeout, there are configuration options that you can set
> in
> > drill-override.conf that affect how much time the Drill client will try
> to
> > connect to the server, but even then the client could actually block
> > forever (I've seen it happen on an internal tool).
> >
> > Drill test framework has a nice mechanism to cancel a query after a
> certain
> > time, you could use it as an inspiration for your own tool:
> >
> >
> >
> https://github.com/mapr/drill-test-framework/blob/master/framework/src/main/java/org/apache/drill/test/framework/CancelingExecutor.java
> >
> >
> > On Thu, Jun 2, 2016 at 6:33 PM, Hao Zhu <hzhu@maprtech.com> wrote:
> >
> > > Hi Team,
> > >
> > > I am trying to create a java code to test the health of each drillbit.
> > > The goal is to use JDBC connection logon each drillbit and run a simple
> > > query.
> > >
> > > However I could not find the way to set either connection timeout or
> > query
> > > timeout.
> > > I checked below api pages:
> > >
> > >
> > >
> >
> https://drill.apache.org/api/1.2/jdbc/org/apache/drill/jdbc/DrillConnection.html
> > >
> > > *setNetworkTimeout*
> > > <
> > >
> >
> https://drill.apache.org/api/1.2/jdbc/org/apache/drill/jdbc/DrillConnection.html#setNetworkTimeout(java.util.concurrent.Executor,%20int)
> > > >
> > > (*Executor*
> > > <
> > >
> >
> http://docs.oracle.com/javase/7/docs/api/java/util/concurrent/Executor.html?is-external=true
> > > >
> > > executor,
> > > int milliseconds)
> > >
> > > *Drill*: Not supported (for non-zero timeout value).
> > >
> > >
> >
> https://drill.apache.org/api/1.2/jdbc/org/apache/drill/jdbc/DrillStatement.html
> > > <
> > >
> >
> https://drill.apache.org/api/1.2/jdbc/org/apache/drill/jdbc/DrillStatement.html
> > > >
> > >
> > > *setQueryTimeout*
> > > <
> > >
> >
> https://drill.apache.org/api/1.2/jdbc/org/apache/drill/jdbc/DrillStatement.html#setQueryTimeout(int)
> > > >
> > > (int milliseconds)
> > >
> > > *Drill*: Not supported (for non-zero timeout value).
> > >
> > > Any suggestions?
> > >
> > > Thanks,
> > > Hao
> > >
> >
> >
> >
> > --
> >
> > Abdelhakim Deneche
> >
> > Software Engineer
> >
> >   <http://www.mapr.com/>
> >
> >
> > Now Available - Free Hadoop On-Demand Training
> > <
> >
> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available
> > >
> >
>



-- 

Abdelhakim Deneche

Software Engineer

  <http://www.mapr.com/>


Now Available - Free Hadoop On-Demand Training
<http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message