Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Query Cancel and idle_query_timeout is not working

Query Cancel and idle_query_timeout is not working

Explorer

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 REPLIES 2

Re: Query Cancel and idle_query_timeout is not working

Champion
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.

Re: Query Cancel and idle_query_timeout is not working

Explorer

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