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