@Shivaji See this https://streever.atlassian.net/wiki/pages/viewpage.action?pageId=4390918 Option #1 - Thru the Scripts run in the established connection So now that you have a pool of AM's running, for possibly multiple queue's, who do you get your JDBC session into HS2 to use the desired queue? You need to specify the queue you want in your JDBC session with: Specify Queue in Script
-- (Preferred) But less known property, not so well documented is required for HDP 2.1 . 1
set tez.queue.name=alt;
-- For HDP 2.1 . 3 and above, this property will work.
set mapreduce.job.queuename=alt;
Option #2 - Modify the JDBC URL String to include the queue Specify a Queue in the JDBC Connection String
jdbc:hive2: //localhost:10000?tez.queue.name=alt
Option #3 - Set the Default Queue for Hive Server2 On the server that's running Hive Server2, modify hive-site.xml the include the following: hive-site.xml
< property >
< name >mapreduce.job.queuename</ name >
< value >alt</ value >
</ property >
OR tez-site.xml
< property >
< name >tez.queue.name</ name >
< value >alt</ value >
</ property >
... View more
