Query Cancel and idle_query_timeout is not working

[#1]

Hi ,

We use SQLDX tom cancel query .

When we cancel the query it apears in impalad as waiting to be closed for ages taking resources from the system .

After changing the  parameter idle_query_timeout to 2 minutes , I expected that the canceled query will be canceled after 2 minutes .

and its not .

How it can be sloved .

canceling query from the query monitor does not work at all .

Note we are using HAPROXY and LDAP to connect to Impala .

Please your help .

Thanks

Alon

[#2]

Hmm I don't have an answer but a comment. I am using CDH 5.8.2. I get this same behavior from HUE. Some connections are not closed when the tab is closed. I don't recall the exact state, but we have the idle_query_timeout and idle_session_timeout set to 1 hour and these are closed after that time. So if idle_query isn't working try idle_session. If that doesn't work, there maybe something going one with your specific setup.

[#3]

Hi ,

Idle session works indeed . I have set it to 1 hour but can not wait 1 hour untill killed queries will be dead .

Work arround that I found is disconnecting from the session after query has been cancelled in the UI .

It should work better .

Thanks

Alon