QUERY_TIMEOUT_S Query Option (CDH 5.2 or higher only)

Sets the idle query timeout value for the session, in seconds. Queries that sit idle for longer than the timeout value are automatically cancelled. If the system administrator specified the --idle_query_timeout startup option, QUERY_TIMEOUT_S must be smaller than or equal to the --idle_query_timeout value.

Syntax:

SET QUERY_TIMEOUT_S=seconds;

Type: numeric

Default: 0 (no timeout if --idle_query_timeout not in effect; otherwise, use --idle_query_timeout value)

Added in: CDH 5.2.0 / Impala 2.0.0

Related information:

Setting Timeout Periods for Daemons, Queries, and Sessions