[jira] [Created] (HIVE-28149) support timeout for hung queries in compilation

["Taraka Rama Rao Lethavadla (Jira)" <ji...@apache.org>]

Taraka Rama Rao Lethavadla created HIVE-28149:
-------------------------------------------------

             Summary: support timeout for hung queries in compilation
                 Key: HIVE-28149
                 URL: https://issues.apache.org/jira/browse/HIVE-28149
             Project: Hive
          Issue Type: Improvement
          Components: Hive
            Reporter: Taraka Rama Rao Lethavadla


Problem statement:

Compilation of a query took 3 days to finish not allowing rest of the commands to compile until that stuck query is killed.

One such issue encountered is due to https://issues.apache.org/jira/browse/HDDS-8041

Customers has to collect thread dumps to see why all queries are not responding and find out the thread that acquire lock and keep on running. Using that thread id, query has to be identified from HS2 logs. Then kill that query to allow rest of the queries to run

https://issues.apache.org/jira/browse/HIVE-12431 is created to kill a query if it did not get compilation lock within the defined time. 

 

In this Jira proposing to have similar timeout feature to kill a query if it is taking more time in compilation than that of the specified timeout



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