[HIVE-10725] Better resource management in HiveServer2

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.3.0
• Component/s: HiveServer2, JDBC
• Assignee: Unassigned
• Reporter: Vaibhav Gumashta
• Created: 15/May/15 20:17
• Updated: 01/Oct/19 22:07

Description

We have various ways to control the number of queries that can be run on one HS2 instance (max threads, thread pool queuing etc). We also have ways to run multiple HS2 instances using dynamic service discovery. We should do a better job at:
1. Monitoring resource utilization (sessions, ophandles, memory, threads etc).
2. Being upfront to the client when we cannot accept new queries.
3. Throttle among different server instances in case dynamic service discovery is used.
4. Consolidate existing ways to control #queries into a simpler model.
5. See if we can recommend reasonable values for OS resources or provide alerts if we run out of those.
6. Health reports, server status API (to get number of queries, sessions etc).

Issue Links

• is related to: HIVE-10761 Create codahale-based metrics system for Hive
• is related to: HIVE-20063 Global limit concurrent connections of HiveServer2