11-07-2016 04:26 PM - last edited on 11-08-2016 05:57 AM by cjervis
How can I submit a Hive query to a specific Tez queue using Hue? (either Oozie or the Hive Notebook).
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.
11-07-2016 06:27 PM
12-05-2016 04:58 PM
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.