Cancelling a Query

Various client applications let you interactively cancel queries submitted or monitored through those applications.

Setting a Time Limit on Query Execution

An Impala administrator can set a default value of the EXEC_TIME_LIMIT_S query option for a resource pool. If a user accidentally runs a large query that executes for longer than the limit, it will be automatically terminated after the time limit expires to free up resources.

You can override the default value per query or per session if you do not want to apply the default EXEC_TIME_LIMIT_S value to a specific query or a session.

Interactively Cancelling a Query

  • In the Impala Web UI for the impalad host (on port 25000 by default), cancel a query: In the /queriestab, click Cancel for a query in the queries in flight list.
  • In impala-shell, press ^C
  • In Hue, click Cancel from the Watch page.
You can manually cancel a query in the Impala Web UI for the impalad host (on port 25000 by default):