Setting --idle_session_timeout to a lower value (for example 60 seconds) may cause queries to fail (to be cancelled) with "Session expired due to inactivity".
Currently we are experiencing this only through 3rd party clients (through Cloudera Impala ODBC connector), impala-shell and Hue/Impala query editor works well.
On the ODBC client side the error message is
Based on the Impala documentation running queries should not be killed because of the "idle session timeout":
The --idle_session_timeout option specifies the time in seconds after which an idle session is expired. A session is idle when no activity is occurring for any of the queries in that session, and the session has not started any new queries.
- Set --idle_session_timeout=60
- Set up Cloudera Impala ODBC driver
- Through a 3rd party ODBC client run a bigger query, lasting longer than the session timeout