Reply
Explorer
Posts: 11
Registered: ‎09-13-2017

Impala Queries Executing long time

[ Edited ]

I'm seeing a lot of simple queries like, “SELECT * FROM DATABASE.TABLE”, “SHOW TABLES” and “DESCRIBE database.table that hang around in the list and say they’re Executing, even 90-170 minutes after they’ve completed. 

 

impala executing time.PNG 

 

 

impala executing time2.PNG

I would like to know if there is a way to configure Impala to stop/cancel a long-running query after a certain amount of time.

 

 

 

Found the below link to set time limit but were using TABLEAU so need more time for tableau(6 users) queries.

 

https://www.cloudera.com/documentation/enterprise/latest/topics/impala_query_timeout_s.html

 

It seems like it’s almost necessary to run two instances of Impala (one for Tableau and one for all other requests).

 

Any suggestions?

 

 

 

Thanks.

 

Cloudera Employee
Posts: 228
Registered: ‎03-23-2015

Re: Impala Queries Executing long time

Do your users also use Hue to run Impala queries? Hue will hold the query handler open so that it can do paginations, and it will only kill the handler after user navigates away from the impala page. If user stays on the page, the handler will be kept open and the query is considered as in flight.

Please confirm Hue usage first.

Thanks
New Contributor
Posts: 1
Registered: ‎10-05-2015

Re: Impala Queries Executing long time

How can we ensure if query is completed and its only query handler is open ?

Announcements