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.
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.