default SQL timeout

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

default SQL timeout

dsetrakyan
Igniters,

Is there any way to set a default SQL timeout for queries? If not, should
we have it?

D.
Reply | Threaded
Open this post in threaded view
|

Re: default SQL timeout

Valentin Kulichenko
To my knowledge, it's only possible to set timeout on query level which
actually can be an issue. Developers and admins do not always have full
control on what is executed on the cluster and may want to set timeout on
server side rather then rely on clients.

Here is the ticket for this:
https://issues.apache.org/jira/browse/IGNITE-7285

-Val

On Tue, Dec 19, 2017 at 7:02 PM, Dmitriy Setrakyan <[hidden email]>
wrote:

> Igniters,
>
> Is there any way to set a default SQL timeout for queries? If not, should
> we have it?
>
> D.
>
Reply | Threaded
Open this post in threaded view
|

Re: default SQL timeout

Vladimir Ozerov
Makes sense. Going forward we should have fine-grained resource control:
max duration (timeouts), max results, etc..

On Fri, Dec 22, 2017 at 1:41 AM, Valentin Kulichenko <
[hidden email]> wrote:

> To my knowledge, it's only possible to set timeout on query level which
> actually can be an issue. Developers and admins do not always have full
> control on what is executed on the cluster and may want to set timeout on
> server side rather then rely on clients.
>
> Here is the ticket for this:
> https://issues.apache.org/jira/browse/IGNITE-7285
>
> -Val
>
> On Tue, Dec 19, 2017 at 7:02 PM, Dmitriy Setrakyan <[hidden email]>
> wrote:
>
> > Igniters,
> >
> > Is there any way to set a default SQL timeout for queries? If not, should
> > we have it?
> >
> > D.
> >
>