Support Questions

Find answers, ask questions, and share your expertise

Hive session times out after 60 seconds

avatar
Explorer

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.

2 REPLIES 2

avatar
Super Guru
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.

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