I'd like to be able to have users submit some queries to specific resource pools that will give assurance of dedicated resources for those specific queries.

By default users queries are going into their root.username pool - and that behavior is fine.  But once a user has refined their query and we'd like to build an excepted SLA for that query I'd like it to run in a restricted, resource defined pool that I can use to help ensure the resouces that will be dedicated to it.

I have found that mapred.job.queue.name can be used when submitting jobs from command line - but I'd like to be able to do this from Hive/Pig because I mostly have Hive/Pig users.

Thank you.