Preventing long running queries using the EXEC_TIME_LIMIT_S setting

In Arcadia 4.5 and beyond, there’s a setting that we can take advantage of to help prevent long running queries coming from Arcadia or Impala through the Arcadia Visualization Server (EXEC_TIME_LIMIT_S).

The screenshot below shows how to set the EXEC_TIME_LIMIT_S parameter at a Connection level so that queries will automatically cancel if they’re still in a RUNNING state after 1 hour (3600 seconds).