Hi Montoya, This is likely due to the "idle_session_timeout" being set to 3600sec. Can you check the coordinator web UI to get the configured "idle_session_timeout"?
http://IMPALA_COORDINATOR_HOST:25000/varz See this doc for more information on the configurable timeouts: https://impala.apache.org/docs/build/html/topics/impala_timeouts.html Best, Matt On Tue, Apr 3, 2018 at 6:57 AM, Montoya Blanco, A. <a.montoya.bla...@accenture.com> wrote: > Hi, > > > > I get this error: > > > > Caused by: java.sql.SQLException: [Simba][ImpalaJDBCDriver](500051) ERROR > processing query/statement. Error Code: 0, SQL state: > TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:Client session > expired due to more than 3600s of inactivity . > > > > I use JDBC Spring Autoconfigure, and Spring must close the connections > automaticatly , and i believe not is the problem because there are same bugs > with manually close connection : > https://issues.apache.org/jira/browse/IMPALA-1905. > > > > I supose this error is cause because there are sessions inactive opens, so, > Are there any form to close session Impala with JDBC java? > > > > it seems the bug has been fixed in Impala 2.0+, but I use driver impala > 2.5.38.1 to connect Impala 2.10.0-cdh5.13.1 > > > > Can you help me? > > > > Thanks in advance. > > > > > ________________________________ > > This message is for the designated recipient only and may contain > privileged, proprietary, or otherwise confidential information. If you have > received it in error, please notify the sender immediately and delete the > original. Any other use of the e-mail by you is prohibited. Where allowed by > local law, electronic communications with Accenture and its affiliates, > including e-mail and instant messaging (including content), may be scanned > by our systems for the purposes of information security and assessment of > internal compliance with Accenture policy. Your privacy is important to us. > Accenture uses your personal data only in compliance with data protection > laws. For further information on how Accenture processes your personal data, > please see our privacy statement at > https://www.accenture.com/us-en/privacy-policy. > ______________________________________________________________________________________ > > www.accenture.com
