[IMPALA-5712] Provide option to cancel queries when in CREATED state

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: Impala 2.7.0
• Component/s: Frontend
• Flags: Important
• Epic Color: ghx-label-8
• Assignee: Unassigned
• Reporter: Mala Chikka Kempanna
• Created: 24/Jul/17 22:59
• Updated: 16/Oct/23 23:01
• Resolved: 16/Oct/23 23:00

Description

At present, there is no-way to cancel queries in CREATED state.

For various reasons, because of connectivity issues with HMS or catalog, queries may sometimes stay in CREATED state longer . And if admission control is implemented, these queries end up occupying admission control queue. (These queries cannot recover from whatever issue they had connecting to HMS even after service becomes normal and stay stuck in CREATED state). And only way to cleanup these queries is the restart the co-ordinator.

But these queries in created state are non-cancellable right now.
They should be available for cancel and be released from Admission control queue.

OR

The queries in CREATED state should not occupy admission control queue.

Issue Links

• is related to: IMPALA-1575 Cancelled queries do not yield resources until close
• relates to: IMPALA-915 Ability to cancel queries while in the FE.
• relates to: IMPALA-6248 Allow cancelling queries while starting fragments