Are you communicating with a thrift metastore or a JDBC metastore? I have had connections opened for long periods of time and never remember experiencing them timeout.
Edward On Wed, Aug 1, 2012 at 12:01 PM, Travis Crawford <traviscrawf...@gmail.com> wrote: > Hey Hive gurus - > > Does anyone know how the CLI handles metastore connection timeouts? It > seems if I leave a CLI session idle more than > hive.metastore.client.socket.timeout seconds then run "show tables", > the cli hangs for the timeout then throws a SocketTimeoutException. > Restarting the CLI and running the same "show tables" always works. > > Does anyone else see this? My hive.metastore.client.socket.timeout is > set to 60 - is that a reasonable value? > > --travis