[HIVE-28149] support timeout for hung queries in compilation

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Hive
• Assignee: Unassigned
• Reporter: Taraka Rama Rao Lethavadla
• Created: 26/Mar/24 07:20
• Updated: 26/Mar/24 07:20

Description

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