Setting yarn queue for hive with beeline

sunile_manjee — Tue, 02 Aug 2016 23:51:55 GMT

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.

Re: Setting yarn queue for hive with beeline

KuldeepK — Wed, 03 Aug 2016 06:15:04 GMT

@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_guidelines_for_interactive_queues.html

question Setting yarn queue for hive with beeline in Archives of Support Questions (Read Only)

Setting yarn queue for hive with beeline

Re: Setting yarn queue for hive with beeline