[ https://issues.apache.org/jira/browse/HIVE-4617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13756390#comment-13756390 ]
Vaibhav Gumashta commented on HIVE-4617: ---------------------------------------- Just for comparison, metastore currently has 200 min and 100,000 max threads. Proposing here, that HS2 has 500 thrift workers and 500 async threads. Also, was thinking of changing the async thread pool to a cached thread pool, which will not keep all 500 threads alive all the time, but will create new threads when required, keeping the unused ones alive for a certain time before purging them. Will be interesting to hear more thoughts. Thanks! > ExecuteStatementAsync call to run a query in non-blocking mode > -------------------------------------------------------------- > > Key: HIVE-4617 > URL: https://issues.apache.org/jira/browse/HIVE-4617 > Project: Hive > Issue Type: Improvement > Components: HiveServer2 > Affects Versions: 0.12.0 > Reporter: Jaideep Dhok > Assignee: Vaibhav Gumashta > Attachments: HIVE-4617.D12417.1.patch, HIVE-4617.D12417.2.patch, > HIVE-4617.D12417.3.patch, HIVE-4617.D12417.4.patch, HIVE-4617.D12417.5.patch, > HIVE-4617.D12417.6.patch, HIVE-4617.D12507.1.patch, HIVE-4617.D12507.2.patch, > HIVE-4617.D12507Test.1.patch > > > Provide a way to run a queries asynchronously. Current executeStatement call > blocks until the query run is complete. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira