[ 
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)

Reply via email to