Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive session times out after 60 seconds

Hive session times out after 60 seconds

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

Re: Hive session times out after 60 seconds

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.
Highlighted

Re: Hive session times out after 60 seconds

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