- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Hive Default Queue Won't Work?
- Labels:
-
Apache Hive
-
Apache Tez
Created ‎12-18-2015 10:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Created on ‎12-18-2015 10:43 AM - edited ‎08-19-2019 05:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created ‎09-28-2018 03:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- « Previous
-
- 1
- 2
- Next »