Reply
Highlighted
Explorer
Posts: 10
Registered: ‎04-07-2017

Hive session times out after 60 seconds

All Hive sessions (via Hive JDBC on Squirrel SQL) are closed after 60 seconds of idle time regardless of configuration options:

hive.server2.session.check.interval = 0

hive.server2.idle.operation.timeout = 0

hive.server2.idle.session.timeout = 0

hive.server2.idle.session.timeout_check_operation = false

 

Why are these options effectively ignored and how can it be fixed? Hive version is 1.1.0.

Cloudera Employee
Posts: 126
Registered: ‎03-23-2015

Re: Hive session times out after 60 seconds

Hi Garren,

Where did you check those settings? Is it on the server side or client side?

Hive has client (beeline) and server (hiveserver2), depends on where the setting sit, they might be ignored.

Please locate the hive-site.xml file for HS2 and attach the content here.
Explorer
Posts: 10
Registered: ‎04-07-2017

Re: Hive session times out after 60 seconds

My issue here ended up being brought by Amazon elastic load balancer timing
out after 60 seconds.
Announcements