Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Information Provided
-
None
-
None
-
None
-
None
-
Impala Shell v2.7.0-cdh5.10.1
-
Important
-
ghx-label-5
Description
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.
Attachments
Attachments
Issue Links
- relates to
-
IMPALA-6482 Add query option for query time limit
- Resolved