Reply
Explorer
Posts: 23
Registered: ‎04-03-2017

Query Cancel and idle_query_timeout is not working

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

Posts: 642
Topics: 3
Kudos: 121
Solutions: 67
Registered: ‎08-16-2016

Re: Query Cancel and idle_query_timeout is not working

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.
Explorer
Posts: 23
Registered: ‎04-03-2017

Re: Query Cancel and idle_query_timeout is not working

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