my solution is creating a new resource pool with its name same as its user:group. then set the placement rule: "Use the pool root.[primary group], only if the pool exists."   Now looks like impala will choose right resource pool after a user login into impala-shell. it also works at HUE.   however, the further test shows the user has same name with pool becomes able to use every pool!! why??  ... View more