Venkat Atmuri created IMPALA-6091:
-------------------------------------

             Summary: Impala Queries Executing long time (long running impala 
queries)
                 Key: IMPALA-6091
                 URL: https://issues.apache.org/jira/browse/IMPALA-6091
             Project: IMPALA
          Issue Type: Bug
         Environment: Impala Shell v2.7.0-cdh5.10.1
            Reporter: Venkat Atmuri
         Attachments: impala executing time.PNG

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. 

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.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to