[IMPALA-6091] Impala Queries Executing long time (long running impala queries)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Information Provided
• Environment: Impala Shell v2.7.0-cdh5.10.1
• Flags: Important
• Epic Color: ghx-label-5
• Assignee: Unassigned
• Reporter: Venkat Atmuri
• Created: 20/Oct/17 14:22
• Updated: 08/Mar/18 19:31
• Resolved: 06/Feb/18 22:37

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.

Issue Links

• relates to: IMPALA-6482 Add query option for query time limit