Miklos Szurap created IMPALA-12538:
--------------------------------------

             Summary: Allow clamping of EXEC_TIME_LIMIT_S Query Option per pool
                 Key: IMPALA-12538
                 URL: https://issues.apache.org/jira/browse/IMPALA-12538
             Project: IMPALA
          Issue Type: New Feature
    Affects Versions: Impala 4.3.0
            Reporter: Miklos Szurap


Setting the EXEC_TIME_LIMIT_S (for example to 1800 which equals to 30 minutes 
execution time) is commonly used to protect the cluster against runaway 
queries. This is also suggested in the docs:
https://impala.apache.org/docs/build/html/topics/impala_exec_time_limit_s.html

However currently users can disable this feature with explicitly running the 
{{set EXEC_TIME_LIMIT_S=0}} before their queries. In production environments 
this typically causes all sorts of problems. 
Similarly to the "Clamp MEM_LIMIT Query Option" we could also limit the 
EXEC_TIME_LIMIT_S to a value set by default on the pool level.

Hive solves similar requirements with "config blacklists" (so some SET 
statements are restricted), that could be an alternative but probably too 
restrictive solution.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to