07-27-2017 05:48 AM
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 .
07-27-2017 10:35 AM
07-31-2017 02:21 AM
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 .