You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Kunal Khatua (JIRA)" <ji...@apache.org> on 2018/09/28 22:51:00 UTC
[jira] [Commented] (DRILL-6661) Need a configurable parameter to
stop Long running queries
[ https://issues.apache.org/jira/browse/DRILL-6661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16632615#comment-16632615 ]
Kunal Khatua commented on DRILL-6661:
-------------------------------------
[~adityaar] there is a JDBC `Statement.setQueryTimeout(int timeInSeconds)` that does this. Any JDBC application should be able to do that.
> Need a configurable parameter to stop Long running queries
> ----------------------------------------------------------
>
> Key: DRILL-6661
> URL: https://issues.apache.org/jira/browse/DRILL-6661
> Project: Apache Drill
> Issue Type: Improvement
> Components: Execution - Monitoring
> Affects Versions: 1.13.0
> Reporter: Aditya Allamraju
> Priority: Major
>
> I am looking for a way to stop any long running queries that run beyond a certain time.
> This is not to be confused with queue timeout which does not trigger if the query has started executing. Other database vendors do this via resource management or a simple timeout.
> Currently, the default behavior is to allow any query in execution to continue till arbitrarily large amount of time until completion.
> There is a genuine need for this case. For instance, i want to stop queries running beyond 15mins.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)