drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hao Zhu <h...@maprtech.com>
Subject Re: How to specify Drill JDBC connection timeout or JDBC Query timeout
Date Fri, 03 Jun 2016 20:01:19 GMT
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
> >
>

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