[HIVE-11402] HS2 - add an option to disallow parallel query execution within a single Session

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1.1, 2.2.0
• Component/s: HiveServer2
• Labels: TODOC2.1.1 TODOC2.2
• Assignee: Sergey Shelukhin
• Reporter: Thejas Nair
• Created: 29/Jul/15 20:13
• Updated: 15/Sep/17 21:05
• Resolved: 15/Jul/16 02:39

Description

HiveServer2 currently allows concurrent queries to be run in a single session. However, every HS2 session has an associated SessionState object, and the use of SessionState in many places assumes that only one thread is using it, ie it is not thread safe.
There are many places where SesssionState thread safety needs to be addressed, and until then we should serialize all query execution for a single HS2 session. This problem can become more visible with HIVE-4239 now allowing parallel query compilation.

Note that running queries in parallel for single session is not straightforward with jdbc, you need to spawn another thread as the Statement.execute calls are blocking. I believe ODBC has non blocking query execution API, and Hue is another well known application that shares sessions for all queries that a user runs.

Issue Links

• is related to: HIVE-12409 make sure SessionState.initTxnMgr() is thread safe
• relates to: HIVE-4239 Remove lock on compilation stage
• relates to: HIVE-14247 Disable parallel query execution within a session
• links to: RB