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.

How to remove query hanging in impala UI?

How to remove query hanging in impala UI?

Contributor

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

2 REPLIES 2

Re: How to remove query hanging in impala UI?

Cloudera Employee

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

Highlighted

Re: How to remove query hanging in impala UI?

Contributor

Hello,

 

Around that time, one of our node went down.

 

Thank you