Reply
Contributor
Posts: 66
Registered: ‎12-30-2015

How to remove query hanging in impala UI?

Hello,

 

I have some questions about the running queries in Impala UI. ( port:25000 )

There are some queries hanging in `in flight `

Those queries seems dead.

 

I tried to remove it by clicking 'Cancel' button, but I just saw the msg, "Error: Query not yet running"

 

Question 1:

Is there any other way to remove those queries from `in flight` status without restarting impala-server? 

 

Question 2:

Is there any way ( or Impala-server API ) to retrieve all "Completed Queries" at node level?

 

 

Thank you

Cloudera Employee
Posts: 7
Registered: ‎08-26-2014

Re: How to remove query hanging in impala UI?

[ Edited ]

What version of impala are you using?  Would you be able to share the impalad.INFO log file when the problem occurs?

 

Regarding question #2: The web UI is the only way to access the query archive from the impalad itself.  You can increase the number of queries archived using the --query_log_size, or keep track of all queries by setting the option to -1 (note however, that the archive is kept in memory and so if it's set to -1, the memory usage will continue to grow).

Contributor
Posts: 66
Registered: ‎12-30-2015

Re: How to remove query hanging in impala UI?

Hello,

 

Around that time, one of our node went down.

 

Thank you