question Re: How to assign the query to YARN Queue, while accessing hive through beeline in Archives of Support Questions (Read Only)

How to assign the query to YARN Queue, while accessing hive through beeline

kotesh_banoth — Fri, 02 Nov 2018 16:22:47 GMT

Re: How to assign the query to YARN Queue, while accessing hive through beeline

sandyy006 — Fri, 02 Nov 2018 16:45:38 GMT

If you are using tez engine:

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

If you are using MR execution engine:

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

Re: How to assign the query to YARN Queue, while accessing hive through beeline

kotesh_banoth — Sat, 17 Aug 2019 23:53:55 GMT

@Sandeep Nemuri

Thanks so much.

One more scenario:

If different business users are accessing hive with different user name from same server. Is it possible when user logins into server and can users query be assigned to predefined queue automatically??

Scenario as Below:

Thanks in advance

Re: How to assign the query to YARN Queue, while accessing hive through beeline

sandyy006 — Fri, 02 Nov 2018 19:49:17 GMT

@kotesh banoth, In this case you can configure yarn queue mapping, This applies to all the applications user is submitting (not only hive/beeline) by default without mentioning the queue name while submitting the app will be submitted to the mapped queue.

Ref: https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.5/bk_yarn-resource-management/content/default_queue_mapping_based_on_user_or_group.html

Hope this helps.

Re: How to assign the query to YARN Queue, while accessing hive through beeline

sandyy006 — Sat, 03 Nov 2018 20:43:12 GMT

@kotesh banoth Feel free to accept this answer if it helped you.

Re: How to assign the query to YARN Queue, while accessing hive through beeline

kotesh_banoth — Mon, 05 Nov 2018 12:32:26 GMT

@Sandeep Nemuri Thanks

Re: How to assign the query to YARN Queue, while accessing hive through beeline

rishit606 — Wed, 10 Apr 2019 19:54:24 GMT

Hi All,

I have a query here.

How to assign a seperate yarn queue when i submit query for hive-hbase integration table ?

By default it goes to default queue.

Appreciate your help please.

thanks,

Rishit Shah

Re: How to assign the query to YARN Queue, while accessing hive through beeline

venk — Tue, 03 Sep 2019 12:13:21 GMT

0: jdbc:mysql://hdp1.demo.lab/hive> set mapred.job.queue.name=root.admin;
Error: Unknown system variable 'job' (state=HY000,code=1193)
0: jdbc:mysql://hdp1.demo.lab/hive> set tez.queue.name=root.admin;
Error: Unknown system variable 'queue' (state=HY000,code=1193)
0: jdbc:mysql://hdp1.demo.lab/hive> SET tez.queue.name=root.admin;
Error: Unknown system variable 'queue' (state=HY000,code=1193)
0: jdbc:mysql://hdp1.demo.lab/hive> SET TEZ.QUEUE.NAME=ROOT.ADMIN
0: jdbc:mysql://hdp1.demo.lab/hive> SET TEZ.QUEUE.NAME=ROOT.ADMIN;
Error: Unknown system variable 'QUEUE' (state=HY000,code=1193)
0: jdbc:mysql://hdp1.demo.lab/hive> set TEZ.queue.name=root.admin;
Error: Unknown system variable 'queue' (state=HY000,code=1193)
0: jdbc:mysql://hdp1.demo.lab/hive> SET tez.queue.name=ROOT.ADMIN;
Error: Unknown system variable 'queue' (state=HY000,code=1193)
0: jdbc:mysql://hdp1.demo.lab/hive> SET tez.queue.name=admin;
Error: Unknown system variable 'queue' (state=HY000,code=1193)
0: jdbc:mysql://hdp1.demo.lab/hive> SET tez.job.queue.name=admin;
Error: Unknown system variable 'job' (state=HY000,code=1193)
0: jdbc:mysql://hdp1.demo.lab/hive>