[ https://issues.apache.org/jira/browse/HIVE-10725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14556979#comment-14556979 ]
Yi Zhang commented on HIVE-10725: --------------------------------- One use case: user can start multiple HS instances with different modes and authentications, it would be nice if a jdbc client with certain connection string connect to the zookeeper assemble, finds a correct HS2 for it. For example, if HS2_A runs in http mode, HS2_B runs in binary mode, client gives binary mode connection string, it should connect to HS2_B, instead of getting HS2_A. > Better resource management in HiveServer2 > ----------------------------------------- > > Key: HIVE-10725 > URL: https://issues.apache.org/jira/browse/HIVE-10725 > Project: Hive > Issue Type: Improvement > Components: HiveServer2, JDBC > Affects Versions: 1.3.0 > Reporter: Vaibhav Gumashta > > 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). -- This message was sent by Atlassian JIRA (v6.3.4#6332)