10-20-2017 06:41 AM - edited 10-20-2017 07:44 AM
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.
It seems like it’s almost necessary to run two instances of Impala (one for Tableau and one for all other requests).
10-25-2017 03:45 AM