https://community.cloudera.com/t5/Support-Questions/HiveServer2-Hive-user-s-nofile-ulimit-above-64000/m-p/158328#M120725 <P>In that case, how about setting session expirations if you haven't tried?</P><P>For example,</P><P>set hive.server2.idle.session.check.operation=true; </P><P>set hive.server2.session.check.interval=2h;</P><P>set hive.server2.idle.session.timeout=12h;</P><P>hive.server2.idle.operation.timeout=8h;</P> Fri, 05 Aug 2016 11:43:04 GMT hosako 2016-08-05T11:43:04Z