Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Select a specific Tez queue for Hive Query inside Hue

Highlighted

Select a specific Tez queue for Hive Query inside Hue

New Contributor

How can I submit a Hive query to a specific Tez queue using Hue? (either Oozie or the Hive Notebook).

 

I tried:

set tez.queue.name="myqueue";
select mycolumn, count(1) from mytable group by mycolumn;

 

Unfortunately this didn't work. The select query still ran as the default queue, which Hue takes as the name of the primary Linux group name of my user that I used to login to Hue.

 

I also tried to set tez.queue.name as myqueue under the "Settings" screen before running my query. Again, Hue accepted the setting, but the queue name didn't change.

 

Thanks!

2 REPLIES 2

Re: Select a specific Tez queue for Hive Query inside Hue

Could you add it in 'Settings' after clicking on the little Cog icon on the
top tight of the snippet?

Then are you trying to have this setting all the time?

Re: Select a specific Tez queue for Hive Query inside Hue

New Contributor

Thanks. Ulimately, we decided to specify a specific yarn queue for each user that's fixed by using the Hive hook. This is because our application requires hive.server2.enable.doAs=false, which doesn't play nicely with a dynamic tez yarn queue setting.