We are having the same issue as below. Has anyone found a solution other than restarting the services? We are experiencing the same problem when connecting Tableau with Impala. I've set a short value to the property idle_session_timeout (3 minutes) and I can easily reproduce this. So after those 3 minutes the session is "expired" but shown as "not closed" in Impala daemon WebIUI. Also from command line in the linux box the netstat -nap command shows that the connection from the Tableau server (client) is ESTABLISHED. We use Impala ODBC driver. What I don't understand is why the client should be the one closing the connection? How does the client (eg. Tableau) know about the expired session in Impala after the idle timeout? Is Impala sending such command to the client? Is the ODBC driver provided by Cloudera (acting as the client in this case), missing any "expired session" message? This is a big pain in the neck since the, once the timeout has expired, the users cannot refresh the Tableau dashboard any more, till Tableau or ImpalaD is restarted.
... View more