Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Increase the number of concurrent session/user in Hive

Highlighted

Increase the number of concurrent session/user in Hive

Explorer

We have 3 node HDP cluster and each have 4C, 16GB RAM. There is only one Hiveserver2 running on master node and at the maximum only 3 users can execute Hive query. Once the 4th user executes the query then Hive server2 stops abruptly and looks like YARN memory is also full. Is it possible to extend the number of concurrent hive sessions/users with the current hardware configuration? Because we dont have budget to increase the hardware and the total data size is around 100GB. Would be good if there is a way to improve the scalability/availability of hive server instance. We are looking for atleast 5-7 concurrent user/sessions. Thanks!!!

Don't have an account?
Coming from Hortonworks? Activate your account here