Setting yarn queue for hive with beeline

[#1]

I am using HDP 2.4.2 & another environment 2.3.2. I heard through another blog that stating yarn queue during beeline has changed. I can't find any documentation on this. Here is what I am using:

beeline !connect jdbc:hive2://your.host:your.port/data_base?mapred.job.queue.name=your_queue_name

If this is no longer valid please advise how I should be doing it.

[#2 · Accepted solution]

@Sunile Manjee

If you are using MR as execution engine then this command is fine.

If you are using TEZ then I believe you can use below command

beeline !connect jdbc:hive2://your.host:your.port/data_base?tez.queue.name=<queue-name>

Additionally If you want to set one dedicated queue for hive jobs then you can modify tez.queue.name property via Ambari.

There is an option of interactive queues as well if you want to use multiple dedicated queues for hive.

Please see this - https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_performance_tuning/content/section_guide...