Support Questions

yjiang · ‎12-18-2015

I have set up my HiveServer2 to use 'hive1,hive2' as its default queues. I expect query submitted by the beeline tool would be running in those two queues, but I observed it runs in the 'default' queue.

I also configured sessions per queue on HS2 to 2, but it seems it does not take effect.

I am using Hive on Tez on HDP 2.3.2 and Ambari 2.1.2.1.

Is there any other configurations required to make the Hive default queues and sessions per queue configs work?

gbraccialli3 · ‎12-18-2015

@yjiang

Add tez.queue.name to your custom hiveserver2-site in Ambari and restart hiveserver2, it will make your default queue.

You can also specify the queue when you connect or before submitting your query:

jdbc:hive2://localhost:10000?tez.queue.name=hive2

or

set tez.queue.name=hive2;

Also check this post from @David Streever for more detailed information:

https://streever.atlassian.net/wiki/pages/viewpage.action?pageId=4390918

View solution in original post

pradeep_shetty · ‎09-28-2018

@yjiang

Try adding the below parameter in capacity scheduler of YARN.

yarn.scheduler.capacity.queue-mappings=u:hive:QueueName

So that any query fired using hive cli (as hive user) are being redirected to the queue name that you have provided.

Cloudera Community

Support Questions

Hive Default Queue Won't Work?